php mysql生成 json数据,通过PHP将MySQL数据转换为JSON

Basically idea is to grab data from MySQL table and transform it to JSON.

This is how database table looks:

And this how should output be:

[

{"group1":[

{"val":"somevalue"},

{"val":"somevalue"}

]

},

{"group2":[

{"val":"somevalue"},

{"val":"somevalue"}

]

},

{"group3":[

{"val":"somevalue"}

]

}

]

My PHP script looks like this, for now:

$arr = [];

$result = mysql_query("SELECT * FROM thetable WHERE section='sect1'");

while($row = mysql_fetch_array($result))

{

// ???

}

echo json_encode($arr);

My main issue is how to output/sort data in "groups".

Thanks for your help!

解决方案

try this

while($row = mysql_fetch_array($result))

{

$arr[$row['group']][] = array('val' => $row['value']);

}