如何在PHP MySql中使用数组结构编码Json？

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.

Answer 1

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)