Advanced usage: example with Doctrine

That's not really an advanced topic, but the sample will be a bit hard to read (as it takes many files), so let's say it targets more experienced Symfony users.

In this demo, we're displaying a MyArray of MyElements, both persisted into the database. The MyArray entity only have an id and a name, and MyElement has id, MyArray's id and a value. This is quite the same as we seen in all demos, but persisted.

Array name:
Add an element...

Existing arrays:
Name Open Delete
___ ☘ Cela fonctionne ☘ Open Delete
___array___ Open Delete
---#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
---%23i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
' Open Delete
() Open Delete
#91 Open Delete
%25237233333 Open Delete
%25237233333#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
%252372uuuu Open Delete
%252372uuuu#ie025efbbb0738ed01a63b326c174233e Open Delete
%2525237233333%23ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
%25253F%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
%28SELECT%20%28CASE%20WHEN%20%289680=8265%29%20THEN%20%27kjh%27%20ELSE%20%28SELECT%208265%20UNION%20SELECT%207356%29%20END%29%29 Open Delete
%C3%83%C2%83%C3%82%C2%83%C3%83%C2%82%C3%82%C2%B1sfkjaldsa Open Delete
%C3%83%C2%B1sfkjaldsa Open Delete
%C3%91%C2%82%C3%90%C2%B5%C3%91%C2%81%C3%91%C2%82 Open Delete
%C3%A2%C2%98%C2%98%20Cela%20fonctionne%20%C3%A2%C2%98%C2%98 Open Delete
%E2%98%98%20Cela%20fonctionne%20%E2%98%98 Open Delete
<script>alert('test')</script> Open Delete
<script>alert('test')</script>%n%n%n%n%n%n Open Delete
<script>alert('test')</script>%n%n%n%n%n%n<script>alert('test')</script>%n%n%n%n%n%n<script>alert('test')</script>%n%n%n%n%n%n<script>alert('test')</script>%n%n%n%n%n%n<script>alert('test')</script>%n%n%n%n%n%n<script>alert('test')</script>%n%n%n%n%n%n<sc Open Delete
11%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
11%23ie025efbbb0738ed01a63b326c174233e Open Delete
1111#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
1111#i21ef661e2506d5d0e513dce166c17d49 Open Delete
1111%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
1111%23i27992875ec4286a24e569b1e015b0473 Open Delete
1111%23ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
1111111111111111111111111111111111#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
1111111111111111111111111111111111#i27992875ec4286a24e569b1e015b0473 Open Delete
1111111111111111111111111111111111%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
1111111111111111111111111111111111%23ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
121113 Open Delete
122 Open Delete
1231 Open Delete
1241 Open Delete
15 Open Delete
2 Open Delete
2%27 Open Delete
222222 Open Delete
33 Open Delete
456 Open Delete
5454 Open Delete
63 Open Delete
86787 Open Delete
88 Open Delete
890 Open Delete
99 Open Delete
☘ Cela fonctionne ☘ Open Delete
ñlkjlkj Open Delete
ñsfkjaldsa Open Delete
aaaaa Open Delete
aaaaaa Open Delete
aaaaaaaaaaaaa Open Delete
aaamine22222 Open Delete
aaamine22222%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
aaamine22222%23i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
aaamine22222%23ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
aaamine22222%23ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
aarzarzample Open Delete
aee Open Delete
AlgoSucks Open Delete
array%20new Open Delete
asD Open Delete
asdaexample Open Delete
asdas Open Delete
asdasd Open Delete
asdasd#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
asdasd#ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
asdasd#ie025efbbb0738ed01a63b326c174233e Open Delete
asdasd%23i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
asdasdadasd%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
asdasdadasd%23ie025efbbb0738ed01a63b326c174233e Open Delete
asdfasdfasd8888 Open Delete
asdfg Open Delete
az Open Delete
azerty Open Delete
bjfhj#i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
bjfhj#i5784b3886628c4362594ffa43547edb4 Open Delete
blah%23ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
blah%23ie025efbbb0738ed01a63b326c174233e Open Delete
caracas Open Delete
Caracas222 Open Delete
cdcdc Open Delete
Cela fonctionne Open Delete
cool Open Delete
cups Open Delete
cvSDFSD Open Delete
cx%3Cwc Open Delete
D#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
D#i27992875ec4286a24e569b1e015b0473 Open Delete
D#i5784b3886628c4362594ffa43547edb4 Open Delete
D#i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
D%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
D%23ie025efbbb0738ed01a63b326c174233e Open Delete
dasdsa Open Delete
dasf Open Delete
dd Open Delete
ddazdaz Open Delete
dddd Open Delete
ddddd Open Delete
dfa%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
dfa%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
dfa%23i27992875ec4286a24e569b1e015b0473 Open Delete
dfa%23i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
dfa%23ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
dfdfdf Open Delete
dfty Open Delete
dftydfty Open Delete
dsd Open Delete
dsds Open Delete
ejemplo 2017-11-23 Open Delete
eqweqwe Open Delete
er Open Delete
exam Open Delete
example Open Delete
example%20Radu Open Delete
example123#i21ef661e2506d5d0e513dce166c17d49 Open Delete
example123#i27992875ec4286a24e569b1e015b0473 Open Delete
example123%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
example2222222 Open Delete
example4 Open Delete
exampleasdas Open Delete
exampleasfsafasf Open Delete
exampleasfsafasf%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
exampleasfsafasf%23i27992875ec4286a24e569b1e015b0473 Open Delete
exampleasfsafasf%23i5784b3886628c4362594ffa43547edb4 Open Delete
exampledsdsddasds,sad,a,d,as,d,asd,asd Open Delete
exampleeaze Open Delete
exampleeeeeeeeeeeee Open Delete
examplefffffffffffff Open Delete
examplemmmm Open Delete
examplenhnhd Open Delete
examplesadas Open Delete
examplesadfasfasdf Open Delete
examplesafsaf Open Delete
exampless Open Delete
exampletest_11 Open Delete
exdedededdedeeample Open Delete
Existing%20arr Open Delete
familly Open Delete
fdf#i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
fdf#i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
fdf%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
fdf%23i5784b3886628c4362594ffa43547edb4 Open Delete
fdsf Open Delete
ff Open Delete
ff%20d Open Delete
fff Open Delete
fghjkl Open Delete
fro Delete
fsda Open Delete
fsdfd Open Delete
gdfg%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
geht%20nicht Open Delete
gg Open Delete
gg'A=0 Open Delete
ggg Open Delete
ghfhgfg Open Delete
ghgtytyt Open Delete
ghione Open Delete
ghjk Open Delete
ghjk#i5784b3886628c4362594ffa43547edb4 Open Delete
ghjk#ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
ghk Open Delete
Group%252BC%23i27992875ec4286a24e569b1e015b0473 Open Delete
Group%2BC#i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
gufc fucvuy dd Open Delete
hahah Open Delete
hello Open Delete
hellowrld Open Delete
HEYY%2520:D#i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
HEYY%2520:D#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
HEYY%252520:D%23ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
hgkjh Open Delete
hh Open Delete
hjh Open Delete
how to fight insomnia naturallyTa%20mere%20la%20grosse%20choin Open Delete
http Open Delete
iooi Open Delete
itemList Open Delete
j Open Delete
jb Open Delete
jk Open Delete
jkjk Open Delete
jose Open Delete
jtujjk Open Delete
kaas Open Delete
khj#i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
khj#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
khj#ie025efbbb0738ed01a63b326c174233e Open Delete
khj%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
khj%23i27992875ec4286a24e569b1e015b0473 Open Delete
kj Open Delete
kjh Open Delete
kjh AND 2060=2060-- Qbuj Open Delete
kjh AND 6285=CAST((CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113))||(SELECT (CASE WHEN (6285=6285) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(113)||CHR( Open Delete
kjh AND 6285=CAST((CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113))||(SELECT (CASE WHEN (6285=6285) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)) AS NUMERIC) Open Delete
kjh AND 7390 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(106)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (7390=7390) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(122)+CHA Open Delete
kjh AND 7390 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(106)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (7390=7390) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(122)+CHAR(120)+CHAR(113))) Open Delete
kjh AND 7390 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(106)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (7390=7390) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(122)+CHAR(120)+CHAR(113)))-- iTwS Open Delete
kjh AND 8611=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113)||(SELECT (CASE WHEN (8611=8611) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)||CHR(62))) FROM DUAL)-- iQEG Open Delete
kjh AND 9667 IN (SELECT (CHAR(113)+CHAR(122)+CHAR(107)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (9667=9667) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(106)+CHAR(107)+CHAR(122)+CHAR(113))) Open Delete
kjh AND 9667 IN (SELECT (CHAR(113)+CHAR(122)+CHAR(107)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (9667=9667) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(106)+CHAR(107)+CHAR(122)+CHAR(113)))-- IHOP Open Delete
kjh,),..('"). Open Delete
kjh' AND 2561=2906 AND 'dQSK'='dQSK Open Delete
kjh' AND 6285=CAST((CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113))||(SELECT (CASE WHEN (6285=6285) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)) AS NUMERIC) AND 'ticB'='ticB Open Delete
kjh' AND 7426=7426 AND 'Fjlg'='Fjlg Open Delete
kjh' AND 7954=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(122)||CHR(107)||CHR(120)||CHR(113)||(SELECT (CASE WHEN (7954=7954) THEN 1 ELSE 0 END) FRO Open Delete
kjh' AND 7954=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(122)||CHR(107)||CHR(120)||CHR(113)||(SELECT (CASE WHEN (7954=7954) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(106)||CHR(107)||CHR(122)||CHR(113)||CHR(62))) FROM DUAL) AND 'HwZm'='HwZm Open Delete
kjh' AND 8611=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113)||(SELECT (CASE WHEN (8611=8611) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)||CHR(62))) FROM DUAL) AND 'QXBI'='QXBI Open Delete
kjh' AND 9667 IN (SELECT (CHAR(113)+CHAR(122)+CHAR(107)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (9667=9667) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(106)+CHAR(107)+CHAR(122)+CHAR(113))) AND 'mDsE'='mDsE Open Delete
kjh' AND EXTRACTVALUE(7241,CONCAT(0x5c,0x717a6b7871,(SELECT (ELT(7241=7241,1))),0x716a6b7a71)) AND 'NwvR'='NwvR Open Delete
kjh') AND 6285=CAST((CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113))||(SELECT (CASE WHEN (6285=6285) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)) AS NUMERIC) AND ('bnAs'='bnAs Open Delete
kjh') AND 7390 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(106)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (7390=7390) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(122)+CHAR(120)+CHAR(113))) AND ('dgTV'='dgTV Open Delete
kjh') AND 8864=CAST((CHR(113)||CHR(122)||CHR(107)||CHR(120)||CHR(113))||(SELECT (CASE WHEN (8864=8864) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(106)||CHR(107)||CHR(122)||CHR(113)) AS NUMERIC) AND ('YITY'='YITY Open Delete
kjh') AND 9667 IN (SELECT (CHAR(113)+CHAR(122)+CHAR(107)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (9667=9667) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(106)+CHAR(107)+CHAR(122)+CHAR(113))) AND ('ixOS'='ixOS Open Delete
kjh') AND EXTRACTVALUE(5914,CONCAT(0x5c,0x716a6a7671,(SELECT (ELT(5914=5914,1))),0x71717a7871)) AND ('GoTE'='GoTE Open Delete
kjh') ORDER BY 1-- IuaH Open Delete
kjh"'(,),().( Open Delete
kjh) AND 2060=2060 AND (3370=3370 Open Delete
kjh) AND 7390 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(106)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (7390=7390) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(122)+CHAR(120)+CHAR(113))) AND (2379=2379 Open Delete
kjh) AND 8611=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(106)||CHR(106)||CHR(118)||CHR(113)||(SELECT (CASE WHEN (8611=8611) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(113)||CHR(122)||CHR(120)||CHR(113)||CHR(62))) FROM DUAL) AND (7499=7499 Open Delete
kjh) AND 8864=CAST((CHR(113)||CHR(122)||CHR(107)||CHR(120)||CHR(113))||(SELECT (CASE WHEN (8864=8864) THEN 1 ELSE 0 END))::text||(CHR(113)||CHR(106)||CHR(107)||CHR(122)||CHR(113)) AS NUMERIC) AND (5114=5114 Open Delete
kjh) AND 9667 IN (SELECT (CHAR(113)+CHAR(122)+CHAR(107)+CHAR(120)+CHAR(113)+(SELECT (CASE WHEN (9667=9667) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(106)+CHAR(107)+CHAR(122)+CHAR(113))) AND (2205=2205 Open Delete
kjh) AND EXTRACTVALUE(5914,CONCAT(0x5c,0x716a6a7671,(SELECT (ELT(5914=5914,1))),0x71717a7871)) AND (9337=9337 Open Delete
kjh) AND EXTRACTVALUE(7241 Open Delete
kjh%20AND%207390%20IN%20%28SELECT%20%28CHAR%28113%29+CHAR%28106%29+CHAR%28106%29+CHAR%28118%29+CHAR%28113%29+%28SELECT%20%28CASE%20WHEN%20%287390=7390%29%20THEN%20CHAR%2849%29%20ELSE%20CHAR%2848%29%20END%29%29+CHAR%28113%29+CHAR%28113%29+CHAR%28122%29+CHA Open Delete
kjh%20AND%207954=%28SELECT%20UPPER%28XMLType%28CHR%2860%29%7C%7CCHR%2858%29%7C%7CCHR%28113%29%7C%7CCHR%28122%29%7C%7CCHR%28107%29%7C%7CCHR%28120%29%7C%7CCHR%28113%29%7C%7C%28SELECT%20%28CASE%20WHEN%20%287954=7954%29%20THEN%201%20ELSE%200%20END%29%20FROM%2 Open Delete
kjh%20AND%20EXTRACTVALUE%287241,CONCAT%280x5c,0x717a6b7871,%28SELECT%20%28ELT%287241=7241,1%29%29%29,0x716a6b7a71%29%29--%20fAHu Open Delete
kjh%27%20AND%207954=%28SELECT%20UPPER%28XMLType%28CHR%2860%29%7C%7CCHR%2858%29%7C%7CCHR%28113%29%7C%7CCHR%28122%29%7C%7CCHR%28107%29%7C%7CCHR%28120%29%7C%7CCHR%28113%29%7C%7C%28SELECT%20%28CASE%20WHEN%20%287954=7954%29%20THEN%201%20ELSE%200%20END%29%20FRO Open Delete
kjh%27%20AND%208611=%28SELECT%20UPPER%28XMLType%28CHR%2860%29%7C%7CCHR%2858%29%7C%7CCHR%28113%29%7C%7CCHR%28106%29%7C%7CCHR%28106%29%7C%7CCHR%28118%29%7C%7CCHR%28113%29%7C%7C%28SELECT%20%28CASE%20WHEN%20%288611=8611%29%20THEN%201%20ELSE%200%20END%29%20FRO Open Delete
kjh%27%20ORDER%20BY%201--%20Aifn Open Delete
kjh%27%29%20AND%202750=5826%20AND%20%28%27NRcI%27=%27NRcI Open Delete
kjh%27%29%20AND%209667%20IN%20%28SELECT%20%28CHAR%28113%29+CHAR%28122%29+CHAR%28107%29+CHAR%28120%29+CHAR%28113%29+%28SELECT%20%28CASE%20WHEN%20%289667=9667%29%20THEN%20CHAR%2849%29%20ELSE%20CHAR%2848%29%20END%29%29+CHAR%28113%29+CHAR%28106%29+CHAR%28107% Open Delete
kk Open Delete
kkik Open Delete
kkk#i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
kkk#ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
kkk%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
kkk%23i27992875ec4286a24e569b1e015b0473 Open Delete
kpok%25C2%25B4p Open Delete
l Open Delete
lj Open Delete
lkjlkj Open Delete
Lorenz du Open Delete
m Open Delete
Marcin Open Delete
medicion 2 Open Delete
medicion%202 Open Delete
miTest Open Delete
mm Open Delete
mmm Open Delete
moiGHOY - Resources/views/Advanced/doctrine-them Open Delete
mon%20exemple Open Delete
mon%2520tableau Open Delete
name Open Delete
Names Open Delete
nbnv Open Delete
тест Open Delete
New_test_2017- Open Delete
New%2520Array Open Delete
new%252520test Open Delete
nmn#i27992875ec4286a24e569b1e015b0473 Open Delete
nmn%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
nmn%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
nmn%23ie025efbbb0738ed01a63b326c174233e Open Delete
o%C3%83%C2%84%C3%82%C2%B1 Open Delete
oezjfez Open Delete
okilol Open Delete
ordersCollection Open Delete
Ouiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii Open Delete
ouiou Open Delete
perses Open Delete
perses#ibcac9f4c58199eeaa7ba5c7750b8434b Open Delete
perses%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
po Open Delete
pp Open Delete
pppppii Open Delete
pppppii#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
pppppii%23i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
project%25201 Open Delete
qe Open Delete
qqq Open Delete
qwehgnhngh Open Delete
qwert Open Delete
qwery2 Open Delete
Recipe Open Delete
resr Open Delete
rrrr#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
rrrr#i5784b3886628c4362594ffa43547edb4 Open Delete
rrrr#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
rrrr%23i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
salut%20les Open Delete
samArray Open Delete
sdasd Open Delete
seeme Open Delete
seeme#i1dcd1cbb0d8eeb1fd3a32dc2aa9c8013 Open Delete
seeme#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
seeme%23i1097c8b84b58a65ed6ec7b4f0da3ab67 Open Delete
select Open Delete
sfd Open Delete
some%20new%20array Open Delete
someNewArray#i8c18088ea4d8dd4d6e5e986bceed35da Open Delete
someNewArray#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
someNewArray%23i21ef661e2506d5d0e513dce166c17d49 Open Delete
someNewArray%23i5784b3886628c4362594ffa43547edb4 Open Delete
ssss Open Delete
Ta mere la Open Delete
Ta%2520mere%2520la%2520grosse%2520choin Open Delete
Ta%2520mere%2520la%2520grosse%2520choin#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
TATA Open Delete
terst Open Delete
tesr Open Delete
tesss Open Delete
tesst Open Delete
test34'A=0 Open Delete
testing Open Delete
testN17 Open Delete
testname Open Delete
tesy Open Delete
this%20is%20an Open Delete
toti Open Delete
totototototo Open Delete
trololo Open Delete
try01 Open Delete
tyrtyrtr Open Delete
tzzttz Open Delete
ugghutugituiutu Open Delete
uu Open Delete
Vai%20que%20da Open Delete
Vai%2520que%2520da Open Delete
Volta%252 Open Delete
Volta%2520Di Open Delete
Volta%2520Dilma%2520Fora%25 Open Delete
Volta%2520Dilma%2520Fora%2520Temer Open Delete
Volta%2520Dilma%2520Fora%2520Temer#ic3ee8978c60737ab5d058b5a3f6a1b09 Open Delete
Volta%2520Dilma%2520Fora%2520Temer#ie025efbbb0738ed01a63b326c174233e Open Delete
Volta%252520Dilma%252520Fo Open Delete
Volta+Dilma+Fora+Temer Open Delete
VRE Open Delete
vxvxcvxcv Open Delete
why doctrine on delete not work Open Delete
why%2520doctrine%2520on%2520delete%2520not%2520work%253F Open Delete
Woop%20wooop Open Delete
wxc<wxc Open Delete
Xbox%20Series%20X%20%3E%20PS5 Open Delete
тест Open Delete
File: Base/BaseController.php
<?php

namespace Fuz\AppBundle\Base;

use Fuz\AppBundle\Entity\Value;
use Fuz\AppBundle\Form\ValueType;
use Fuz\QuickStartBundle\Base\BaseController as QuickStartBase;
use Symfony\Component\Form\Extension\Core\Type;
use Symfony\Component\HttpFoundation\Request;

class BaseController extends QuickStartBase
{
    protected function createContextSample(Request $request, $name = 'form', $values = ['a', 'b', 'c'])
    {
        $data = ['values' => $values];

        $form = $this
           ->get('form.factory')
           ->createNamedBuilder($name, Type\FormType::class, $data)
           ->add('values', Type\CollectionType::class, [
               'entry_type'    => Type\TextType::class,
               'label'         => 'Add, move, remove values and press Submit.',
               'entry_options' => [
                   'label' => 'Value',
               ],
               'allow_add'    => true,
               'allow_delete' => true,
               'prototype'    => true,
               'attr'         => [
                   'class' => "{$name}-collection",
               ],
           ])
           ->add('submit', Type\SubmitType::class)
           ->getForm()
        ;

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            $name         => $form->createView(),
            "{$name}Data" => $data,
        ];
    }

    protected function createAdvancedContextSample(Request $request, $name = 'advancedForm')
    {
        $a = new Value('a');
        $b = new Value('b');
        $c = new Value('c');

        $data = ['values' => [$a, $b, $c]];

        $form = $this
           ->get('form.factory')
           ->createNamedBuilder($name, Type\FormType::class, $data)
           ->add('values', Type\CollectionType::class, [
               'entry_type'   => ValueType::class,
               'label'        => 'Add, move, remove values and press Submit.',
               'allow_add'    => true,
               'allow_delete' => true,
               'prototype'    => true,
               'required'     => false,
               'attr'         => [
                   'class' => "{$name}-collection",
               ],
           ])
           ->add('submit', Type\SubmitType::class)
           ->getForm()
        ;

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            $name         => $form->createView(),
            "{$name}Data" => $data,
        ];
    }
}
File: Base/BaseController.php
File: Controller/AdvancedController.php
<?php

namespace Fuz\AppBundle\Controller;

use Fuz\AppBundle\Base\BaseController;
use Fuz\AppBundle\Entity\Address;
use Fuz\AppBundle\Entity\Addresses;
use Fuz\AppBundle\Entity\Fancy;
use Fuz\AppBundle\Entity\FancyCollection;
use Fuz\AppBundle\Entity\Value;
use Fuz\AppBundle\Form\AddressesType;
use Fuz\AppBundle\Form\FancyCollectionType;
use Fuz\AppBundle\Form\MyArrayType;
use Fuz\AppBundle\Form\ValueType;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
use Symfony\Component\Form\Extension\Core\Type;
use Symfony\Component\HttpFoundation\Request;

/**
 * @Route("/advanced")
 */
class AdvancedController extends BaseController
{
    /**
     * Advanced usage
     *
     * You can reference your form collection in the view, instead of
     * putting a selector in the form type.
     *
     * @Route("/mvcCompliance", name="mvcCompliance")
     * @Template()
     */
    public function mvcComplianceAction(Request $request)
    {
        $data = ['values' => ['a', 'b', 'c']];

        $form = $this
           ->createFormBuilder($data)
           ->add('values', Type\CollectionType::class, [
               'entry_type'    => Type\TextType::class,
               'label'         => 'Add, move, remove values and press Submit.',
               'entry_options' => [
                   'label' => 'Value',
               ],
               'allow_add'    => true,
               'allow_delete' => true,
               'prototype'    => true,
               'required'     => false,
//                   'attr' => array (
//                           'class' => 'my-selector', <--- Not MVC compliant!
//                   ),
           ])
           ->add('submit', Type\SubmitType::class)
           ->getForm()
        ;

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            'form' => $form->createView(),
            'data' => $data,
        ];
    }

    /**
     * Advanced usage
     *
     * A custom form theme helps define button's layout and positions as and where you want.
     *
     * @Route("/customFormTheme", name="customFormTheme")
     * @Template()
     */
    public function customFormThemeAction(Request $request)
    {
        $data = ['values' => [new Value('a'), new Value('b'), new Value('c')]];

        $form = $this
           ->createFormBuilder($data)
           ->add('values', Type\CollectionType::class, [
               'entry_type'   => ValueType::class,
               'label'        => 'Add, move, remove values and press Submit.',
               'allow_add'    => true,
               'allow_delete' => true,
               'prototype'    => true,
               'required'     => false,
               'attr'         => [
                   'class' => 'collection',
               ],
           ])
           ->add('submit', Type\SubmitType::class)
           ->getForm()
        ;

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            'form' => $form->createView(),
            'data' => $data,
        ];
    }

    /**
     * Advanced usage
     *
     * Same demo as above, but with the add button located at the bottom of
     * the form instead of close to each field.
     *
     * @Route("/customFormThemeAddBottom", name="customFormThemeAddBottom")
     * @Template()
     */
    public function customFormThemeAddBottomAction(Request $request)
    {
        return $this->customFormThemeAction($request);
    }

    /**
     * Advanced usage
     *
     * Collection of collections are useful on the most dynamic forms, and a good
     * way to test if the plugin is working as expected too.
     *
     * @Route("/collectionOfCollections", name="collectionOfCollections")
     * @Template()
     */
    public function collectionOfCollectionsAction(Request $request)
    {
        $data = [
            'collections' => [
                [new Value('a'), new Value('b'), new Value('c')],
                [new Value('d'), new Value('e'), new Value('f')],
                [new Value('g'), new Value('h'), new Value('i')],
            ],
        ];

        $form = $this
           ->get('form.factory')
           ->createNamedBuilder('form', Type\FormType::class, $data)
           ->add('collections', Type\CollectionType::class, [
               'entry_type'    => Type\CollectionType::class,
               'label'         => 'Add, move, remove collections',
               'entry_options' => [
                   'entry_type'    => ValueType::class,
                   'label'         => 'Add, move, remove values',
                   'entry_options' => [
                       'label' => 'Value',
                   ],
                   'allow_add'      => true,
                   'allow_delete'   => true,
                   'prototype'      => true,
                   'prototype_name' => '__children_name__',
                   'attr'           => [
                       'class' => 'child-collection',
                   ],
               ],
               'allow_add'      => true,
               'allow_delete'   => true,
               'prototype'      => true,
               'prototype_name' => '__parent_name__',
               'attr'           => [
                   'class' => 'parent-collection',
               ],
           ])
           ->add('submit', Type\SubmitType::class)
           ->getForm()
        ;

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            'form' => $form->createView(),
            'data' => $data,
        ];
    }

    /**
     * Advanced usage
     *
     * Looks like there are weird behaviours with Doctrine:
     * https://github.com/ninsuo/symfony-collection/issues/7
     * Let's test that live!
     *
     * ... hmm, doesn't look bad anyway
     *
     * @Route(
     *      "/usageWithDoctrine/{name}",
     *      name = "usageWithDoctrine",
     *      defaults = {
     *          "name" = "example"
     *      }
     * )
     * @Template()
     */
    public function usageWithDoctrineAction(Request $request, $name)
    {
        $repo = $this->getDoctrine()->getRepository('FuzAppBundle:MyArray');

        $data = $repo->findOneByName($name);
        if (is_null($data)) {
            $data = $repo->create($name);
        }

        $form = $this->createForm(MyArrayType::class, $data);
        $form->handleRequest($request);

        $form->get('save')->isClicked() && $form->isValid() && $repo->save($data);

        return [
            'names' => $repo->getArrayNames(),
            'form'  => $form->createView(),
            'data'  => $data,
        ];
    }

    /**
     * Related to usageWithDoctrine demo
     *
     * @Route(
     *      "/usageWithDoctrineDelete/{name}",
     *      name = "usageWithDoctrineDelete"
     * )
     */
    public function usageWithDoctrineDeleteAction(Request $request, $name)
    {
        $repo = $this->getDoctrine()->getRepository('FuzAppBundle:MyArray');
        if (!is_null($data = $repo->findOneByName($name))) {
            $repo->delete($data);
        }

        return $this->forward('FuzAppBundle:Advanced:usageWithDoctrine', [
            'name' => 'example',
        ]);
    }

    /**
     * A form having a theme and containing several fields
     *
     * @Route(
     *      "/formHavingSeveralFields",
     *      name = "formHavingSeveralFields"
     * )
     * @Template()
     */
    public function formHavingSeveralFieldsAction(Request $request)
    {
        $address = new Address();
        $address->setName('Mickael Steller');
        $address->setCompany('fuz.org');
        $address->setStreet('41 rue de la Paix');
        $address->setPostalcode('75002');
        $address->setCity('Paris');
        $address->setCountry('France');

        $addresses = new Addresses();
        $addresses->getAddresses()->add($address);

        $form = $this->createForm(AddressesType::class, $addresses);
        if ($request->isMethod('POST')) {
            $form->handleRequest($request);
        }

        return [
            'form' => $form->createView(),
            'data' => $addresses,
        ];
    }

    /**
     * Another example of form theme
     *
     * @Route(
     *      "/fancyFormTheme",
     *      name = "fancyFormTheme"
     * )
     * @Template()
     */
    public function fancyFormThemeAction(Request $request)
    {
        $fancyCollection = new FancyCollection();

        for ($i = 0; $i < 3; $i++) {
            $fancy = new Fancy();
            $fancyCollection->getFancyCollection()->add($fancy);
        }

        $form = $this->createForm(FancyCollectionType::class, $fancyCollection);

        $form->handleRequest($request);
        if ($form->isValid()) {
            $data = $form->getData();
        }

        return [
            'form' => $form->createView(),
            'data' => $fancyCollection,
        ];
    }
}
File: Controller/AdvancedController.php
File: Entity/MyArray.php
<?php

