php實(shí)現(xiàn)商城購(gòu)物車的思路和源碼分析

body>
h1>登入頁面/h1>
form action="dengrucl.php" method="post">
 div>帳號(hào)：input type="text" name="zhang"/>/div>
 div>密碼：input type="text" name="mi"/>/div>
 input type="submit" value="登入"/>
/form>

/body>

?php
session_start();
include ("db.class.php");
$db = new db();
$zhang = $_POST["zhang"];
$mi = $_POST["mi"];
$sql = "select mi from yonghu WHERE zhang = '{$zhang}'";
$arr = $db->Query($sql);
if(!empty($zhang)!empty($mi)$mi = $arr){
 $_SESSION["zhang"] = $zhang;
 header("location:zym.php");
}
else
{
 echo "登入失敗";
}

?>

body>
h1>長(zhǎng)腿璇購(gòu)物商城/h1>
table border="1" cellpadding="0" cellspacing="0" width="100%" >
 tr>
  td>代號(hào)/td>
  td>水果名稱/td>
  td>水果價(jià)格/td>
  td>水果產(chǎn)地/td>
  td>水果庫存/td>
  td>操作/td>
 /tr>

 ?php
 session_start();
$_SESSION["zhang"] = "xiaoming";//不做登入的情況下，直接存sessiion
 include ("db.class.php");
 $db = new db();
 $sql = "select * from sgbiao";
 $arr = $db->Query($sql);
 foreach ($arr as $v)
 {
  echo " tr>
  td>{$v[0]}/td>
  td>{$v[1]}/td>
  td>{$v[2]}/td>
  td>{$v[3]}/td>
  td>{$v[4]}/td>
  td>
  a href='zymcl.php?ids={$v[0]}'>加入購(gòu)物車/a>
  
/td>
 /tr>";
 }

 ?>
 ?php
 //這里顯示的是 購(gòu)物車有多少產(chǎn)品，和產(chǎn)品的總價(jià)格
 $ann=array();
 if(!empty($_SESSION["gwc"]))
 {
  $ann=$_SESSION["gwc"];

 }
 $zhonglei = count($ann);

 $aa=0;
 foreach($ann as $k)
 {

  $k[0];//水果代號(hào)
  $k[1];//水果數(shù)量
  $sql1="select jiage from sgbiao where ids='{$k[0]}'";

  $danjia=$db->Query($sql1);

  foreach($danjia as $n)
  {

   $aa=$aa + $n[0]*$k[1];
  }


 }
 echo"數(shù)量：{$zhonglei}br/>
價(jià)格:mark>{$aa}元";
 ?>

/table>

a href="tijiao.php" rel="external nofollow" rel="external nofollow" >查看賬戶/a>
a href="ckgwc.php" rel="external nofollow" >查看購(gòu)物車/a>

/body>

?php
session_start();
//
$ids = $_GET["ids"];
if(empty($_SESSION["gwc"]))
{
 //如果點(diǎn)擊的購(gòu)物車是空的（第一次添加）

 //如果購(gòu)物車?yán)锸强盏?，造二維數(shù)組，
 $arr = array(
  array($ids,1)
  //一維數(shù)組，取ids，第一次點(diǎn)擊增加一個(gè)
 );
 $_SESSION["gwc"]=$arr;
 //扔到session里面
}
else
 //這里不是第一次點(diǎn)擊
{
 //先判斷購(gòu)物車?yán)锸欠褚呀?jīng)有了該商品，用$ids
 $arr = $_SESSION["gwc"];
 //把購(gòu)物車的狀態(tài)取出來

 $chuxian = false;
//定義一個(gè)變量；用來表示是否出現(xiàn)，默認(rèn)是未出現(xiàn)
 foreach ($arr as $v) {
  //便利他
  //如果這里面有這件商品
  if ($v[0] == $ids) //如果取過來的$v[0]（商品的代號(hào)）等于$ids那么就證明購(gòu)物車中已經(jīng)有了這一件商品
  {
   $chuxian = true;
   //如果出現(xiàn)，直接把chuxian改成true

  }
 }
 if($chuxian)
 {
  //購(gòu)物車中有此商品
  for($i=0;$icount($arr);$i++)
  {
   if($arr[$i][0] == $ids)
   {
    //把點(diǎn)到的商品編號(hào)加1
    $arr[$i][1] += 1;
   }
  }
  $_SESSION["gwc"] = $arr;

 }
  else
   {
    //這里就只剩下：購(gòu)物車?yán)镉袞|西，但是并沒有這件商品
    $asg = array($ids,1);
    //設(shè)一個(gè)小數(shù)組
    $arr[] = $asg;
    $_SESSION["gwc"]=$arr;
   }

}
header("location:zym.php")


