来自匹配的mysql列的多维数组 [英] Multi-Dimensional Array from matching mysql columns

问题描述

我有一张表，其中包含行业和类别，如下所示.

I have a table with industries and categories as seen below.

id|industry|category        |
1 |Building|Air Conditioning|
2 |Building|Roofing         |
3 |Security|Cameras         |

我正在尝试返回如下数组

I am trying to return an array as follows

   array(
    "Building" => array(
        "Air Conditioning",
        "Roofing",
    ),
    "Security" => array(
        "Cameras",
    ),
);

解决此问题的最佳方法是什么.

What is the best way to approach this.

非常感谢您提前提供帮助.

Thanks for any help in advance.

推荐答案

只需对数据进行一次迭代:

Just iterate once over the data:

$data = [
    [1, "Building", "Air Conditioning"],
    [2, "Building", "Roofing"],
    [3, "Security", "Cameras"]
];
$result = [];
foreach ($data as $row) {
    if (!array_key_exists($row[1], $result)) {
        $result[$row[1]] = [];
    }
    array_push($result[$row[1]], $row[2]);
}
var_dump($result);

链接到小提琴

这篇关于来自匹配的mysql列的多维数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！