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