Question

下面的编码显示订购产品的个人重量:

$weightsql =  select op.products_name,
                     op.products_quantity,
                     p.products_weight 
              from   . TABLE_ORDERS_PRODUCTS .   op
              left join   . TABLE_PRODUCTS .   p on op.products_id = p.products_id
              where op.products_id =    . $pro[ products_id ];
        
$weightq = tep_db_query( $weightsql );
        
while ($weight = tep_db_fetch_array( $weightq )) {
    if ($category_parent_id != 0) 
        $list_items[] = $weight[ products_weight ] .  &nbsp;&nbsp;&nbsp; ;
}

这表明订购的每一产品都存在烟雾。我所困的不是显示适当体重,而是需要显示总重量。例如,如果产品被三次订购,每重7公斤,则该编码目前显示:

Product  7.00  7.00  7.00

How would I make it show the total weight, 21kg?

Answer 1

使用array_sum(

array_sum() examples
<?php
$a = array(2, 4, 6, 8);
echo "sum(a) = " . array_sum($a) . "
";

$b = array("a" => 1.2, "b" => 2.3, "c" => 3.4);
echo "sum(b) = " . array_sum($b) . "
";
?>
The above example will output:
sum(a) = 20
sum(b) = 6.9

Answer 2

在休息期间,如:

 $total = 0;
 $weightsql =  select op.products_name, op.products_quantity , p.products_weight from   . TABLE_ORDERS_PRODUCTS .   op left join   . TABLE_PRODUCTS .   p on op.products_id = p.products_id where op.products_id =   .$pro[ products_id ];

 $weightq = tep_db_query( $weightsql );

 while ($weight = tep_db_fetch_array( $weightq )){
      if($category_parent_id != 0) {
           $list_items[] = $weight[ products_weight ]. &nbsp;&nbsp;&nbsp; ;
           $total += $weight[ products_weight ];
      }

 }

然后,可变总额应退还21美元。

Answer 3

如果你以补贴方式选择产品,最容易的解决办法是乘以权重。没有必要把它列入一个阵列。

Answer 4

$weightsql =  SELECT op.products_name, SUM(op.products_quantity * p.products_weight) AS weightsum
              FROM   . TABLE_ORDERS_PRODUCTS .   op
              LEFT JOIN   . TABLE_PRODUCTS .   p on op.products_id = p.products_id
              WHERE op.products_id =    . $pro[ products_id ];

echo $weight[ weightsum ];

友情链接