Overall code display
1, Project directory:
##2, All code display:
conn.inc.php:
<style> .shoppingcartempty {background: #00FF00} </style> <?php header("Content-type:text/html;charset=utf-8"); include "mysqli.php"; $a=isset($_GET["a"])?$_GET["a"]:""; //添加购物车 if($a=="addshoppingcart"){ $buynum=$_POST["buynum"]; $id=$_POST["id"]; // echo "<script>alert($buynum+$id)</script>"; if(!empty($_COOKIE["shoppingcart"])) $shoppingcart=unserialize($_COOKIE["shoppingcart"]); else $shoppingcart=array(); if(isset($id) && isset($buynum)){ $id=intval($id); $buynum=intval($buynum); $shoppingcart[]=array($id,$buynum); } setcookie('shoppingcart',serialize($shoppingcart)); return "true"; } //取消购物车里的一件商品 elseif($a=="delone"){ $key=$_GET["key"]; $shoppingcart=unserialize($_COOKIE["shoppingcart"]); unset($shoppingcart[$key]); if(empty($_COOKIE)){ setcookie($shoppingcart,"",time()-3600); }else{ setcookie("shoppingcart",serialize($shoppingcart)); } header("location:shoppingcart.php"); exit(); } //清空购物车 elseif($a=="empty"){ unset($_COOKIE["shoppingcart"]); setcookie("shoppingcart","",time()-3600); echo "<div class='shoppingcartempty'>您的购物车目前没有商品!3秒后跳回首页......</div>"; header("Refresh:3;url=goods.php"); } elseif($a=="buynow") { if (!empty($_COOKIE["shoppingcart"])) { ?> <table width="36%" border="1" cellspacing="0" cellpadding="0"> <tr bgcolor="#87ceeb"> <td width="20%">商品ID</td> <td width="35%" height="30">商品名称</td> <td width="25%">购买数量</td> <td width="15%">价格</td> <td width="5%">操作</td> </tr> <tr> <td height="10" colspan="4"></td> </tr> <?php $totalprice = ""; $shoppingcart = unserialize($_COOKIE["shoppingcart"]); foreach ($shoppingcart as $key => $value) { $keys = array($key); ?> <tr> <td><?php echo $value[0] ?></td> <td height="30"> <?php $sql = "select *from goods where id=" . intval($value[0]); $result = $mysqli->query($sql); $row = $result->fetch_assoc(); $totalprice += $row["salesprice"] * $value[1]; echo '<a href="goodsshow.php?cid=' . $row['goodstypeid'] . '&id=' . $row['id'] . '" class="title" target="_blank">' . $row['title'] . '</a>'; ?> </td> <td><?php echo $value[1] ?></td> <td><?php echo $row["salesprice"] * $value[1] ?></td> <td><a href="shoppingcart.php?a=delone&key=<?php echo $key ?>" onclick="">取消</a></td> </tr> <?php } ?> </table> <hr> <span style="float: left;width: 250px;height: 150px"> 总价格:<?php echo $totalprice ?><a href="">下一步</a> <a href="shoppingcart.php?a=empty">清空购物车</a> </span> <?php } } ?>
goods.php:
<?php header("Content-type:text/html;charset=utf-8"); include "mysqli.php"; ?> <div style='width:800px;float:none'> <h1>商品列表</h1> <!-- 显示当前系统时间--> <h3><p id="demo"></p> <script> var myVar=setInterval(function(){myTimer()},1000); function myTimer() { var d = new Date(); document.getElementById("demo").innerHTML = d.toLocaleTimeString(); } </script> </h3> <form method="get" action=""> <table style="100%" border="1"> <tr> <td> <select name="gid"> <option value="0">请选择商品</option> <?php function show($fid,$i) { global $mysqli; $sql = "select *from goodstype where fid=$fid"; $result = $mysqli->query($sql); $str=" "; $i++; for($n=1;$n<$i;$n++) { $str .= "---"; } $id=$_GET["gid"]; ?> <?php while ($row = $result->fetch_assoc()) { ?> <option <?php if($id==$row['id']){echo "selected";}?> id="<?php echo $str.$row["classname"] ?>" value="<?php echo $row["id"] ?>"> <?php echo $str.$row["classname"] ?> </option> <?php show($fid=$row["id"],$i); ?> <?php } } show(0,0); ?> <input id="select" type="submit" value="查询"></select></td></tr> </table> </form> </div> <div style="float: none;width: 600px"> <?php $id=isset($_GET["gid"])?$id=$_GET["gid"]:""; if(!empty($id)){ $sql="select *from goods where goodstypefid=$id or goodstypefstr like '%$id%' and checkinfo=1 and delstate=0"; }else{ $sql="select *from goods"; } $result=$mysqli->query($sql); ?> <table border="1" cellpadding="3" cellspacing="0" width="60%"> <tr bgcolor="skyblue"> <?php while($row=$result->fetch_assoc()){ ?> <td > <image width="200px" height="200px" src="<?php echo $row["picurl"]?>"></image> <a title="查看商品详细信息" href="goodsshow.php?id=<?php echo $row["id"]?>"><?php echo $row["title"]?></a> </td> <?php } ?> </tr> </table> </div>
goodsshow. php:
<?php header("Content-type:text/html;charset=utf-8"); include "mysqli.php"; ?> <script src="./jquery-1.11.0.js"></script> <script> //立即购买 function buynow(){ //先添加到购物车再进行跳转到购买页面 addshoppingcart("buy"); } //添加到购物车 function addshoppingcart(a){ $.ajax({ url:"shoppingcart.php?a=addshoppingcart", type:"post", data:{'buynum':$("#buynum").val(),'id':$("#id").val()}, dataType:"html", success:function (data) { if(a=="buy"){ location.href="shoppingcart.php?a=buynow"; }else{ if(data){ alert("添加购物车成功!"); } } } }) } </script> <?php $id=isset($_GET["id"])?$_GET["id"]:1; $sql="update goods set hits=hits+1 where id=".$id; $mysqli->query($sql); $sql="select *from goods where id=".$id; $result=$mysqli->query($sql); while($row=$result->fetch_assoc()){ ?> <div> <span><?php echo $row["title"] ?></span> <hr> <image src="<?php echo $row["picurl"] ?>" width="200"></image> <br> 数量:-<input type="text" id="buynum" value="1">+ 价格: <del>市场价:<?php echo $row["marketprice"] ?></del> 出售价:<i style="color: red"><?php echo $row["salesprice"] ?></i> <input type="hidden" id="id" value="<?php echo $row["id"] ?>"> <hr> 内容:<?php echo $row["content"] ?><br> <a href="javascript:;" onclick="buynow()">立刻购买</a> <a href="javascript:;" onclick="addshoppingcart()">加入购物车</a> <?php } ?> </div>
mysqli.php:
<?php include 'conn.inc.php'; $mysqli=new mysqli(HOST,USER,PWD,DBNAME); if($mysqli->connect_errno){ die('数据库链接出错'.$mysqli->connect_error); }
<style>
.shoppingcartempty {background: #00FF00}
</style>
<?php
header("Content-type:text/html;charset=utf-8");
include "mysqli.php";
$a=isset($_GET["a"])?$_GET["a"]:"";
//添加购物车
if($a=="addshoppingcart"){
$buynum=$_POST["buynum"];
$id=$_POST["id"];
// echo "<script>alert($buynum+$id)</script>";
if(!empty($_COOKIE["shoppingcart"]))
$shoppingcart=unserialize($_COOKIE["shoppingcart"]);
else
$shoppingcart=array();
if(isset($id) && isset($buynum)){
$id=intval($id);
$buynum=intval($buynum);
$shoppingcart[]=array($id,$buynum);
}
setcookie('shoppingcart',serialize($shoppingcart));
return "true";
}
//取消购物车里的一件商品
elseif($a=="delone"){
$key=$_GET["key"];
$shoppingcart=unserialize($_COOKIE["shoppingcart"]);
unset($shoppingcart[$key]);
if(empty($_COOKIE)){
setcookie($shoppingcart,"",time()-3600);
}else{
setcookie("shoppingcart",serialize($shoppingcart));
}
header("location:shoppingcart.php");
exit();
}
//清空购物车
elseif($a=="empty"){
unset($_COOKIE["shoppingcart"]);
setcookie("shoppingcart","",time()-3600);
echo "<div class='shoppingcartempty'>您的购物车目前没有商品!3秒后跳回首页......</div>";
header("Refresh:3;url=goods.php");
}
elseif($a=="buynow") {
if (!empty($_COOKIE["shoppingcart"])) {
?>
<table width="36%" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#87ceeb">
<td width="20%">商品ID</td>
<td width="35%" height="30">商品名称</td>
<td width="25%">购买数量</td>
<td width="15%">价格</td>
<td width="5%">操作</td>
</tr>
<tr>
<td height="10" colspan="4"></td>
</tr>
<?php
$totalprice = "";
$shoppingcart = unserialize($_COOKIE["shoppingcart"]);
foreach ($shoppingcart as $key => $value) {
$keys = array($key);
?>
<tr>
<td><?php echo $value[0] ?></td>
<td height="30">
<?php
$sql = "select *from goods where id=" . intval($value[0]);
$result = $mysqli->query($sql);
$row = $result->fetch_assoc();
$totalprice += $row["salesprice"] * $value[1];
echo '<a href="goodsshow.php?cid=' . $row['goodstypeid'] . '&id=' . $row['id'] . '" class="title" target="_blank">' . $row['title'] . '</a>';
?>
</td>
<td><?php echo $value[1] ?></td>
<td><?php echo $row["salesprice"] * $value[1] ?></td>
<td><a href="shoppingcart.php?a=delone&key=<?php echo $key ?>" onclick="">取消</a></td>
</tr>
<?php
}
?>
</table>
<hr>
<span style="float: left;width: 250px;height: 150px">
总价格:<?php echo $totalprice ?><a href="">下一步</a> <a href="shoppingcart.php?a=empty">清空购物车</a>
</span>
<?php
}
}
?>