namespace Fuz\AppBundle\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * MyArray
 *
 * @ORM\Table(
 *      name="my_array",
 *      uniqueConstraints={@ORM\UniqueConstraint(name="name_idx", columns={"name"})}
 * )
 * @ORM\Entity(repositoryClass="Fuz\AppBundle\Repository\MyArrayRepository")
 */
class MyArray
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255)
     */
    protected $name;

    /**
     * @var ArrayCollection
     *
     * @ORM\OneToMany(targetEntity="MyElement", mappedBy="array", cascade={"all"}, orphanRemoval=true)
     */
    protected $elements;

    public function __construct()
    {
        $this->elements = new ArrayCollection();
    }

    public function getId()
    {
        return $this->id;
    }

    public function getName()
    {
        return $this->name;
    }

    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    public function getElements()
    {
        return $this->elements;
    }
}
File: Entity/MyArray.php
File: Entity/MyElement.php
<?php

namespace Fuz\AppBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * MyElement
 *
 * @ORM\Table(name="my_element"),
 * @ORM\Entity
 */
class MyElement
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @var MyArray
     *
     * @ORM\ManyToOne(targetEntity="MyArray", inversedBy="elements")
     * @ORM\JoinColumn(name="my_array_id", referencedColumnName="id")
     */
    protected $array;

    /**
     * @var string
     *
     * @ORM\Column(name="value", type="string", length=255)
     */
    protected $value;

    public function setId($id)
    {
        $this->id = $id;

        return $this;
    }

    public function getId()
    {
        return $this->id;
    }

    public function setArray(MyArray $array)
    {
        $this->array = $array;

        return $this;
    }

    public function getArray()
    {
        return $this->array;
    }

    public function setValue($value)
    {
        $this->value = $value;

        return $this;
    }

    public function getValue()
    {
        return $this->value;
    }
}
File: Entity/MyElement.php
File: Form/MyArrayType.php
<?php

