php 實用例子：購物車 涉及session與ajax

標籤：include   登入   蘋果   post   hang   else   庫存   pass   rip   

login：

<div>使用者名稱：<input type="text" id="uid" /></div>
<div>密碼：<input type="text" id="pwd" /></div>
<input type="button" value="登入" id="btn" />
</body>
<script type="text/javascript">
$("#btn").click(function(){
 var uid = $("#uid").val();
 var pwd = $("#pwd").val();
 
 $.ajax({
   url:"loginchuli.php",
   data:{u:uid,p:pwd},
   type:"POST",
   dataType:"TEXT",
   success: function(data){
    if(data.trim()=="OK")
    {
     window.location.href="main.php";
    }
    else
    {
     alert("使用者名稱或密碼錯誤");
    }
    }
  });
 
 })
</script>

loginchuli：

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

$uid = $_POST["u"];
$pwd = $_POST["p"];

$sql = "select password from login where username=‘{$uid}‘";

$mm = $db->StrQuery($sql);

if($mm==$pwd && $pwd!="")
{
 $_SESSION["uid"]=$uid;
 echo "OK";
}
else
{
 echo "NO";
}

main：

<?php
session_start();
include("../DBDA.class.php");
$db = new DBDA();
?>

<style type="text/css">
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>

<div style="width:100%; height:100px;
 <h1 style="float:left">大蘋果商城</h1>
    <a style="float:right; margin-top:40px" href="zhuxiao.php">登出</a>
</div>
<br />
<div style="width:100%; height:600px">
 <div id="left" style="width:20%; float:left">
     <a href="main.php"><div class="list">瀏覽商品</div></a>
        <a href="zhanghu.php"><div class="list">查看賬戶</div></a>
        <a href="gouwuche.php"><div class="list">查看購物車</div></a>
    </div>
   
 <div id="right" style="width:80%; float:left">
   
    <?php
 $agwc = array();
 if(!empty($_SESSION["gwc"]))
 {
  $agwc = $_SESSION["gwc"];
 }
 $zhonglei = count($agwc);
 $sum = 0;
 foreach($agwc as $v)
 {
  $sql = "select price from fruit where ids=‘{$v[0]}‘";
  $danjia = $db->StrQuery($sql);
  $sum = $sum +$danjia*$v[1];
 }
 echo "<div>購物車中有:{$zhonglei}種商品，總價格為:{$sum}元.</div>";
 ?>
   
     <table width="100%" border="1" cellpadding="0" cellspacing="0">
        <tr>
         <td>代號</td>
            <td>水果名稱</td>
            <td>水果價格</td>
            <td>源產地</td>
            <td>庫存量</td>
            <td>操作</td>
        </tr>
       
        <?php
 
  
  $sql = "select * from fruit";
  $attr = $db->Query($sql);
  
  foreach($attr 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=‘goumai.php?code={$v[0]}‘>購買</a></td></tr>";
  }
  ?>
       
        </table>
    </div>
</div>

goumai：

<?php
session_start();
$code = $_GET["code"];

if(empty($_SESSION["gwc"]))
{
 //第一次點擊購買
 $attr = array(
  array($code,1)
 );
 $_SESSION["gwc"] = $attr;
}
else
{
 //不是第一次點擊購買
 $attr = $_SESSION["gwc"];
 $bs=0;
 foreach($attr as $k=>$v)
 {
  if($v[0]==$code)
  {
   $bs=1;
   $attr[$k][1] = $attr[$k][1]+1;
  }
 }
 //如果沒有在數組裡面出現
 if($bs==0)
 {
  $shuzu = array($code,1);
  $attr[] = $shuzu;
 }
 
 $_SESSION["gwc"]=$attr;
 
}
header("location:main.php");

gouwuche：

<div style="width:100%; height:100px;
 <h1 style="float:left">大蘋果商城</h1>
    <a style="float:right; margin-top:40px" href="zhuxiao.php">登出</a>
