How to convert result set to json in php

php method to convert the result set to json: first store the data in the database into an array; then encode the array; finally use the "json_encode" function to encode json and print the result.

Recommended: "PHP Video Tutorial"

PHP converts the database query content into JSON format and Display Chinese

Recently writing android, started writing server. In the end, the language of the server was decided to be PHP. Because I had written web pages for a while before, I tried PHP first.

So first of all, in order to realize the interaction between the android front-end and the server, the data transmitted by our server must first be changed to JSON format.

So how to query the content in the database and convert it into JSON format? The code is as follows:

if(isset($_GET["userid"])){
    $userid=$_GET["userid"];
    echo $userid;
    $sql="select * from user where userid='$userid'";
}
$result=mysqli_query($conn,$sql);
if (!$result) {
    printf("Error: %s\n", mysqli_error($conn));
    exit();
}
 
$jarr = array();
while ($rows=mysqli_fetch_array($result,MYSQL_ASSOC)){
    $count=count($rows);//不能在循环语句中，由于每次删除 row数组长度都减小
    for($i=0;$i<$count;$i++){
        unset($rows[$i]);//删除冗余数据
    }
    array_push($jarr,$rows);
}
print_r($jarr);//查看数组
echo "<br/>";
 
echo &#39;<hr>&#39;;
 
echo &#39;编码后的json字符串：&#39;;
echo $str=json_encode($jarr,JSON_UNESCAPED_UNICODE);//将数组进行json编码
echo &#39;<br>&#39;;
$arr=json_decode($str);//再进行json解码
echo &#39;解码后的数组：&#39;;
print_r($arr);//打印解码后的数组，数据存储在对象数组中
mysqli_close($conn);

In fact, the principle is very simple, that is, after storing the data in the database into an array, the array is then encoded. However, what we need to pay attention to is that if there is Chinese in the database, and after JSON encoding it, we still want to make it Chinese. We need to add an option to json_encode(), JSON_UNESCAPED_UNICODE. That is to avoid using utf-8 encoding for Chinese. The above code has been implemented.

The above is the detailed content of How to convert result set to json in php. For more information, please follow other related articles on the PHP Chinese website!