标签：

<?php

$servername = "处事器";
$username = "用户名";
$password = "暗码";
$dbname = "数据库名称";
$con =mysqli_connect($servername, $username, $password, $dbname);

$sql = "SELECT * FROM paobu";

$result = mysqli_query($con,$sql);
if (!$result) {
printf("Error: %s\n", mysqli_error($con));
exit();
}

$jarr = array();
while ($rows=mysqli_fetch_array($result)){
$count=count($rows);//不能在循环语句中，，由于每次删除 row数组长度都减小
for($i=0;$i<$count;$i++){
unset($rows[$i]);//删除冗余数据
}
array_push($jarr,$rows);
}
print_r($jarr);//检察数组
echo $str=json_encode($jarr);//将数组进行json编码
$file = fopen("../insertdata/myjson.json","w");
echo fwrite($file,$str);
fclose($file);
mysqli_close($con);

?>

03php拉取处事器信息并生成json