namespace Fuz\AppBundle\Form;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\Extension\Core\Type\CollectionType;
use Symfony\Component\Form\Extension\Core\Type\SubmitType;
use Symfony\Component\Form\Extension\Core\Type\TextType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolver;

class MyArrayType extends AbstractType
{
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder->add('name', TextType::class, [
                'label' => 'Array name:',
        ]);

        $builder->add('elements', CollectionType::class, [
            'label'        => 'Add an element...',
            'entry_type'   => MyElementType::class,
            'allow_add'    => true,
            'allow_delete' => true,
            'prototype'    => true,
            'required'     => false,
            'by_reference' => true,
            'delete_empty' => true,
            'attr'         => [
                'class' => 'doctrine-sample',
            ],
        ]);

        $builder->add('save', SubmitType::class, [
                'label' => 'Save this array',
        ]);
    }

    public function configureOptions(OptionsResolver $resolver)
    {
        $resolver->setDefaults([
            'data_class' => 'Fuz\AppBundle\Entity\MyArray',
        ]);
    }

    public function getBlockPrefix()
    {
        return 'my_array';
    }
}
File: Form/MyArrayType.php
File: Form/MyElementType.php
<?php

namespace Fuz\AppBundle\Form;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\Extension\Core\Type\TextType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolver;

