<?php

/**
 * 根據(jù)Cookie值對(duì)購(gòu)物車商品數(shù)量和總價(jià)格調(diào)用
 */
 require("class/connect.php");
 
 $totalProducts = 0;    //購(gòu)物車商品總數(shù)
 $totalPrice = 0.0;        //購(gòu)物車商品總價(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;    //購(gòu)物車商品總價(jià)累加
         $totalProducts += $thisNum;                //購(gòu)物車商品總數(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ù)庫(kù)鏈接不成功,請(qǐng)檢查!");
     }
     if(!$result = $connect -> query($query)){
         throw new Exception("查詢失敗!");
     }
     $row = $result -> fetch_assoc();
     
     return $row['price'];
 }
 
 /**鏈接數(shù)據(jù)庫(kù)*/
 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'>您的購(gòu)物車中有 {$totalProducts} 件商品，總計(jì)金額 ￥{$totalPrice}元。<br />點(diǎn)擊查看   <a href='/e/ShopSys/buycar/'>結(jié)算&gt;&gt;</a> </div>";
 }
?>