3 回答

TA貢獻1820條經驗 獲得超10個贊
我會在從數據庫讀取數據的循環中做所有必要的數學運算。像這樣的東西:
$ratings = array();
while ($row = $result->fetch_assoc()) {
$name = $row['name'];
if (!isset($ratings[$name])) {
$ratings[$name] = array('count' => 1, 'sum' => $row['rating']);
}
else {
$ratings[$name]['count']++;
$ratings[$name]['sum'] += $row['rating'];
}
}
然后你可以像這樣輸出你的表格:
echo "<table>";
foreach ($ratings as $name => $r) {
echo "<tr><td>$name</td><td>" . round($r['sum'] / $r['count'], 1) . "</td></tr>";
}
echo "</table>";

TA貢獻1815條經驗 獲得超6個贊
要獲得平均值,您可以執行以下操作:
foreach ($groups as $name => $group) {
$average = array_sum(array_column($group, 'rating')) / count($group);
echo $name;
}

TA貢獻1871條經驗 獲得超13個贊
您可以首先在用于處理這些日期的結構中簡化問題
foreach($fields as $field) {
$mods[$field['name']][] = $field['rating'];
}
然后只用關鍵參數 foreach
foreach($mods as $name => $mod) {
echo $name;
echo array_sum($mod) / count($mod);
}
- 3 回答
- 0 關注
- 232 瀏覽
添加回答
舉報