Forums

hey,
I can set and read the json code from database, load in checkbox. Great!

But I have the problem, the "table list". The json data should be listed in this list. How does this work? unfortunately I can't do this.

json string: ["1","2","4"]

The numbers 1, 2, 4, ... should not be displayed. This is the ID value. The values are in an extra table.
----
Table - ListType
ID - value
1 - standard repertoire
2 - concert
3 - Events
4 - appearance
----
Example with the json ID:
ID - Name - JsonString - Edit - Delete
..
1 - My Name - 1, 2, 4 - Edit - delete
2 - My Neme - 1, 3, 4 - Edit - delete
3 - My Name - 1 - Edit - delete


Example how it should be later:
ID - Name - JsonString - Edit - Delete
..
1 - My Name - standard repertoire, concert, appearance - Edit - delete
2 - My Neme - standard repertoire, events, appearance - Edit - delete
3 - My Name - standard repertoire - Edit - delete

Array
(
    [read_listen] => Array
        (
            [result] => Data read successfully!
            [log] => Array
                (
                    [0] => SELECT `Listen`.`id` AS `Listen.id`, `Listen`.`name` AS `Listen.name`, `Listen`.`nameID` AS `Listen.nameID`, `Listen`.`jahr` AS `Listen.jahr`, `Listen`.`typID` AS `Listen.typID`, `Listen`.`chorID` AS `Listen.chorID`, `ListenTyp`.`id` AS `ListenTyp.id`, `ListenTyp`.`name` AS `ListenTyp.name` FROM `intern_veranstaltungen` AS `Listen` LEFT JOIN `intern_veranstaltungen_types` AS `ListenTyp` ON `Listen`.`typID` = `ListenTyp`.`id`;
                )

            [var] => Array
                (
                    [0] => Array
                        (
                            [Listen] => Array
                                (
                                    [id] => 1
                                    [name] => Konzert - Der kleine Tag
                                    [nameID] => DKT_2004
                                    [jahr] => 2004
                                    [typID] => Array
                                        (
                                            [0] => 2
                                        )

                                    [chorID] => 0
                                )

                            [ListenTyp] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [Listen] => Array
                                (
                                    [id] => 2
                                    [name] => Konzert - RK + CL ... es geht wieder los!
                                    [nameID] => Konzert07052022GZ1600
                                    [jahr] => 16:00 Uhr - 07.05.2022
                                    [typID] => Array
                                        (
                                            [0] => 1
                                            [1] => 2
                                            [2] => 4
                                        )

                                    [chorID] => 0
                                )

                            [ListenTyp] => Array
                                (
                                )

                        )

Can you help me? Thanks!