php 多个json对象,php – 在一个对象json中两个查询mysql

我想你可以尝试这个

$result = mysql_query("SELECT * FROM data where id='123456'");

$fetch = mysql_query("SELECT name,age,city FROM people where id='123456'");

// I think, you'll get a single row, so no need to loop

$json = mysql_fetch_array($result, MYSQL_ASSOC);

$json2 = array();

while ($row = mysql_fetch_assoc($fetch)){

$json2[] = array(

'name' => $row["name"],

'age' => $row["age"],

'city' => $row["city"]

);

}

$json['people'] = $json2;

echo json_encode($json);

print_r($json)的结果应该是这样的

Array

(

[date] => 2013-07-20

[year] => 2013

[id] => 123456

[people] => Array

(

[0] => Array

(

[name] => First

[age] => 60

[city] => 1

)

[1] => Array

(

[name] => second

[age] => 40

[city] => 2

)

)

)

echo json_encode($json)的结果应该是

{

"date" : "2013-07-20",

"year":"2013",

"id":"123456",

"people":

[

{

"name" : "First",

"age" : "60",

"city" : "1"

},

{

"name" : "second",

"age" : "40",

"city" : "2"

}

]

}

如果你回复json_encode(array($json))那么你将把你的整个json包装成一个数组,就像这样

[

{

"date" : "2013-07-20",

"year":"2013",

"id":"123456",

"people":

[

{

"name" : "First",

"age" : "60",

"city" : "1"

},

{

"name" : "second",

"age" : "40",

"city" : "2"

}

]

}

]