Ajax + PHP session制作购物车
来源:
中文源码网 浏览:144 次 日期:2024-05-13 10:27:00
【下载文档: Ajax + PHP session制作购物车.txt 】
Ajax + PHP session制作购物车
购物车网页代码,具体内容如下
1.登录界面login.php
无标题文档用户名:
密码:
2.登录处理页面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!="")
{
$UserName = $_POST["uid"];
$_SESSION["uid"]=$uid;
echo "OK";
}
else
{
echo "NO";
}
3.主页面main.php
session_start();
include("../DBDA.class.php");
$db = new DBDA();
?>
无标题文档$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 "
购物车中有:{$zhonglei}种商品,总价格为:{$sum}元.
";
?>
代号 |
水果名称 |
水果价格 |
源产地 |
库存量 |
操作 |
$sql = "select * from fruit";
$attr = $db->Query($sql);
foreach($attr as $v)
{
echo "{$v[0]} |
{$v[1]} |
{$v[2]} |
{$v[3]} |
{$v[4]} |
购买 |
";
}
?>
4.购买处理页面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");
5.订单处理页面,计算选取水果的总价,和水果剩余量。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";
6.购物车页面
session_start();
?>
无标题文档
商品名称 |
商品单价 |
购买数量 |
操作 |
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 "{$ashuiguo[0][0]} | {$ashuiguo[0][1]} | {$v[1]} | 删除 |
";
}
?>
提交订单
7.购物车页面删除处理页面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");
8.账户余额页面zhanghu.php
session_start();
$uid = $_SESSION['uid'];
?>
无标题文档
include("../DBDA.class.php");
$db = new DBDA();
$sql = "select Account from login where UserName='{$uid}'";
$result = $db->strQuery($sql);
echo ("您的账户中还剩余".$result);
?>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持中文源码网。