Ajax + PHP session制作購物車

DIV+CSS佈局教程網 >> 網頁腳本 >> JavaScript入門知識 >> AJAX入門 >> AJAX基礎知識 >> Ajax + PHP session制作購物車

編輯：AJAX基礎知識

購物車網頁代碼，具體內容如下

1.登錄界面login.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script src="../jquery-1.11.2.min.js"></script>
<title>無標題文檔</title>
</head>

<body>
<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" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ;
        }
        else
        {
          alert("用戶名或密碼錯誤");
        }
      }
    })
  })
</script>
</html>

2.登錄處理頁面loginchuli.php

<?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!="")
{
  $UserName = $_POST["uid"];
  $_SESSION["uid"]=$uid;
  echo "OK";
}
else
{
  echo "NO";
}

3.主頁面main.php

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>無標題文檔</title><br />
<style type="text/css">
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>
</head>
<body>
<div style="width:100%; height:100px; background-color:#6CC">
  <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>

</body>
</html>

4.購買處理頁面goumai.php

<?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");

5.訂單處理頁面，計算選取水果的總價，和水果剩余量。dingdan.php

<?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";

6.購物車頁面

<?php
session_start();
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>無標題文檔</title><br />
<style type="text/css">
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>
<script src="../../jquery-1.11.2.min.js"></script>
</head>

<body>
<div style="width:100%; height:100px; background-color:#6CC">
  <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>
</body>
</html>

7.購物車頁面刪除處理頁面shanchu.php

<?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");

8.賬戶余額頁面zhanghu.php


<?php
session_start();
$uid = $_SESSION['uid'];
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>無標題文檔</title><br />
<style type="text/css">
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>
</head>
<body>
<div style="width:100%; height:100px; background-color:#6CC">
  <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%; height:150px; float:left">

<?php
    include("../DBDA.class.php");
    $db = new DBDA();
    $sql = "select Account from login where UserName='{$uid}'";
    $result = $db->strQuery($sql);
    
    echo ("您的賬戶中還剩余".$result);
  ?>

  </div>
</div>

</body>
</html>

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持。

AJAX基礎知識

Django框架利用ajax實現批量導入數據功能: 本文實例為大家分享了網頁中利用ajax實現批量導入數據功能的實現方法，供大家參考，具體內容如下url
談談Ajax原理實現過程: 1.什麼是AJAX?AJAX全稱為“Asynchronous JavaScript and
如何成為AJAX高手: 提起JavaScript,很多程序員都覺得不屑一顧,總是認為他很低級.假如在C/S產品開發模式下,J

AJAX基礎知識 AJAX詳解

DIV CSS 佈局教程網

相關文章