登陆页面
<!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="../../class/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" /> <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> </body> </html>
登陆处理
1 <?php 2 session_start(); 3 include("../../class/dbda.class.php"); 4 $db = new DBDA(); 5 6 $uid = $_POST["u"]; 7 $pwd = $_POST["p"]; 8 9 $sql = "select password from login where username='{$uid}'"; 10 $mm = $db->StrQuery($sql); 11 if($mm == $pwd && $pwd != ""){ 12 $_SESSION["uid"]=$uid; 13 echo "OK"; 14 }else{ 15 echo "NO"; 16 }
主页面
1 <?php 2 session_start(); 3 include("../../class/dbda.class.php"); 4 $db = new DBDA(); 5 ?> 6 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 7 <html xmlns="http://www.w3.org/1999/xhtml"> 8 <head> 9 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 10 <title>无标题文档</title> 11 <style type="text/css"> 12 .list{ 100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle} 13 </style> 14 </head> 15 16 <body> 17 18 <div style="100%; height:100px; background-color:#06F"> 19 <h1 style="float:left">大苹果购物网</h1> 20 <a href="zhuxiao.php" style="float:right; margin-top:40px">注销</a> 21 </div><br /> 22 <div style="100%; height:600px"> 23 <div id="left" style="20%; float:left"> 24 <a href="main.php"><div class="list">浏览商品</div></a> 25 <a href=""><div class="list">查看账户</div></a> 26 <a href="gouwuche.php"><div class="list">查看购物车</div></a> 27 </div> 28 <div id="right" style="80%; float:left"> 29 <?php 30 $agwc = array(); 31 if(!empty($_SESSION["gwc"])){ 32 $agwc = $_SESSION["gwc"]; 33 } 34 $zhonglei = count($agwc); 35 $sum = 0; 36 foreach($agwc as $v){ 37 $sql = "select price from fruit where ids='{$v[0]}'"; 38 $danjia = $db->StrQuery($sql); 39 $sum = $sum +$danjia*$v[1]; 40 41 } 42 echo "<div>购物车中有：{$zhonglei}种商品，总价为{$sum}元</div>"; 43 44 ?> 45 <table width="100%" border="1" cellpadding="0" cellspacing="0"> 46 <tr> 47 <td>代号</td> 48 <td>水果名称</td> 49 <td>水果价格</td> 50 <td>原产地</td> 51 <td>库存量</td> 52 <td>操作</td> 53 </tr> 54 <?php 55 56 $sql = "select * from fruit"; 57 $attr = $db->Query($sql); 58 59 foreach($attr as $v){ 60 echo "<tr> 61 <td>{$v[0]}</td> 62 <td>{$v[1]}</td> 63 <td>{$v[2]}</td> 64 <td>{$v[3]}</td> 65 <td>{$v[4]}</td> 66 <td><a href='goumai.php?code={$v[0]}'>购买</a></td> 67 </tr>"; 68 69 } 70 71 ?> 72 73 74 </table> 75 76 </div> 77 </div> 78 </body> 79 </html>
购买处理
1 <?php 2 session_start(); 3 $code = $_GET["code"]; 4 5 if(empty($_SESSION["gwc"])){ 6 //第一次点击购买 7 $attr = array( 8 array($code,1) 9 ); 10 $_SESSION["gwc"] = $attr; 11 12 }else{ 13 //不是第一次购买 14 $attr = $_SESSION["gwc"]; 15 $bs = 0; 16 foreach($attr as $k=>$v){ 17 if($v[0]==$code){ 18 $bs=1; 19 $attr[$k][1] = $attr[$k][1]+1; 20 21 } 22 } 23 //如果没有在数组里面出现 24 if($bs==0){ 25 $shuzu = array($code,1); 26 $attr[] = $shuzu; 27 } 28 $_SESSION["gwc"]=$attr; 29 } 30 header("location:main.php");
购物车页面
1 <?php 2 session_start(); 3 ?> 4 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 5 <html xmlns="http://www.w3.org/1999/xhtml"> 6 <head> 7 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 8 <script src="../../class/jquery-1.11.2.min.js"></script> 9 <title>无标题文档</title> 10 <style type="text/css"> 11 .list{ 100%; height:30px; margin-top:10px; text-align:center; line-height:30px; vertical-align:middle} 12 </style> 13 </head> 14 15 <body> 16 <div style="100%; height:100px; background-color:#06F"> 17 <h1 style="float:left">大苹果购物网</h1> 18 <a href="zhuxiao.php" style="float:right; margin-top:40px">注销</a> 19 </div><br /> 20 <div style="100%; height:600px"> 21 <div id="left" style="20%; float:left"> 22 <a href="main.php"><div class="list">浏览商品</div></a> 23 <a href=""><div class="list">查看账户</div></a> 24 <a href="gouwuche.php"><div class="list">查看购物车</div></a> 25 </div> 26 <div id="right" style="80%; float:left"> 27 <table width="100%" border="1" cellpadding="0" cellspacing="0"> 28 <tr> 29 <td>商品名称</td> 30 <td>商品单价</td> 31 <td>购买数量</td> 32 <td>操作</td> 33 </tr> 34 <?php 35 include("../../class/dbda.class.php"); 36 $db = new DBDA(); 37 $attr = array(); 38 if(!empty($_SESSION["gwc"])){ 39 $attr = $_SESSION["gwc"]; 40 } 41 foreach($attr as $k=>$v){ 42 $sql = "select name,price from fruit where ids='{$v[0]}'"; 43 $ashuiguo = $db->Query($sql); 44 45 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>"; 46 } 47 48 ?> 49 50 </table> 51 <div id="tj">提交订单</div><div id="ts"></div> 52 53 </div> 54 </div> 55 56 <script type="text/javascript"> 57 $("#tj").click(function(){ 58 $.ajax({ 59 url:"dingdan.php", 60 dataType:"TEXT", 61 success: function(data){ 62 if(data.trim()=="OK"){ 63 alert("购买成功"); 64 }else if(data.trim()=="YEBUZU"){ 65 $("#ts").html("余额不足"); 66 $("#ts").css("color","red"); 67 }else{ 68 $("#ts").html(data); 69 $("#ts").css("color","red"); 70 } 71 } 72 73 }) 74 }) 75 </script> 76 </body> 77 </html>
删除
1 <?php 2 session_start(); 3 $sy = $_GET["sy"]; 4 5 $attr = $_SESSION["gwc"]; 6 7 if($attr[$sy][1]>1){ 8 $attr[$sy][1] = $attr[$sy][1]-1; 9 }else{ 10 unset($attr[$sy]); 11 $attr = array_values($attr); 12 } 13 $_SESSION["gwc"] = $attr; 14 15 header("location:gouwuche.php");
订单处理
1 <?php 2 session_start(); 3 include("../../class/dbda.class.php"); 4 $db = new DBDA(); 5 $uid = $_SESSION["uid"]; 6 $attr = array(); 7 if(!empty($_SESSION["gwc"])){ 8 $attr = $_SESSION["gwc"]; 9 } 10 //看两个条件是否都满足 11 $bs = true; 12 13 //判断余额是否满足 14 $syue = "select account from login where username='{$uid}'"; 15 $yue = $db->StrQuery($syue); 16 17 $sum = 0; 18 foreach($attr as $v){ 19 $sql = "select price from fruit where ids='{$v[0]}'"; 20 $danjia = $db->StrQuery($sql); 21 $sum = $sum +$danjia*$v[1]; 22 } 23 24 if($yue<$sum){ 25 $bs = false; 26 echo "YEBUZU"; 27 exit; 28 } 29 30 //判读库存是否满足 31 foreach($attr as $v){ 32 $skucun = "select name,numbers from fruit where ids='{$v[0]}'"; 33 $akucun = $db->Query($skucun); 34 if($akucun[0][1]<$v[1]){ 35 $bs = false; 36 echo "{$akucun[0][0]}库存不足!"; 37 exit; 38 } 39 } 40 41 42 //添加订单，减库存，减余额 43 if($bs){ 44 //减库存 45 foreach($attr as $v){ 46 $sql = "updata fruit set numbers = numbers-{$v[1]} where ids='{$v[0]}'"; 47 $db->Query($sql,0); 48 } 49 50 //减余额 51 $jianyue = "updata login set account=account-{$sum} where username='{$uid}'"; 52 $db->Query($jianyue,0); 53 //添加订单 54 $dingdanhao = $uid+date("YmdHis"); 55 $t = time(); 56 $sorder = "insert into orders values('{$dingdanhao}','{$uid}','{$t}')"; 57 $db->Query($sorder,0); 58 59 foreach($attr as $v){ 60 $sxq = "insert into orderdetails values('','{$dingdanhao}','{$v[0]}','{$v[1]}')"; 61 $db->Query($sxq,0); 62 } 63 64 } 65 echo "OK";