php - 表 UI View : Mysql - Php

Question

我的表格 View :

id  |   packetId    |   fweight    |     
1   |     002       |     150      |    
2   |     002       |     230      |   
3   |     002       |     200      |      

但我希望我的表格 UI 应该如下所示:

id  |   packetId    |   fweight    |    sum(fweight)
1   |     002       |     150      |    
2   |               |     230      |   
3   |               |     200      |        580

我想避免重复(002)值，并且 fweight sum 应该显示在最后一个插入 id 的另一列中。

ID - 主要 ID，

我如何在 Mysql 、 php 中获取它。

查询到目前为止我所知道的:

"SELECT id, packetId , fweight from product where packetId="002" ";

Answer 1

假设您拥有所有头文件/连接等。

试试这个:

$result = mysqli_query($con,"SELECT id, packetId , fweight from product where packetId='002'");

$tmp = "";
$ctr = 0;
$total = 0;
while($row = mysqli_fetch_array($result))
  {
      echo "<tr><td>";

      echo $row['id'];

      echo "</td><td>";
      if($ctr == 0 || $tmp != $row['id'])
      {
          echo $row['packetId'];
      }
      echo "</td><td>";

      echo $row['fweight'];

      $total = $total + $row['fweight'];

      echo "</td><td>";
      if($tmp != $row['id'])
      {
          echo $total;
          $total = 0;
          $tmp = $row['id'];
      }
      echo "</td></tr>";
      $ctr++;
  }