drm30963 2009-11-23 10:14
浏览 41
已采纳

从基本购物车脚本计算小计和总计

Im trying to calculate a subtotal and a total from a series of values stored in an array returned from a mysql database.

this i what i have thusfar

    while($row = mysql_fetch_array($cart)){ 
    foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } 
    $id = $row['id'];
    $contents = unserialize($row['contents']);
        foreach( $contents as $key => $value){
            if($key == "price"){$subtotal = $subtotal+$value;}
            echo "$key : $value <br />";
        }
    echo "<br><br><br>";
    } 
echo "<font color=red>SubTotal $subtotal</font>";

$contents contains an array [name] => super [price] => 65.87 [quantity] => 25

So i need to multiply the price by quantity, and then take that subtotal (per item) and add it in total after the loop

  • 写回答

2条回答 默认 最新

  • dpxbc88022 2009-11-23 10:24
    关注
    foreach( $contents as $key => $value)
    {
       if($key == "price") $total = $total+$value;
    
       if($key == "name")
       { 
           if(!isset($subtotal[$key])) $subtotal[$key] = 0;
           $subtotal[$key] = $subtotal[$key] + $value;
       }
    }
    

    Then you have total price in $total and for each individual item in $subtotal array

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 聚类分析或者python进行数据分析
  • ¥15 逻辑谓词和消解原理的运用
  • ¥15 三菱伺服电机按启动按钮有使能但不动作
  • ¥15 js,页面2返回页面1时定位进入的设备
  • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号