How to get an hierarchical php structure from a db table, in php array, or JSON
- by daniel
Hi guys, can you please help me. How to get an hierarchical php structure from a db table, in php array, or JSON, but with the following format:
[{ "attributes" : {"id" : "111"}, "data" : "Some node title", "children" : [ { "attributes" : { "id" : "555"}, "data" : "A sub node title here" } ], "state" : "open" }, { "attributes" : {"id" : "222"}, "data" : "Other main node", "children" : [ { "attributes" : { "id" : "666"}, "data" : "Another sub node" } ], "state" : "open" }]
My SQL table contains the fields: ID, PARENT, ORDER, TITLE
Can you please help me with this? I'm going crazy trying to get this.
Many thanks in advance.
Daniel