Detailed tutorial on creating a shopping cart with Ajax+PHP

This time I will bring you a detailed tutorial on making a shopping cart with Ajax+PHP. What are the precautions for making a shopping cart with Ajax+PHP? The following is a practical case, let’s take a look.

Shopping cart web page code, the specific content is as follows

1. Login interface login.php

nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<script></script>
<title>无标题文档</title>


<p>用户名：<input></p>
<p>密码：<input></p>
<input>

<script>
$("#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>

2. Login processing page 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=&#39;{$uid}&#39;";
$mm = $db->StrQuery($sql);
if($mm==$pwd && $pwd!="")
{
  $UserName = $_POST["uid"];
  $_SESSION["uid"]=$uid;
  echo "OK";
}
else
{
  echo "NO";
}

3 .Main page main.php

<?php session_start();
include("../DBDA.class.php");
$db = new DBDA();
?>
nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<title>无标题文档</title><br>
<style>
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>


<p>
  </p><h1 id="大苹果商城">大苹果商城</h1>
  <a>注销</a>

<br>
<p>
  </p><p>
    <a><p>浏览商品</p></a>
    <a><p>查看账户</p></a>
    <a><p>查看购物车</p></a>
  </p>
  
  <p>
<?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=&#39;{$v[0]}&#39;";
    $danjia = $db->StrQuery($sql);
    $sum = $sum +$danjia*$v[1];
  }
  echo "</p><p>购物车中有:{$zhonglei}种商品，总价格为:{$sum}元.</p>";
  ?>
    

                                                     Query($sql);          foreach($attr as $v)     {       echo "                                   ";     }     ?>         

代号	水果名称	水果价格	源产地	库存量	操作
{$v[0]}	{$v[1]}	{$v[2]}	{$v[3]}	{$v[4]}	购买

  

4. Purchase processing page 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. Order processing page, calculate the total price of the selected fruits and the remaining amount of fruits. 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=&#39;{$uid}&#39;";
  $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($yueQuery($skucun);
  if($akucun[0][1]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. Shopping cart page

<?php session_start();
?>
nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<title>无标题文档</title><br>
<style>
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>
<script></script>


<p>
  </p><h1 id="大苹果商城">大苹果商城</h1>
  <a>注销</a>

<br>
<p>
  </p><p>
    <a><p>浏览商品</p></a>
    <a><p>查看账户</p></a>
    <a><p>查看购物车</p></a>
  </p>
  
  <p>
    </p>

                                     $v)     {       $sql = "select name,price from fruit where ids='{$v[0]}'";       $ashuiguo = $db->Query($sql);            echo "";            }          ?>     

商品名称	商品单价	购买数量	操作
{$ashuiguo[0][0]}	{$ashuiguo[0][1]}	{$v[1]}	删除

    

提交订单

   <script> $("#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>

7. Shopping cart page deletion processing page 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[&#39;uid&#39;];
?>
nbsp;html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<meta>
<title>无标题文档</title><br>
<style>
.list{ width:100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle}
</style>


<p>
  </p><h1 id="大苹果商城">大苹果商城</h1>
  <a>注销</a>

<br>
<p>
  </p><p>
    <a><p>浏览商品</p></a>
    <a><p>查看账户</p></a>
    <a><p>查看购物车</p></a>
  </p>  
  <p>
<?php     include("../DBDA.class.php");
    $db = new DBDA();
    $sql = "select Account from login where UserName=&#39;{$uid}&#39;";
    $result = $db->strQuery($sql);
    
    echo ("您的账户中还剩余".$result);
  ?>
  </p>

I believe you have mastered the method after reading the case in this article , for more exciting content, please pay attention to other related articles on the php Chinese website!

Recommended reading:

How to implement AJAX paging effect

Achieve infinite loading of lists and secondary drop-down menu options Ajax (with code)

The above is the detailed content of Detailed tutorial on creating a shopping cart with Ajax+PHP. For more information, please follow other related articles on the PHP Chinese website!