php - 如何使用 mysqli_fetch_assoc 从 mysql 中获取所有行并转换为 JSON

Question

我已经尝试从使用 mysqli_fetch_assoc 的 mysql 表中获取所有行。使用它时我只得到一行。我需要将生成的数组转换为 JSON。

$query  =   "SELECT * FROM db_category WHERE publish='1'";
$result =   mysqli_query($c, $query) or die(mysqli_error($c));
$length =   mysqli_num_rows($result);

if($length > 0)
{       
    $var['status']  =   'success';

    while($obj = mysqli_fetch_assoc($result)) 
    {
        $var = array_merge($var, $obj);
        $var1 = json_encode($var);
    }
    echo '{"slider":['.$var1.']}';
}
else
{
    $arr    =   array('status'=>"notfound");
    echo '{"slider":['.json_encode($arr).']}';
}

现在上面代码的输出是，

{"slider":[{"status":"success","category_id":"12","category_name":"Books","publish":"1"}]}

要求的输出是，

{"slider":[{"status":"success","category_id":"1","category_name":"Apparel","publish":"1"},{"status":"success","category_id":"2","category_name":"Footwear","publish":"1"},{"status":"success","category_id":"3","category_name":"家具","publish":"1"},{"status":"成功","category_id":"4","category_name":"珠宝","publish":"1"}]}

如何解决这个问题。

Answer 1

您可以通过 json_encode() 轻松完成功能。您还可以使用 mysqli_fetch_all() 将所有数据放入数组中功能:

$data = mysqli_fetch_all($result, MYSQLI_ASSOC);
$jsonData = json_encode(array('slider'=>$data, 'status' => 'success'));

如果你想为每一行添加'status'=>'success'，像这样(在json_encode之前)

foreach($data as $key => $dataRow) {
   $data[$key]['status'] = 'success';
}