如果在一个表格的最后一行加上一行合计

[zhaiguo]

如下图所示，如何在表中最后一行添加一行“合计”，然后分别对应合计每项运动项目。代码如下：

<h1 style="font-size:38px">浏览健身记录</h1>
<table width="940" border="1" cellspacing="0" style="font-size:38px">
    <tr align="center" valign="middle">
        <th>ID</th>
        <th>日期</th>
        <th>俯卧撑</th>
        <th>深蹲</th>
        <th>双杠臂屈伸</th>
        <th>提踵</th>
        <th>操作</th>
    </tr>
    <?php
    // 1. 链接数据库
    header("content-type:text/html;charset=utf8");
    $conn=mysqli_connect("localhost","xxxx","123456","xxxx_js");
    mysqli_set_charset($conn,"utf8");

    //2.执行sql
    $sql_select = "select * from jilu";
        //3.data 解析
    foreach ( $conn->query($sql_select) as $row) {
        echo "<tr>";
        echo "<th>{$row['id']} </th>";
        echo "<th>{$row['rq']} </th>";
        echo "<th>{$row['fwc']}</th>";
        echo "<th>{$row['sd']} </th>";
        echo "<th>{$row['sgbqs']} </th>";
        echo "<th>{$row['tz']}</th>";
        echo "<td align='center' valign='middle'>
 <a href='edit.php?id={$row['id']}'>修改</a>
  </td>";
    }
    ?>
</table>

[好人二狗]

 $sql_select = "select * from jilu";
//在这里增加
$fwcTotal = 0;
$sdTotal = 0;
        //3.data 解析
    foreach ( $conn->query($sql_select) as $row) {
//在这里增加
$fwcTotal+=$row['fwc'];
$sdTotal+=$row['sd'];


        echo "<tr>";
        echo "<th>{$row['id']} </th>";
        echo "<th>{$row['rq']} </th>";
        echo "<th>{$row['fwc']}</th>";
        echo "<th>{$row['sd']} </th>";
        echo "<th>{$row['sgbqs']} </th>";
        echo "<th>{$row['tz']}</th>";
        echo "<td align='center' valign='middle'>
 <a href='edit.php?id={$row['id']}'>修改</a>
  </td>";
    }
//增加
echo "<tr><td>合计</td><td>{$fwcTotal}</td><td>{$sdTotal}</td></tr>";

[xuzuning]

在循环中对需要合计的项进行累加 循环结束后输出累加结果

[编程界的小弱鸡]

foreach内对各项使用+=累加结果,foreach外输出就好