<?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();}/**计算商品价格*/functionthis_price($id){$connect=connectDB();$query="selectpricefromphome_ecms_newswhereid=".$id;if(!$connect){thrownewException("数据库链接不成功,请检查!");}if(!$result=$connect->query($query)){thrownewException("查询失败!");}$row=$result->fetch_assoc();return$row['price'];}/**链接数据库*/functionconnectDB(){global$phome_db_server,$phome_db_username,$phome_db_password,$phome_db_dbname,$phome_db_char;$connect=newmysqli($phome_db_server,$phome_db_username,$phome_db_password,$phome_db_dbname);$connect->query("setNames".$phome_db_char);return$connect;}/**显示结果Js*/functiondisplayResultJs($totalPrice,$totalProducts){return"<divclass='car'>您的购物车中有{$totalProducts}件商品,总计金额¥{$totalPrice}元。<br/>点击查看<ahref='/e/ShopSys/buycar/'>结算>></a></div>";}?>