PHP를 사용하여 WeChat 애플릿의 부동산 쿼리 기능을 개발하는 방법은 무엇입니까?

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据库中的房产信息
$sql = "SELECT * FROM houses";
$result = $conn->query($sql);

$houses = array();
if ($result->num_rows > 0) {
    // 将查询结果存储到数组中
    while($row = $result->fetch_assoc()) {
        $house = array(
            "id" => $row["id"],
            "name" => $row["name"],
            "location" => $row["location"],
            "price" => $row["price"]
        );
        array_push($houses, $house);
    }
}

// 将查询结果转换为JSON格式
$response = array(
    "code" => 200,
    "message" => "查询成功",
    "data" => $houses
);

// 将数组转换为JSON字符串
$json_response = json_encode($response);

// 返回JSON字符串
header('Content-Type: application/json');
echo $json_response;

wx.request({
    url: 'http://yourdomain.com/your_php_api.php',
    method: 'GET',
    success: function(res) {
        console.log(res.data)
        // 在这里可以处理返回的房产数据
    },
    fail: function() {
        console.log('请求失败')
    }
})