class MyElementType extends AbstractType
{
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder->add('value', TextType::class, [
            'required' => false,
        ]);
    }

    public function configureOptions(OptionsResolver $resolver)
    {
        $resolver->setDefaults([
            'data_class' => 'Fuz\AppBundle\Entity\MyElement',
        ]);
    }

    public function getBlockPrefix()
    {
        return 'my_element';
    }
}
File: Form/MyElementType.php
File: Repository/MyArrayRepository.php
<?php

namespace Fuz\AppBundle\Repository;

use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
use Doctrine\ORM\EntityRepository;
use Fuz\AppBundle\Entity\MyArray;

/**
 * MyArrayRepository.
 */
class MyArrayRepository extends EntityRepository
{
    public function create($name)
    {
        $data = new MyArray();
        $data->setName($name);
        try {
            $this->_em->persist($data);
            $this->_em->flush();
        } catch (UniqueConstraintViolationException $e) {
            return null;
        }

        return $data;
    }

    public function save(MyArray $data)
    {
        foreach ($data->getElements() as $element) {
            $element->setArray($data);
        }
        try {
            $this->_em->persist($data);
            $this->_em->flush();
        } catch (UniqueConstraintViolationException $e) {
            return null;
        }

        return $data;
    }

    public function getArrayNames()
    {
        $arrays = $this
            ->_em
            ->createQuery("
               SELECT arr.name
               FROM Fuz\AppBundle\Entity\MyArray arr
            ")
            ->execute();
        $names = [];
        foreach ($arrays as $array) {
            $names[] = $array['name'];
        }

        return $names;
    }

    public function delete(MyArray $data)
    {
        foreach ($data->getElements() as $element) {
            $this->_em->remove($element);
        }
        $this->_em->remove($data);
        $this->_em->flush();
    }
}
File: Repository/MyArrayRepository.php
File: Resources/views/Advanced/doctrine-theme.html.twig

{% block my_element_label %}{% endblock %}
{% block my_element_errors %}{% endblock %}

{% block my_element_widget %}

