帝国CMS二次开发调用购物车商品数量和总价

<?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"<pclass='car'>您的购物车中有{$totalProducts}件产品，总计金额￥{$totalPrice}元。<br/>点击检查<ahref='/e/ShopSys/buycar/'>结算&gt;&gt;</a></p>";
}
?>