mysql - 将 json_objects 转换为数组

Question

我有这个查询

SELECT json_object('image_name', image_name, 'iid', iid) 
FROM `posts_images` 
WHERE `pid` = '62'

结果是这样的

图片:

我可以在同一查询中将这些结果转换为一行 JSON 数组吗？

Answer 1

您可以执行如下操作:

$query = "SELECT json_object('image_name', image_name, 'iid', iid) FROM `posts_images` WHERE `pid` = '62'";
$result = mysqli_query($query);
$data = array();
while($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}
print json_encode($data);