    <div class="row">
        <div class="col-md-7">
            {{ form_widget(form.value) }}
        </div>
        <div class="col-md-2">
            <a href="#" class="collection-up btn btn-default">Up</a>
            <a href="#" class="collection-down btn btn-default">Down</a>
        </div>
        <div class="col-md-2">
            <a href="#" class="collection-remove btn btn-default">Remove</a>
            <a href="#" class="collection-add btn btn-default">Add</a>
        </div>
        <div class="col-md-1">
            <a href="#" class="collection-duplicate btn btn-default">Duplicate</a>
        </div>
    </div>

{% endblock %}
File: Resources/views/Advanced/doctrine-theme.html.twig
File: Resources/views/Advanced/usageWithDoctrine.html.twig
{% extends 'FuzAppBundle::layout.html.twig' %}

{% block extra_js %}
    <script src="{{ asset('js/jquery.collection.js') }}"></script>
{% endblock %}

{% block title %}Advanced usage: example with Doctrine{% endblock %}

{% block body %}

    <h2>{{ block('title') }}</h2>

    <p>
        That's not really an <i>advanced</i> topic, but the sample will be a bit hard to read (as it takes many files),
        so let's say it targets more experienced Symfony users.
    </p>

    <p>
        In this demo, we're displaying a MyArray of MyElements, both persisted into the database. The MyArray entity
        only have an id and a name, and MyElement has id, MyArray's id and a value. This is quite the same as we seen
        in all demos, but persisted.
    </p>

