php查询数据库返回json类型结果

最新推荐文章于 2021-12-14 11:23:37 发布

奇点.

最新推荐文章于 2021-12-14 11:23:37 发布

阅读量3k

点赞数

分类专栏： SQL/数据库其它文章标签： php mysql json

本文链接：https://blog.csdn.net/qq_37688204/article/details/98971209

版权

其它同时被 2 个专栏收录

11 篇文章 0 订阅

订阅专栏

SQL/数据库

6 篇文章 0 订阅

订阅专栏

表结构：

程序代码：

<?php
$servername = "***.***.***.***";
$username = "***";
$password = "***";
$dbname = "******";

$json = '';
$data = array();

class Dustbin 
{
	public $id;
	public $name;
	public $title;
	public $content;
	public $longitude;
	public $latitude;
	public $point;
	public $isOpen;
	public $icon;
	public $ip;
	
	public $full_0;
	public $full_1;
	public $full_2;
	public $full_3;
}
 
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
 
$sql = "SELECT id, baidu_lon,baidu_lat,full_0,full_1,full_2,full_3 FROM lese";
$result = $conn->query($sql);
 
if ($result->num_rows > 0) {
    // 输出数据
	$index=0;
    while($row = $result->fetch_assoc()) {
		$icon1=array("w"=>23,"h"=>25,"l"=>0,"t"=>21,"x"=>9,"lb"=>12);
		$icon2=array("w"=>23,"h"=>25,"l"=>46,"t"=>21,"x"=>9,"lb"=>12);
        $dustbin = new Dustbin();
		$dustbin->id=($index);
		$dustbin->name="dustbin".($index);
		$dustbin->title="dustbin".($index);
		$dustbin->content="notes".($index);
		$dustbin->ip = $row["id"];
		$dustbin->longitude=$row["baidu_lon"];
		$dustbin->latitude=$row["baidu_lat"];
		$dustbin->point="".($row["baidu_lon"])."|".($row["baidu_lat"]);
		$dustbin->isOpen=0;
		$dustbin->full_0 = $row["full_0"];
		$dustbin->full_1 = $row["full_1"];
		$dustbin->full_2 = $row["full_2"];
		$dustbin->full_3 = $row["full_3"];
		$flag = ($dustbin->full_0+$dustbin->full_1+$dustbin->full_2+$dustbin->full_3);
		if ($flag == 0){
			$dustbin->icon=$icon1;
		}
		else{
			$dustbin->icon=$icon2;
		}
		
		array_push($data,$dustbin);
		$index+=1;
    }
	$json = json_encode($data);//把数据转换为JSON数据.
	echo $json;
} else {
    echo $json;
}
$conn->close();
?>

返回结果：