03php拉取服务器信息并生成json

<?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);?>

相关推荐