我需要在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;