    <div class="text-center">
        <input type="button" id="new" class="btn btn-default" value="Create new array"/>
    </div>

    {%
        form_theme form
            'jquery.collection.html.twig'
            'FuzAppBundle:Advanced:doctrine-theme.html.twig'
    %}
    {{ form(form) }}

    <hr/>

    {% if names|length %}
        Existing arrays:
        <table class="table">
            <thead>
                <th>Name</th>
                <th>Open</th>
                <th>Delete</th>
            </thead>
            <tbody>
                {% for name in names %}
                    <tr>
                        <td>{{ name }}</td>
                        <td>
                            {% if data.name != name %}<a href="{{ path('usageWithDoctrine', {'name': name}) }}">Open</a>{% endif %}
                        </td>
                        <td><a href="{{ path('usageWithDoctrineDelete', {'name': name}) }}">Delete</a></td>
                    </tr>
                {% endfor %}
            </tbody>
        </table>
    {% endif %}

    {{
        tabs([
            'Base/BaseController.php',
            'Controller/AdvancedController.php',
            'Resources/views/Advanced/usageWithDoctrine.html.twig',
            'Resources/views/Advanced/doctrine-theme.html.twig',
            'Entity/MyArray.php',
            'Form/MyArrayType.php',
            'Entity/MyElement.php',
            'Form/MyElementType.php',
            'Repository/MyArrayRepository.php',
        ])
    }}

{% endblock %}

{% block script %}

    <script type="text/javascript">

        // only useful for the "new" button...
        $('#new').on('click', function() {
           var name = prompt("Which name would you like to use?");
           if (name) {
               var uri = '{{ path('usageWithDoctrine', {'name': 'a'}) }}';
               document.location = uri.substr(0, uri.length - 1) + encodeURIComponent(name);
           }
        });

        $('.doctrine-sample').collection();

    </script>

{% endblock %}
File: Resources/views/Advanced/usageWithDoctrine.html.twig