</div>
<br />
<div style="width:100%; height:600px">
 <div id="left" style="width:20%; float:left">
     <a href="main.php"><div class="list">瀏覽商品</div></a>
        <a href="zhanghu.php"><div class="list">查看賬戶</div></a>
        <a href="gouwuche.php"><div class="list">查看購物車</div></a>
    </div>
   
 <div id="right" style="width:80%; float:left">
     <table width="100%" border="1" cellpadding="0" cellspacing="0">
        <tr>
         <td>商品名稱</td>
            <td>商品單價</td>
            <td>購買數量</td>
            <td>操作</td>
        </tr>
       
        <?php
  include("../DBDA.class.php");
  $db = new DBDA();
  $attr=array();
  if(!empty($_SESSION["gwc"]))
  {
   $attr = $_SESSION["gwc"];
  }
  
  foreach($attr as $k=>$v)
  {
   $sql = "select name,price from fruit where ids=‘{$v[0]}‘";
   $ashuiguo = $db->Query($sql);
  
   echo "<tr><td>{$ashuiguo[0][0]}</td><td>{$ashuiguo[0][1]}</td><td>{$v[1]}</td><td><a href=‘shanchu.php?sy={$k}‘>刪除</a></td></tr>";
   
  }
  
  ?>
       
        </table>
        <div id="tj">提交訂單</div><div id="ts"></div>
    </div>
</div>

<script type="text/javascript">
$("#tj").click(function(){
  $.ajax({
    url:"dingdan.php",
    dataType:"TEXT",
    success: function(data){
      if(data.trim()=="OK")
      {
       alert("購買成功");
      }
      else if(data.trim()=="YEBUZU")
      {
       $("#ts").html("餘額不足");
       $("#ts").css("color","red");
      }
      else
      {
       $("#ts").html(data);
       $("#ts").css("color","red");
      }
     }
   });
 })
</script>

dingdan：

<?php
session_start();
include("../DBDA.class.php");
$db = new DBDA();
$uid = $_SESSION["uid"];
$attr = array();
if(!empty($_SESSION["gwc"]))
{
 $attr = $_SESSION["gwc"];
}
//看下兩個條件是否都滿足
$bs = true;

//判斷餘額是否滿足
 //根據使用者名稱找餘額
 $syue = "select account from login where username=‘{$uid}‘";
 $yue = $db->StrQuery($syue);
 
 //根據購物車數組取總金額
 $sum = 0;
 foreach($attr as $v)
 {
  $sql = "select price from fruit where ids=‘{$v[0]}‘";
  $danjia = $db->StrQuery($sql);
  $sum = $sum +$danjia*$v[1];
 }
 if($yue<$sum)
 {
  $bs = false;
  echo "YEBUZU";
  exit;
 }
 
//判斷庫存是否滿足

foreach($attr as $v)
{
 $skucun = "select name,numbers from fruit where ids=‘{$v[0]}‘";
 $akucun = $db->Query($skucun);
 if($akucun[0][1]<$v[1])
 {
  $bs = false;
  echo "{$akucun[0][0]}庫存不足！";
  exit;
  
 }
}

//添加訂單，減庫存，減餘額

if($bs)
{
 //減庫存
 foreach($attr as $v)
 {
  $sql = "update fruit set numbers = numbers-{$v[1]} where ids=‘{$v[0]}‘";
  $db->Query($sql,0);
 }
 
 //減餘額
 $jianyue="update login set account=account-{$sum} where username=‘{$uid}‘";
 $db->Query($jianyue,0);
 
 //添加訂單
 $dingdanhao = $uid+date("YmdHis");
 $t = time();
 
 $sorder = "insert into orders values(‘{$dingdanhao}‘,‘{$uid}‘,‘{$t}‘)";
 $db->Query($sorder,0);
 
 foreach($attr as $v)
 {
  $sxq = "insert into orderdetails values(‘‘,‘{$dingdanhao}‘,‘{$v[0]}‘,‘{$v[1]}‘)";
  $db->Query($sxq,0);
 }
}

echo "OK";

shanchu：

<?php
session_start();

$sy = $_GET["sy"];

$attr = $_SESSION["gwc"];

if($attr[$sy][1]>1)
{
 $attr[$sy][1] = $attr[$sy][1]-1;
}
else
{
 unset($attr[$sy]);
 $attr = array_values($attr);
}

$_SESSION["gwc"]=$attr;

header("location:gouwuche.php");

 

php 實用例子：購物車 涉及session與ajax