代码:
<?php
session_start();
error_reporting(0);
include("config.php");
$sql = "select * from category";
$result = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($result))
{
$data[] = array(
'category' => $row['category_name'],
'image' => $row['file_s']
);
}
echo json_encode($data);
?>在这段代码中,我使用json_encode函数将mysql数据转换为json格式。它显示如下所示:
[
{
"category": "cap",
"image": "Cap-01.png"
},
{
"category": "hair",
"image": "Hair Color-01.png"
}
]但我想要另一种方式,比如:
[
cap {
"image": "Cap-01.png"
},
hair {
"image": "Hair Color-01.png"
}
]那么我该怎么做呢?请帮帮我。
谢谢
发布于 2018-08-18 16:30:33
使用类别名称作为索引
while ($row = mysqli_fetch_array($result)) {
$data[$row['category_name']] = array(
'image' => $row['file_s']
);
}
echo json_encode($data);https://stackoverflow.com/questions/51906749
复制相似问题