How to Encode Json with Arrays Structure in PHP MySql?

Question

I have 2 tables in MySql

Section

ID       Name
=====================
1        Section1
2        Section2

Category

ID        SectionID     Name
=========================================
1           1           Category1
2           1           Category2
3           2           Category3

How can I decode JSON from PHP to get the result that looks like this:

{sections:[
{sectionName: "Section1", categoryList: [{categoryName: "category1"},{categoryName: "category2"}]},
{sectionName: "Section1", categoryList: [{categoryName: "category3"}]}
]}

This is what I have now:
$sql_section = "select * from section";
$sql_category = "select * from category";

Any suggestions? thanks.

Exact same question http://stackoverflow.com/questions/11982529/how-to-design-an-array-structure-and-encode-to-json-using-php — code-jaff, Aug 16 '12 at 08:49

score 0 · Accepted Answer · answered Aug 16 '12 at 06:50

0

Assuming you mean encode. You simply need to make an array with the same structure of the json that you want and then use $json = json_encode($my_array)

answered Aug 16 '12 at 06:50

The Disintegrator

4,147
9
35
43

How to Encode Json with Arrays Structure in PHP MySql?

1 Answers1