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);?>
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11