如何json编码格式?
问题描述:
i'm trying to get some json print. I have a simple format but i didn't figure it out.
But my result is like that. {"datas":{"title":"table"}}
$sql = "SELECT * FROM mytable";
$check = mysqli_fetch_array(mysqli_query($con,$sql));
$array = array("table"=>$check["title"]);
$result=json_encode(array('datas' => $array));
echo($result);
mysqli_close($con);
I need this is my format {"datas":[{"0":"table","title":"table"}]}
I guess i miss something.
我正在尝试获取一些json打印。 我有一个简单的格式,但我没有想出来。 p>
但我的结果就是这样。 我需要这是我的格式 我想我错过了什么。 p>
{“datas”:{“title”:“table”}} code> p>
$ sql =“SELECT * FROM mytable”;
$ check = mysqli_fetch_array(mysqli_query($ con,$ sql));
$ array = array(“table”=> $ check [“title”]);
$ result = json_encode(array('datas'=> $ array));
echo($ result);
mysqli_close($ con);
code> pre>
{“datas “:[{”0“:”table“,”title“:”table“}}} code> p>
答
You should use this:
$sql = "SELECT * FROM mytable";
$check = mysqli_fetch_assoc(mysqli_query($con,$sql));
$array = array("table"=>$check["title"]);
$result=json_encode(array('datas' => $array));
echo($result);
mysqli_close($con);