php改json数据格式的问题

qq_16725633 2016-04-18 07:26:28

<?php
header("Content-Type: text/html; charset=UTF-8");
$con = mysql_connect("localhost","root","root");
if (!$con)//判断是否连接成功
{
die('Could not connect: ' . mysql_error());
}
mysql_set_charset('utf8',$con);//指定连接数据库的编码
mysql_select_db("emp");

$q=mysql_query("SELECT * FROM tianqi ");//取出tianqi中所有的数据

while($en=mysql_fetch_object($q))

echo json_encode($en,JSON_UNESCAPED_UNICODE);//打印结果

exit;
mysql_close();


大家看下我这个代码 我发出去的值是这样的{"id":"1","location":"汉字","oxygen":"3.33","negative":"23.2","humidity":"22","temp":"2.33","pm":"6"}{"id":"4","location":"百度","oxygen":"13","negative":"151","humidity":"1","temp":"1","pm":"1151"}
但是我想把发出去的这段代码改成这样:[{"id":"1","location":"汉字","oxygen":"3.33","negative":"23.2","humidity":"22","temp":"2.33","pm":"6"}{"id":"4","location":"百度","oxygen":"13","negative":"151","humidity":"1","temp":"1","pm":"1151"}]
也就是给这段代码加一个中括号,请问下怎么改。
...全文
88 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
一起混吧 2016-04-19
  • 打赏
  • 举报
回复
$arr = array();
while($en=mysql_fetch_object($q))
     $arr[] = $en;
echo json_encode($arr,JSON_UNESCAPED_UNICODE);//打印结果 
exit;
qq_16725633 2016-04-18
  • 打赏
  • 举报
回复
 while($en=mysql_fetch_object($q))
   	
	echo json_encode(array($en),JSON_UNESCAPED_UNICODE);//打印结果 

    exit;
我改了这个,结果是这样[{"id":"1","location":"汉字","oxygen":"3.33","negative":"23.2","humidity":"22","temp":"2.33","pm":"6"}][{"id":"4","location":"百度","oxygen":"13","negative":"151","humidity":"1","temp":"1","pm":"1151"}]
qq_16725633 2016-04-18
  • 打赏
  • 举报
回复
@qc963430178 错了返回的值是false
qc963430178 2016-04-18
  • 打赏
  • 举报
回复
 while($en=mysql_fetch_object($q))  $en = array($en);     echo json_encode($en,JSON_UNESCAPED_UNICODE);//打印结果        exit;

21,886

社区成员

发帖
与我相关
我的任务
社区描述
从PHP安装配置,PHP入门,PHP基础到PHP应用
社区管理员
  • 基础编程社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