<?php
/**
* 根據(jù)Cookie值對購物車商品數(shù)量和總價(jià)格調(diào)用
*/
require("class/connect.php");
$totalProducts = 0; //購物車商品總數(shù)
$totalPrice = 0.0; //購物車商品總價(jià)
// |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]; //當(dāng)前商品的數(shù)量
$thisId = explode(",",$priceAndNumber[1]);
$thisId = $thisId[1]; //當(dāng)前商品的ID
$thisPrice = this_price($thisId); //當(dāng)前商品價(jià)格
$totalPrice += $thisPrice * $thisNum; //購物車商品總價(jià)累加
$totalProducts += $thisNum; //購物車商品總數(shù)累加
}
echo "document.write("".displayResultJs($totalPrice,$totalProducts)."")"; //顯示結(jié)果Js形式輸出
}catch (Exception $e){
echo $e->getMessage();
}
/**計(jì)算商品價(jià)格*/
function this_price($id){
$connect = connectDB();
$query = "select price from phome_ecms_news where id = ".$id;
if(!$connect){
throw new Exception("數(shù)據(jù)庫鏈接不成功,請檢查!");
}
if(!$result = $connect -> query($query)){
throw new Exception("查詢失敗!");
}
$row = $result -> fetch_assoc();
return $row['price'];
}
/**鏈接數(shù)據(jù)庫*/
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;
}
/**顯示結(jié)果Js*/
function displayResultJs($totalPrice,$totalProducts){
return "<div class='car'>您的購物車中有 {$totalProducts} 件商品,總計(jì)金額 ¥{$totalPrice}元。<br />點(diǎn)擊查看 <a href='/e/ShopSys/buycar/'>結(jié)算>></a> </div>";
}
?>
版權(quán)聲明: 本站資源均來自互聯(lián)網(wǎng)或會員發(fā)布,如果侵犯了您的權(quán)益請與我們聯(lián)系,我們將在24小時(shí)內(nèi)刪除!謝謝!
轉(zhuǎn)載請注明: 帝國CMS模板下載調(diào)用購物車商品數(shù)量和總價(jià)