如何对数组中包含在 JSON 中的值进行排序？
我正在接收来自数据库的数据，这些数据来自包含 JSON 的数组。我想按标题对重复的值进行分组，即 GROUP 是标题，BREED 是标题，NAME 是这个标题的描述，如下所示。
车辆（集团）
电动（品种）
奥迪 A3 Sportback
宝马i3
雪佛兰螺栓
克莱斯勒 Pacifica PHEV
福特聚变能源
现代 IONIQ Electric
梅赛德斯 GLE 550
福特
三菱/日产
自走式（BREED）
步兵战斗
装甲侦察
骑兵格斗
装甲人员
空中缆车
婴儿车
送货车
日产聆风
推土机
这是里面有 JSON 的数组，下面是获取信息的循环。
<?php
$array = array(
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "Infantry fighting."
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Audi A3 Sportback."
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "Armored reconnaissance"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "BMW i3"
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "Cavalry fighting"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Chevrolet Bolt"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Chrysler Pacifica PHEV."
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "Armored personnel"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Ford Fusion Energi."
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "aerial tramway"
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "baby carriage"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Hyundai IONIQ Electric."
}',
'{
"GROUP": "Vehicle",
"BREED": "Self-Propelled",
"NAME": "delivery truck"
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Mercedes GLE 550e."
}',
'{
"GROUP": "Vehicle",
"BREED": "Electric",
"NAME": "Ford F"
}',
注意 BREED 和 GROUP 一遍又一遍地重复，我怎样才能让它们看起来像顶级模型？
函数式编程2回答
-
森林海
再次阅读文章后，我意识到，有是在那里尝试已经（对不起，我先前的评论说，否则......）。关于如何解决数据重组问题，我的建议如下：$newarr=array();for($i = 0; $i < count($array); $i++){ $obj = json_decode($array[$i]); $newarr[$obj->GROUP][$obj->BREED][]=$obj->NAME;}foreach ($newarr as $group => $breeds) { echo "<h1>$group</h1>\n"; foreach ($breeds as $breed => $vehicles) echo "<p><b>$breed</b><br>\n".join("<br>\n",$vehicles)."</p>\n";}您可以在此处找到工作演示：https : //rextester.com/OYD48391 -
泛舟湖上清波郎朗
您需要先重构您的数据，然后再渲染它们，如下所示// we will restructure the array to look like the following[ "Vehicle" => [ "Self-Propelled" => [ 0 => "Infantry fighting.", 1 => "Cavalry fighting", 2 => "Armored personnel", 3 => "aerial tramway", 4 => "baby carriage", 5 => "delivery truck", 6 => "Nissan LEAF.", 7 => "Earth mover", ], "Electric" => [ 0 => "Audi A3 Sportback.", 1 => "BMW i3", 2 => "Chevrolet Bolt", 3 => "Chrysler Pacifica PHEV.", 4 => "Ford Fusion Energi.", 5 => "Hyundai IONIQ Electric.", 6 => "Mercedes GLE 550e.", 7 => "Ford F", 8 => "Mitsubishi/Nissan", ] ], "Passageiro" => [ "Self-Propelled" => [ 0 => "Armored reconnaissance", ] ],]// first restructure the array$restructuredArray = [];foreach ($array as $jsonData) { $data = json_decode($jsonData); $restructuredArray[$data->GROUP] = $restructuredArray[$data->GROUP] ?? []; $restructuredArray[$data->GROUP][$data->BREED] = $restructuredArray[$data->GROUP][$data->BREED] ?? []; $restructuredArray[$data->GROUP][$data->BREED][] = $data->NAME;}// second rendering the restructured arrayforeach ($restructuredArray as $group => $breeds) { echo "<h1>{$group}</h1>"; foreach($breeds as $breed => $names) { echo "<h3>{$breed}</h3>"; foreach($names as $name) { echo "<p>{$name}</p>"; } }}建议 如果您可以控制数据库，最好以更好的格式或结构保存数据，在您的情况下，您可以使用 SQL（如 MySQL 使用关系）或 NoSQL（基于文档的数据库，如 MongoDB），两者都适合为您的需要。
随时随地看视频慕课网APP
PHP