如何在while循环中对ID进行分组(对于php json_encode)
如何在while循环中对ID进行分组(对于php json_encode)
提问于 2018-03-30 20:56:13
有几天我在用MySQL数据创建Json数组时遇到了问题
以下是我的MySQL数据：
zi zn vn pioo pio ve station es eo
1 Zone 1 Value 01 1 199 0 1 1 0
1 Zone 1 Value 02 54 637 0 3 0 0
1 Zone 1 Value 03 55 637 1 3 0 0
2 Zone 2 Value 01 1 199 0 1 1 0
2 Zone 2 Value 03 55 637 1 3 0 0
2 Zone 2 Value 04 56 642 0 3 0 0
3 Zone 3 Value 01 1 199 0 1 1 0
3 Zone 3 Value 05 57 647 1 3 0 0
4 Zone 4 Value 05 57 647 1 3 0 0
5 Zone Test Value 02 54 637 0 3 0 0
5 Zone Test Value 03 55 637 1 3 0 0以下是我的PHP代码：
我的查询是$query，我的SQL连接是$con。
$result = array();
$json_response = array();
$response = array();
if($stmt = $con->prepare($query)){
$stmt->execute();
$stmt->bind_result($zoneId,$zoneName,$vanneName,$piooId,$pioId,$vanne_etat,$station,$etat_station,$etat_ordre);
while($stmt->fetch()){
$json_response = [
'zi' => $zoneId,
'zn' => $zoneName,
$vanneName => [],
];
$json_response[$vanneName][] = [
'pioo' => $piooId,
'pio' => $pioId,
've' => $vanne_etat,
'es' => $etat_station,
'eo' => $etat_ordre,
];
$data = [];
foreach ($json_response as $element) {
$data[] = $element;
}
$result[]=$json_response;
}
$stmt->close();
$online = mysqli_fetch_array(mysqli_query($con, "SELECT CASE WHEN TIMESTAMP > DATE_SUB(NOW(), INTERVAL 5 MINUTE) THEN 1 ELSE 0 END AS online FROM relevés_instantanés ORDER BY ID DESC LIMIT 1")) ['online'];
$response["online"] = $online;
$response["success"] = 1;
$response["data"] = $result;
}else{
//Errors
$response["success"] = 0;
$response["message"] = mysqli_error($con);
}
mysqli_close($con);
echo json_encode($response);输出Json是这样的：
{
"online":"1",
"success":1,
"data":[
{
"zi":1,
"zn":"Zone 1",
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
},
{
"zi":1,
"zn":"Zone 1",
"Value 02":[
{
"pioo":54,
"pio":637,
"ve":0,
"es":0,
"eo":0
}
]
},
{
"zi":1,
"zn":"Zone 1",
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":2,
"zn":"Zone 2",
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
},
{
"zi":2,
"zn":"Zone 2",
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":2,
"zn":"Zone 2",
"Value 04":[
{
"pioo":56,
"pio":642,
"ve":0,
"es":0,
"eo":0
}
]
},
{
"zi":3,
"zn":"Zone 3",
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
},
{
"zi":3,
"zn":"Zone 3",
"Value 05":[
{
"pioo":57,
"pio":647,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":4,
"zn":"Zone 4",
"Value 05":[
{
"pioo":57,
"pio":642,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":5,
"zn":"Zone Test",
"Value 02":[
{
"pioo":54,
"pio":637,
"ve":0,
"es":0,
"eo":0
}
]
},
{
"zi":5,
"zn":"Zone Test",
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
}
]
}但我希望这样的输出：(我不确定语法，但这是由你理解我的愿望。)
{
"online":"1",
"success":1,
"data":[
{
"zi":1,
"zn":"Zone 1"{
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
"Value 02":[
{
"pioo":54,
"pio":637,
"ve":0,
"es":0,
"eo":0
}
]
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":2,
"zn":"Zone 2"{
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
"Value 04":[
{
"pioo":56,
"pio":642,
"ve":0,
"es":0,
"eo":0
}
]
},
{
"zi":3,
"zn":"Zone 3"{
"Value 01":[
{
"pioo":1,
"pio":199,
"ve":0,
"es":1,
"eo":0
}
]
"Value 05":[
{
"pioo":57,
"pio":647,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":4,
"zn":"Zone 4"{
"Value 05":[
{
"pioo":57,
"pio":642,
"ve":1,
"es":0,
"eo":0
}
]
},
{
"zi":5,
"zn":"Zone Test"{
"Value 02":[
{
"pioo":54,
"pio":637,
"ve":0,
"es":0,
"eo":0
}
]
"Value 03":[
{
"pioo":55,
"pio":637,
"ve":1,
"es":0,
"eo":0
}
]
}
]
}我无法隔离每个区域的id以正确构建我的JSON .
是否可以在while循环中使用每个ID一次？
感谢你的任何帮助
对不起我的英语不好..。:S
乔尔
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-03-30 21:49:36
好吧，我就是这样做的。这是一个稍微不同的结构，但它使它更容易构建。
另外，我不使用数据库，所以我将使用这个固定数组。
$a = [
[
"zi" => "1",
"zn" => "Zone 1",
"vn" => "Value 01",
"pioo" => "1",
"pio" => "199",
"ve" => "0",
"station" => "1",
"es" => "1",
"eo" => "0"
], [
"zi" => "1",
"zn" => "Zone 1",
"vn" => "Value 02",
"pioo" => "54",
"pio" => "637",
"ve" => "0",
"station" => "3",
"es" => "0",
"eo" => "0"
],[
"zi" => "2",
"zn" => "Zone 2",
"vn" => "Value 04",
"pioo" => "56",
"pio" => "642",
"ve" => "0",
"station" => "3",
"es" => "0",
"eo" => "0"
]
];如果我在下面有foreach，您可以从数据库中用while循环替换，只要数据在每一行的$data中，就可以了。
$output = [
"online" => 0,
"success" => 0,
"data" => []
];
foreach($a as $data){
//replace foreach with while from the DB
//eg. while(false != ($data = $stmt->fetch_assoc())){
$zone = "zone_{$data['zi']}";
if(!isset($output['data'][$zone])){
//setup the zone first time we see it
$output['data'][$zone] = [
"zi" => $data['zi'],
"zn" => $data['zn'],
];
}
$value = $data['vn'];
if(!isset($output['data'][$zone][$value])) $output['data'][$zone][$value] = [];
//remove these we don't want them anymore
unset($data['zi'], $data['zn'], $data['vn']);
$output['data'][$zone][$value][] = $data;
}
$output["online"] = 1;
$output["success"] = 1;你可以在网上测试这里
输出
{
"online": 1,
"success": 1,
"data": {
"zone_1": {
"zi": "1",
"zn": "Zone 1",
"Value 01": [
{
"pioo": "1",
"pio": "199",
"ve": "0",
"station": "1",
"es": "1",
"eo": "0"
}
],
"Value 02": [
{
"pioo": "54",
"pio": "637",
"ve": "0",
"station": "3",
"es": "0",
"eo": "0"
}
]
},
"zone_2": {
"zi": "2",
"zn": "Zone 2",
"Value 04": [
{
"pioo": "56",
"pio": "642",
"ve": "0",
"station": "3",
"es": "0",
"eo": "0"
}
]
}
}
}正如您所看到的，它非常接近您想要的格式，但是通过在其中添加这个$zone = "zone_{$data['zi']}";，我们可以更好地跟踪所有的事情。
//php
$output['data'][$zone];
//json
"data": {
"zone_1"否则，我们必须先按区域对它们进行分组，然后在第二个循环中将它们写出来。正如您所说的，解决这个问题的方法是将数据输出到按区域id分组的数组，然后循环执行。因此，我们必须将上面的内容构建为第1阶段，然后将它们正确分组后，从本质上删除zone键。
正如我在注释中提到的，在这一切结束时，您想要的格式出现了错误。就在这里
"zn":"Zone 1"{ //<--- this bracket
"Value 01":[
{
...因此，我不知道这是否只是一个错误，或者这是否应该是结构的一部分(我只是忽略了它)。
更新
我突然想到了一种简单的方法来删除我添加的$zone密钥。您可以简单地使用值删除密钥。所以，如下所示，在将其编码为JSON之前添加这一行。
$output['data'] = array_values($output['data']);这将将结构更改为
{
"online": 1,
"success": 1,
"data": [
{
"zi": "1",
"zn": "Zone 1",
"Value 01": [
{
"pioo": "1",
"pio": "199",
"ve": "0",
"station": "1",
"es": "1",
"eo": "0"
}
],
"Value 02": [
{
"pioo": "54",
"pio": "637",
"ve": "0",
"station": "3",
"es": "0",
"eo": "0"
}
]
}
]
}您可以看到在线这里，但是由于我们在前面备份了结构，所以我们可以通过密钥( $zon var)来识别它们。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/49581335
复制相关文章
相似问题
腾讯云开发者
