转换为 PDO 后数据不显示在 ListView

Question

我已经创建了一个包含 ListView 的应用程序。我使用 PHP 连接 android 和数据库。现在，我使用 MySQLi 并且它可以工作。但是当我转换为 PDO 时，数据不显示。我使用“Log.d”来跟踪数据的内容。结果如下：MySQLi（无错误）- {"data":[{"report_id":19,"task_name":"ngantuk","badgeid":"12345","report_date":"04 Dec 2019",..... ..PDO（不记录显示数据）现在，下面是 MySQLi 和 PDO 的当前代码MySQLi<?php     require_once 'config.php';    if (mysqli_connect_errno()) {        echo "Failed to connect to MySQL: " . mysqli_connect_error();        die();    }    $badgeid = $_GET["badgeid"] ?? "";    $stmt = $conn->prepare("SELECT report_id, task_name, badgeid, report_date, photo_before, photo_after, report_status FROM report WHERE badgeid = '$badgeid' AND report_status = 'Pending';");    $stmt->execute();    $stmt->bind_result($report_id, $task_name, $badgeid, $report_date, $photo_before, $photo_after, $report_status);    $task = array();     while($stmt->fetch()){        $temp = array();        $temp['report_id'] = $report_id;         $temp['task_name'] = $task_name;         $temp['badgeid'] = $badgeid;        $booked = strtotime($report_date);        $report_date = date("d M Y", $booked);        $temp['report_date'] = $report_date;        $temp['photo_before'] = $photo_before;        $temp['photo_after'] = $photo_after;        $temp['report_status'] = $report_status;         array_push($task, $temp);    }    $response = array();    $response["data"] = $task;    echo json_encode($response);?>有谁知道我的 PDO 代码有什么问题？

Answer 1

mysqli 代码和 PDO 代码不一样。我将代码从 mysqli 版本复制到 PDO 版本。

PDOStatement::fetch()一次得到一排。当您从 fetch 中获取结果并将其放入 while 循环的条件中时，您正在创建一个无限循环，最终将耗尽内存。

require_once 'configPDO.php';

$badgeid = $_GET["badgeid"] ?? "";

$stmt = $conn->prepare("SELECT report_id, task_name, badgeid, report_date, photo_before, photo_after, report_status FROM report WHERE badgeid = :badgeid AND report_status = 'Pending'");   

$stmt->bindParam(':badgeid',$badgeid,PDO::PARAM_STR);

$stmt->execute();

$task = [];

while ($result = $stmt->fetch(PDO::FETCH_ASSOC)) {

    $temp = [];

    $temp['report_id'] = $result['report_id']; 

    $temp['task_name'] = $result['task_name']; 

    $temp['badgeid'] = $result['badgeid'];

    $booked = strtotime($result['report_date']);

    $report_date = date("d M Y", $booked);

    $temp['report_date'] = $result['report_date'];

    $temp['photo_before'] = $result['photo_before'];

    $temp['photo_after'] = $result['photo_after'];

    $temp['report_status'] = $result['report_status']; 

    $task[] = $temp;

}   

$response = [];

$response["data"] = $task;

echo json_encode($response);