我有一個名為“MY_Database”的資料庫。
我想在每次計數更改時更新“百分比”行。這就是我的功能到目前為止的樣子：
再次更新
<?php
$total = '';
$result= mysqli_query($conn, "SELECT SUM(count) FROM My_Databse WHERE is_enabled ='1'");
while($row = mysqli_fetch_array($result)){
$total = $row['SUM(count)'];
}
$percentage = '';
$result= mysqli_query($conn, "SELECT * FROM My_Database WHERE is_enabled ='1' ORDER BY count DESC");
while($row = mysqli_fetch_array($result)){
$percentage = ($row[2] / $total) * 100;
echo '<div >';
echo '<div role="progressbar" aria-valuenow="'.$percentage.'" aria-valuemin="0" aria-valuemax="100" style="width:'.$percentage.'%">';
echo $row[1].'('.round($percentage).')';
echo '</div>';
echo '</div>';
$i ;
}
$result = mysqli_query($conn, "UPDATE My_Database SET percentage = ".$percentage." WHERE id = 1");
?>
我現在有一個問題，我總是得到最后一個百分比。如何更新每一行的百分比？
uj5u.com熱心網友回復：
更新查詢必須在 while 回圈內，計算百分比后 -
mysqli_query($conn, "UPDATE My_Database SET percentage = ".$percentage." WHERE id = ". $row['id'] );
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/437546.html