php如何把mysql資料轉成json格式

header("content-Type: text/html; charset=utf-8");//字符编码设置 $servername = "localhost"; $username = "root"; $password = "123456"; $dbname = "mydb"; // 创建连接 $conn =new mysql($servername, $username, $password, $dbname); // 检测连接 if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //执行查询语句 $sql = "SELECT * FROM power WHERE DATE='2014-1-1'"; $result = $conn->query($sql);

$arr = array(); while($row = mysqli_fetch_array($result)) { $count=count($row); for($i=0;$i<$count;$i++){ unset($row[$i]);//删除冗余数据 } array_push($arr,$row); }

echo json_encode($arr,JSON_UNESCAPED_UNICODE);