duanbi9202 2018-07-16 11:45
浏览 55
已采纳

在PHP中为每个添加总和

$connect = mysqli_connect("localhost", "root", "", "hempbag_db") or die("Connection failed");

foreach($a as $b){ 
    foreach($b as $c){
        $query5 = "SELECT P_price tbl_products WHERE PID='".$c['PID']."' ";
        $get_price = mysqli_query($connect, $query5);
        $get_price1 = mysqli_fetch_assoc($get_price); 
        $price = ($get_price1['P_price'])+ $price + 0; // This does not add
    }
}

$price does not add only takes the last value of the data inside the loop.

How can I add them?

I also used:

$price = ($get_price1['P_price'])+0;
$new_price += $price;

Still failed.
Thank You!

  • 写回答

2条回答 默认 最新

  • doushang8512 2018-07-16 12:14
    关注

    initialise $price before looping through the array.

    $connect = mysqli_connect("localhost", "root", "", "hempbag_db") or die("Connection failed");
    
    $price = 0;
    foreach($b as $c)
    {
      $query5 = "select P_price from tbl_products where PID='".$c['PID']."' ";
      $get_price = mysqli_query($connect, $query5);
      $get_price1 = mysqli_fetch_assoc($get_price); 
      $price = ($get_price1['P_price'])+$price;
      // other way (highly recommended)
      $price += ($get_price1['P_price']);
    } 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