php转换成json数据格式

{ "programmers": [ { "firstName": "Brett", "lastName":"McLaughlin", "email": "aaaa" },
{ "firstName": "Jason", "lastName":"Hunter", "email": "bbbb" },
{ "firstName": "Elliotte", "lastName":"Harold", "email": "cccc" }
],
"authors": [
{ "firstName": "Isaac", "lastName": "Asimov", "genre": "science fiction" },
{ "firstName": "Tad", "lastName": "Williams", "genre": "fantasy" },
{ "firstName": "Frank", "lastName": "Peretti", "genre": "christian fiction" }
],
"musicians": [
{ "firstName": "Eric", "lastName": "Clapton", "instrument": "guitar" },
{ "firstName": "Sergei", "lastName": "Rachmaninoff", "instrument": "piano" }
] }
这样的数据格式是怎么样转换的
我从数据库查出来的数据直接转换的话是
[
{ "firstName": "Eric", "lastName": "Clapton", "instrument": "guitar" },
{ "firstName": "Sergei", "lastName": "Rachmaninoff", "instrument": "piano" }
]
这样的！
因为是分开查询三个表 ，把它组成一条json数据，应该怎么去写

其实就是把这3个结果并成一个数组，再转就是了

例如，
$res1=mysql_query($sql1);

$res2=mysql_query($sql2);

$res3=mysql_query($sql3);

定义一个新的数组 $a = array();

将3个结果压入这个新的数组
array_push($a,$res1);

array_push($a,$res2);

array_push($a,$res3);

最后转义输出
echo json_encode($a);

LZ遇到问题不要气馁呀

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/s77pq8mfq.html