How can I combine multiple json strings into one? This post was last edited by sigkl00181 from 2015-04-PM & nbsp; $ question & nbsp; $ _ GET [question]; & nbsp; & how to combine multiple json into one?
This post was last edited by sigkl00181 on 14:15:39
$question = $_GET['question'];
$arr = explode("|",$question);
for($i = 0;$i <= 3; $i++){
$rid = $arr[$i];
$sql = "select * from xs_radio where rid = '$rid'";
$result = mysql_query($sql);
$arr = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$ar[] = $row;
}
$js = json_encode($ar);
echo $js;
}
This is the query statement.
[{"rid":"1","title":"\u6211\u662f\u8c01","a":"\u5b8b\u5411\u4e1c","b":"\u9b4f\u4eae","c":"\u738b\u514b\u5a07","d":"\u5b8b\u5b50\u6587","answer":"\u5b8b\u5411\u4e1c"}]
[{"rid":"2","title":"\u6211\u662f\u8c01","a":"\u9b4f\u4eae","b":"\u5218\u5fb7\u534e","c":"\u674e\u5a1c","d":"\u5f20\u626c","answer":"\u9b4f\u4eae"}]
[{"rid":"3","title":"\u6211\u662f\u8c01","a":"\u9b4f\u4eae","b":"\u738b\u514b\u5a07","c":"\u674e\u56fd\u4f1f","d":"\u738b\u83f2","answer":"\u738b\u514b\u5a07"}]
[{"rid":"16","title":"\u6211\u662f\u8c01","a":"\u5218\u5f66\u5bbe","b":"\u674e\u56fd\u632f","c":"\u7a0b\u79c0\u82b9","d":"\u738b\u514b\u5a07","answer":"\u738b\u514b\u5a07"}]
The query result. How can we combine the three json files into one?
[{"rid":"1","title":"\u6211\u662f\u8c01","a":"\u5b8b\u5411\u4e1c","b":"\u9b4f\u4eae","c":"\u738b\u514b\u5a07","d":"\u5b8b\u5b50\u6587","answer":"\u5b8b\u5411\u4e1c"},
{"rid":"2","title":"\u6211\u662f\u8c01","a":"\u9b4f\u4eae","b":"\u5218\u5fb7\u534e","c":"\u674e\u5a1c","d":"\u5f20\u626c","answer":"\u9b4f\u4eae"},
{"rid":"3","title":"\u6211\u662f\u8c01","a":"\u9b4f\u4eae","b":"\u738b\u514b\u5a07","c":"\u674e\u56fd\u4f1f","d":"\u738b\u83f2","answer":"\u738b\u514b\u5a07"},
{"rid":"16","title":"\u6211\u662f\u8c01","a":"\u5218\u5f66\u5bbe","b":"\u674e\u56fd\u632f","c":"\u7a0b\u79c0\u82b9","d":"\u738b\u514b\u5a07","answer":"\u738b\u514b\u5a07"}]
Save it as this.
------ Solution ----------------------
Convert to array, then synthesize an array, and then convert to json
------ Solution ----------------------
Set $ ar [] = $ row;
Change to $ ar [$ I] [] = $ row;
Set
$ Js = json_encode ($ ar );
Echo $ js;
Move to the end of the for loop