JSON输出使用PHP ajax返回null

Question

当我从数据库中查看记录时，结果显示为null。

这就是我迄今为止所尝试的：

<?php
include("db.php");
$fetchqry = "SELECT mid, planid, paid_date, expire_date FROM payment";
$result = mysqli_query($conn, $fetchqry);
$num = mysqli_num_rows($result);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{ 
$mid = $row['mid'];
$planid = $row['planid'];
$date1 = $row['expire_date'];
if (strtotime(date("Y/m/d")) < strtotime($date1)) 
{
$status = "Active"; 
}
else 
{
$status = "Expired";
} 
} 
echo json_encode($row);
?>

Answer 1

将从DB读取的值添加到数组中，然后对其进行编码。

$output = [];
$today = strtotime(date("Y/m/d"));
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{ 
$mid =   $row['mid'];
$planid = $row['planid'];
$date1 = $row['expire_date'];
if($today < strtotime($date1)) 
{
$status = "Active"; 
}
else 
{
$status = "Expired";
}
$output[] = ['mid' => $mid, 'planid' => $planid, 'status' => $status];
} 
echo json_encode($output);