当前使用以下
SELECT category, COUNT(*) as count
FROM
table
GROUP BY category
计算每个类别中发布了多少个项目,但是我想做的是为每个类别的结果很多
Category: FirstCategory:
Date: 26/03/2019,
Posts: 156,
Date: 27/03/2019,
Posts: 127
Category: SecondCategory:
Date: 26/03/2019,
Posts: 122,
Date: 27/03/2019,
Posts: 135
这种类型的事情可能吗?
按类别和sql中的日期组。然后按PHP中的类别按类别进行分组:
$result = $mysqli->query("
SELECT category, date, COUNT(*) as count
FROM `table`
GROUP BY category, date
");
$data = [];
while ($row = $result->fetch_assoc()) {
$data[$row['category']][$row['date']] = $row['count'];
}
您会得到这样的数组:
[
'FirstCategory' => [
'26/03/2019' => 156,
'27/03/2019' => 127,
],
'SecondCategory' => [
'26/03/2019' => 122,
'27/03/2019' => 135,
],
]