php - MySQL -> PHP Array -> Json 需要以数组加对象格式输出

Question

我正在尝试从 MySQL 获取数据并以 JSON 格式显示这是部分PHP代码

$sql = "SELECT item, cost, veg, spicy_level FROM food1";
$result = $conn->query($sql);

    while($row = $result->fetch_assoc()) {

    echo  json_encode($row),"<br/>";}

?>我得到的输出为

{"item":"dosa","cost":"20","veg":"0","spicy_level":"1"}
{"item":"idli","cost":"20","veg":"0","spicy_level":"2"}

但我需要它

food1:[
{"item":"dosa","cost":"20","veg":"0","spicy_level":"1"},
{"item":"idli","cost":"20","veg":"0","spicy_level":"2"}
]

有人可以指导我吗？我想我得到的是对象格式，我需要数组格式的输出，即 [ & ]。这个 json 和 php 非常新。

Answer 1

可以将查询结果封装成数组打印出来；

$sql = "SELECT item, cost, veg,     spicy_level FROM food1";
$result = $conn->query($sql);
$a = array();
while($row = $result->fetch_assoc()) {
  if($a['food1'] ==null)
     $a['food1'] = array():
  array_push($a['food1'],$row);}


  echo json_encode($a);
?></i>