选择计数组并使用键和值输出到数组中

Question

我希望从数据库中选择所有行，其中number_id = 1并将体验ID 分组在一起，并将每个行的计数输出到一个数组中，其中体验id作为键，count作为值。

+------------+------------+
| number_id  | experience |
+------------+------------+
|  1         |  4         |
|  1         |  4         |
|  1         |  1         |
|  1         |  2         |
|  1         |  3         |
|  1         |  1         |
|  1         |  5         |
+------------+------------+

所以结果应该是：

4 => 2
1 => 2
2 => 1
3 => 1
5 => 1

这是我到目前为止所拥有的：

$query = "SELECT COUNT(*) AS SUM FROM comments WHERE number_id = '1' GROUP BY experience";
$result = mysqli_query($conn, $query);
$experience = array();
if ($result->num_rows>0) {
while ($row = mysqli_fetch_assoc($result)) {
$experience[] = $row['SUM'];
}
}
print_r($experience);

输出此

Array ( [0] => 2 [1] => 2 [2] => 1 [3] => 1 [5] => 1 )

但我需要能够将它们数组键更改为体验 ID

我该怎么做？

Answer 1

只需选择experience并将其用作密钥即可。

$query = "SELECT experience, COUNT(*) AS SUM FROM comments WHERE number_id = '1' GROUP BY experience";
$result = mysqli_query($conn, $query);
$experience = array();
if ($result->num_rows>0) {
while ($row = mysqli_fetch_assoc($result)) {
$experience[$row['experience']] = $row['SUM'];
}
}
print_r($experience);