我需要生成一个PHP页面,该页面显示存储在数组中的所有详细信息(来自MySQL请求),以显示每个类似行项目的计数/摘要的方式。
下面是从SQL查询收集的示例数据集(它已被构造为ORDER BY Workgroup,ProductCode):
+----+-------------+-------------+-----------+-----------+
| ID | ProductCode | Description | Workgroup | Status |
+----+-------------+-------------+-----------+-----------+
| 2 | A123 | Coke | Finance | Ordered |
| 4 | A123 | Coke | Finance | Rejected |
| 1 | A123 | Coke | Finance | Rejected |
| 6 | B111 | Pepsi | Finance | Ordered |
| 5 | B111 | Pepsi | Finance | Rejected |
| 8 | B111 | Pepsi | Finance | Rejected |
| 10 | B112 | Fanta | Finance | Ordered |
| 42 | A123 | Coke | Management| Ordered |
| 16 | A123 | Coke | Management| Ordered |
| 11 | B112 | Fanta | Management| Rejected |
+----+-------------+-------------+-----------+-----------+
这些详细信息已存储在 PHP 数组中,如下所示:
Array
(
[0] => Array
(
[ID] => 2
[ProductCode] => A123
[Description] => Coke
[Workgroup] => Finance
[Status] => Ordered
)
[1] => Array
(
[ID] => 4
[ProductCode] => A123
[Description] => Coke
[Workgroup] => Finance
[Status] => Rejected
)
...etc
)
我需要的是将数据吐出在由工作组分隔的多个表中,每个产品都有一个摘要行,下面列出了每个单独的行项目(它不需要严格来说是一个 html 表,只是一些能够表示行项目的 HTML 结构)
从我展示的 10 个示例条目中,它需要输出以下内容:
+--------------------------------------------------------+
| FINANCE TEAM |
+----+-------------+-------------+-----------+-----------+
| Coke Total: 3 Ordered: 1 Rejected: 2 |
+----+-------------+-------------+-----------+-----------+
| 2 | A123 | Coke | Finance | Ordered |
| 4 | A123 | Coke | Finance | Rejected |
| 1 | A123 | Coke | Finance | Rejected |
+----+-------------+-------------+-----------+-----------+
| Pepsi Total: 3 Ordered: 1 Rejected: 2 |
+----+-------------+-------------+-----------+-----------+
| 6 | B111 | Pepsi | Finance | Ordered |
| 5 | B111 | Pepsi | Finance | Rejected |
| 8 | B111 | Pepsi | Finance | Rejected |
+----+-------------+-------------+-----------+-----------+
| Fanta Total: 1 Ordered: 1 Rejected: 0 |
+----+-------------+-------------+-----------+-----------+
| 10 | B112 | Fanta | Finance | Ordered |
+----+-------------+-------------+-----------+-----------+
+--------------------------------------------------------+
| MANAGEMENT TEAM |
+----+-------------+-------------+-----------+-----------+
| Coke Total: 2 Ordered: 2 Rejected: 0 |
+----+-------------+-------------+-----------+-----------+
| 42 | A123 | Coke | Management| Ordered |
| 16 | A123 | Coke | Management| Ordered |
+----+-------------+-------------+-----------+-----------+
| Fanta Total: 1 Ordered: 0 Rejected: 1 |
+----+-------------+-------------+-----------+-----------+
| 11 | B112 | Fanta | Management| Rejected |
+----+-------------+-------------+-----------+-----------+
如果我的要求不够清楚,我可以进一步详细说明。
任何帮助将不胜感激。
提前谢谢。
PHP 数组真的很容易转换为树状结构。你听起来你知道如何编程,所以我不会发送tehfullcodez,因为我认为你可以处理一些嵌套循环,在将最终的html放入更方便的格式后自己生成。
$tree = array();
foreach ($arr as $row) {
extract($row);
$tree[$Workgroup][$Description][] = $row;
}
print_r($tree);