1
Vývoj / Zobrazení vztahu rodič/potomek pomoci optgroup
« kdy: 17. 03. 2020, 18:44:55 »
Pro navigaci na strankach bych rad pouzil model uvedeny na (http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql)
vysledkem v databazi je
Vysledny JSON je nasledujici:
Rad bych pomoci select - optgroup zobrazil "mnozinu potomku" kazdeho rodice. Bohuzel si moc nevim rady jak logicky postupovat tak abych do budoucna zobrazil "nekonecny" pocet vnoreni.
vysledkem v databazi je
Kód: [Vybrat]
+----+----------------------+-----+-----+
| id | name | lft | rgt |
+----+----------------------+-----+-----+
| 1 | ELECTRONICS | 1 | 20 |
| 2 | TELEVISIONS | 2 | 9 |
| 3 | TUBE | 3 | 4 |
| 4 | LCD | 5 | 6 |
| 5 | PLASMA | 7 | 8 |
| 6 | PORTABLE ELECTRONICS | 10 | 19 |
| 7 | MP3 PLAYERS | 11 | 14 |
| 8 | FLASH | 12 | 13 |
| 9 | CD PLAYERS | 15 | 16 |
| 10 | 2 WAY RADIOS | 17 | 18 |
+----+----------------------+-----+-----+
Vysledny JSON je nasledujici:
Kód: [Vybrat]
{
"name": "ELECTRONICS",
"lft": "1",
"rgt": "20"
},
{
"name": " TELEVISIONS",
"lft": "2",
"rgt": "9"
},
{
"name": " TUBE",
"lft": "3",
"rgt": "4"
},
{
"name": " LCD",
"lft": "5",
"rgt": "6"
},
{
"name": " PLASMA",
"lft": "7",
"rgt": "8"
},
{
"name": " PORTABLE ELECTRONICS",
"lft": "10",
"rgt": "19"
},
{
"name": " MP3 PLAYERS",
"lft": "11",
"rgt": "14"
},
{
"name": " FLASH",
"lft": "12",
"rgt": "13"
},
{
"name": " CD PLAYERS",
"lft": "15",
"rgt": "16"
},
{
"name": " 2 WAY RADIOS",
"lft": "17",
"rgt": "18"
}
Rad bych pomoci select - optgroup zobrazil "mnozinu potomku" kazdeho rodice. Bohuzel si moc nevim rady jak logicky postupovat tak abych do budoucna zobrazil "nekonecny" pocet vnoreni.