当查询返回一行并将其转换为JSON时,我得到:
案例1:
{"comment":[{"response":"I totally agree"}]}
但是,当查询返回多行并转换为JSON时,我得到:
案例2:
{"comment":[{"response":"I totally agree"},{"response":"You must be kidding"}]}
假设我只想要第一行,如何将案例2中的JSON转换为案例1的形式。创建JSON的查询和代码如下所示:
$sql = "SELECT response
FROM comments
WHERE MATCH(comments) AGAINST('$query' IN NATURAL LANGUAGE MODE)";
while($row = mysqli_fetch_assoc($res)) {
$return[] = $row;
}
echo json_encode(array('comment'=>$return));
}
https://stackoverflow.com/questions/56677407
复制相似问题