<?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(); }   /**計算商品價格*/ function this_price($id){     $connect = connectDB();     $query = "select price from phome_ecms_news where id = ".$id;     if(!$connect){        throw new Exception("數據庫鏈接不成功,請檢查!");     }     if(!$result = $connect -> query($query)){         throw new Exception("查詢失敗!");     }     $row = $result -> fetch_assoc();          return $row['price']; }  /**鏈接數據庫*/ 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; }  /**顯示結果Js*/ function displayResultJs($totalPrice,$totalProducts){     return "<div class='car'>您的購物車中有 {$totalProducts} 件商品，總計金額 ￥{$totalPrice}元。<br />點擊查看   <a href='/e/ShopSys/buycar/'>結算&gt;&gt;</a> </div>"; }?>