时间戳

首页 > 解决方案 > php中的数据库查询失败

php - php中的数据库查询失败

问题描述

php代码不从数据库返回任何结果

 $conn = new mysqli($host, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM pelicula";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            array_push($result_array, $row);
        }
    }
    echo json_encode($result_array);
    $conn->close();

标签： phpmysql

解决方案

 $conn = new mysqli($host, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM pelicula";
    $result = $conn->query($sql);
    $result_array=[];
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            array_push($result_array, $row);
        }
    }
    echo json_encode($result_array);
    $conn->close();`enter code here`

$result_array 必须在与 array_push 函数一起使用之前创建和实例化！！！

推荐阅读