?>

body>
h1>查看購(gòu)物車/h1>
table width="100%" border="1"cellspacing="0" cellpadding="0">
 tr>
  td>商品名稱/td>
  td>商品單價(jià)/td>
  td>商品數(shù)量/td>
  td>操作/td>
 /tr>


 ?php
 session_start();
 if(!empty($_SESSION["gwc"]))
 {
  $arr = array();
  $arr = $_SESSION["gwc"];
  //造數(shù)組
 }
 include ('db.class.php');
 $db = new db();
 foreach ($arr as $v)
 {
  global $db;
  $sql = "select * from sgbiao WHERE ids = '{$v[0]}'";
  $att = $db->query($sql);
  foreach ($att as $a)
  {
   echo "tr>
  td>{$a[1]}/td>
  td>{$a[2]}/td>
  td>{$v[1]}/td>
  td>a href='shanchu.php?ids={$a[0]}'>刪除/a> /td>
 /tr> ";
//   蔬果的名稱
//   單價(jià)
//   取int數(shù)量
//  這個(gè)地方也可以加索引shanchu.php?sy={$v}
  }
 }
 ?>


/table>

a href="tijiao.php" rel="external nofollow" rel="external nofollow" >提交訂單/a>
/body>

?php
session_start();
$ids = $_GET["ids"];
$arr = $_SESSION["gwc"];
//var_dump($arr);
//取索引2（數(shù)量）
foreach ($arr as $key=>$v)
{
 if($v[0]==$ids)
 {
  if($v[1]>1){
   //要?jiǎng)h除的數(shù)據(jù)
   $arr[$key][1]-=1;
  }
  else{
   //數(shù)量為1的情況下，移除該數(shù)組
   unset($arr[$key]);
  }
 }

}

$_SESSION["gwc"] = $arr;
//記得扔到session里面
header("location:ckgwc.php");
//刪除完跳轉(zhuǎn)回去

?php
session_start();
include ("db.class.php");
$db = new db();

//判斷用余額是否滿足
$zhang = $_SESSION["zhang"];
//獲取到用戶名
$sye = "select zhanghu from yonghu WHERE zhang = '{$zhang}'";
$ye = $db->query($sye);
$ye[0][0];//這是余額

$ann=array();
if(!empty($_SESSION["gwc"]))
{
 $ann=$_SESSION["gwc"];

}
$zhonglei = count($ann);

$aa=0;//總價(jià)格
foreach($ann as $k)
{

 $k[0];//水果代號(hào)
 $k[1];//水果數(shù)量
 $sql1="select jiage from sgbiao where ids='{$k[0]}'";

 $danjia=$db->Query($sql1);

 foreach($danjia as $n)
 {

  $aa=$aa + $n[0]*$k[1];
 }


}
//判斷余額是否滿足
if($ye[0][0]>=$aa)
{
 //錢夠,判斷庫存

 foreach($ann as $v)
 {
  $skc = "select sgname,kucun from sgbiao WHERE ids='{$v[0]}'";
  //水果代號(hào)$v[0]
  $akc = $db->query($skc);
  $akc[0][1];//庫存
  //比較是否滿足庫存
  if($akc[0][1]$v[1])
  {
   echo "{$akc[0][0]}庫存不足";
   //退出
   exit;
  }

 }
//提交訂單：
//i. 從用戶賬戶中扣除本次購(gòu)買的總價(jià)格
//ii. 從商品庫存中扣除本次每種商品的購(gòu)買數(shù)量
//iii. 向訂單表和訂單內(nèi)容表中加入本次購(gòu)買的商品信息
 //扣除賬戶余額
$skcye = "update yonghu set zhanghu = zhanghu-{$aa} WHERE zhang = '{$zhang}'";
 $db->query($skcye,0);
 //扣除庫存
 foreach($ann as $v)
 {
  $skckc = "update sgbiao set kucun = kucun-{$v[1]} WHERE ids='{$v[0]}'";
  //水果代號(hào)$v[0]
  $db->query($skckc,0);
 }
 //添加訂單信息
 //取當(dāng)前時(shí)間
 $time = time();
 //自動(dòng)生成訂單號(hào)
 $ddh = date("YmdHis");
 $sdd = "insert into dingdan VALUES ('{$ddh}','$zhang','$time')";
 $db->query($sdd,0);
 //添加訂單內(nèi)容
 foreach ($ann as $v)
 {
  $sddxq = "insert into ddneirong VALUES ('','$ddh','{$v[0]}','{$v[1]}')";
  $db->query($sddxq,0);
 }


}
else
{
 echo "錢不夠";
 exit;
}