php mysql 生成json_从PHP MySQL结果创建JSON对象

你可以尝试这个,获取数据并推送到数组,然后回显该数组

$info=array();

while($row = mysql_fetch_array($res,MYSQL_ASSOC)){

array_push($info,$row);

}

echo json_encode($info);

会回来的

array(2) { [0]=> array(3) { ["id"]=> string(1) "1" ["firstname"]=> string(3) "foo" ["lastname"]=> string(3) "bar" } [1]=> array(3) { ["id"]=> string(1) "2" ["firstname"]=> string(3) "foo" ["lastname"]=> string(3) "bar" } }

JSON

[{"id":"1","firstname":"foo","lastname":"bar"},{"id":"2","firstname":"foo","lastname":"bar"}]