在while循环中SUM合计结果(已解决) - SUM total result in while loop (Settled)

SUM total result in while loop (Settled)

本文关键字：结果解决 while 循环 SUM | 更新日期: 2023-09-27

我需要在while循环中计算一个总和。我尝试了各种解决方案，但我仍然没有得到任何结果。你们能给我提点建议吗?

问题是，一旦我得到'$section_total'，我想求和section_total，并得出$totalsum的输出。我也累了$ totalsum += $section_total;

下面是我的代码:

<?php
$totalsum=0;
$sql = "SELECT  form_details_section_id,SUM(mark),COUNT(mark) FROM audit_section_markrecord WHERE audit_section_id = '$audit_no' GROUP BY form_details_section_id ";
$result = mysqli_query($db, $sql);
    while($row = mysqli_fetch_assoc($result)) { 
    $query1 = "SELECT * FROM form_details_section WHERE id = '$row[form_details_section_id]' ";
    $result1 = $db->query($query1);
    $row1 = $result1->fetch_array();
    $query6 = "SELECT COUNT(mark) FROM audit_section_markrecord WHERE `form_details_section_id` = '$row[form_details_section_id]' ";
    $result6 = $db->query($query6);
    $row6 = $result6->fetch_array();    
    $mark = $row['SUM(mark)'];
    $final_mark = $row1['final_mark'];
    $section_mark = $row6['COUNT(mark)'];
    $sub = ($section_mark*10);
    $subtotal = ($mark/$sub);
    $section_total = round($subtotal*$final_mark);
    echo"
    <tr class='odd gradeX'>
    <td>".$j."</td>
    <td>".$row1['category']."</td>
    <td>$section_total</td>
    ";
    $j++;
}
?>
</tr>
    <td colspan="2" align="right">Total Score:</td>
    <td><?php $totalsum ?></td>

 $section_total = round($subtotal*$final_mark);
 //After above line in your existing code. Write code as below.
 $totalsum += $section_total;

在while循环中添加$totalsum，放在$j++;

之后

$totalsum = $totalsum + $whateverYouWantToAdd;