<?php
/*** 根据Cookie值对购物车商品数量和总价格调用*/require("class/connect.php");$totalProducts = 0; //购物车商品总数$totalPrice = 0.0; //购物车商品总价// |77,243|2!|77,237|3!$cookieString = explode("!",$_COOKIE['zeuqcmybuycar']);try{//遍历商品for($i = 0; $i < count($cookieString)-1; $i++){$priceAndNumber = explode("|",$cookieString[$i]);$thisNum = $priceAndNumber[2]; //当前商品的数量$thisId = explode(",",$priceAndNumber[1]);$thisId = $thisId[1]; //当前商品的ID$thisPrice = this_price($thisId); //当前商品价格$totalPrice += $thisPrice * $thisNum; //购物车商品总价累加$totalProducts += $thisNum; //购物车商品总数累加}echo "document.write("".displayResultJs($totalPrice,$totalProducts)."")"; //显示结果Js形式输出}catch (Exception $e){echo $e->getMessage();}/**计算商品价格*/function this_price($id){$connect = connectDB();$query = "select price from phome_ecms_news where id = ".$id;if(!$connect){throw new Exception("数据库链接不成功,请检查!");}if(!$result = $connect -> query($query)){throw new Exception("查询失败!");}$row = $result -> fetch_assoc();return $row['price'];}/**链接数据库*/function connectDB(){global $phome_db_server,$phome_db_username,$phome_db_password,$phome_db_dbname,$phome_db_char;$connect = new mysqli($phome_db_server,$phome_db_username,$phome_db_password,$phome_db_dbname);$connect -> query("set Names ".$phome_db_char);return $connect;}/**显示结果Js*/function displayResultJs($totalPrice,$totalProducts){return "<div class='car'>您的购物车中有 {$totalProducts} 件商品，总计金额 ￥{$totalPrice}元。<br />点击查看 <a href='/e/ShopSys/buycar/'>结算>></a> </div>";}?>
