session实现购物车

为实现简单的购物功能(购物车添加、账户查看、购物车商品删除、实时的购物商品数量及价格的计算显示、购物车商品数量可手动输入等),用session实现了一简单的以php语言为基础、连接MySQL数据库的购物车系统。(程彦瑞)

为了实现用户移动及pc端的适应,用媒体查询实现了响应式效果(文章最后实现)。

程序效果

登录界面:

session实现购物车

添加购物车界面(购买数量和总价会在界面动态显示):

session实现购物车

session实现购物车

 可以通过在文本框里输入数字来控制购买数量, 点击删除删除整行,点击清空清所有数据。

session实现购物车

不可在文本框里输入小于零或者其他违法字符:

session实现购物车

提交订单界面:

session实现购物车

点返回购物车中数据没有发生变化,点确认购买库存及账户余额都会相应减少:

点击购买时会先判断余额,如果不足会显示余额不足;然后判断库存,如果不足会显示库存不足;最条件都成立显示购买成功。

session实现购物车

session实现购物车

session实现购物车

session实现购物车

其中登录信息以及商品信息从数据库中导出:

session实现购物车

session实现购物车

需要用到的数据库信息:

session实现购物车

session实现购物车

session实现购物车

session实现购物车

订单选项会显示之前的购买记录:

session实现购物车

 点击会显示详细信息:

session实现购物车

 

做的比较快,大体框架比较简单,还有些许内容待补充、完善。

 

首先登陆界面代码比较简单,直接上代码:

<!doctype html  HTML>
<html lang="en">
	<head>
		<meta charset="UTF-8" />
		<title>Document</title>
	</head>
	<style type="text/css">
* { margin: 0px auto; padding: 0px}
#backimg{
background-image: url('Login/bg.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 100%;
height: 100%;

}
#denglu{
background-image: url('Login/bg2.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 40%;
height: 48%;
position: absolute;
left: 30%;
top: 23%
}
#huanchong{
background-image: url('Login/login-v2-load_02.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 30%;
height: 12%;
cursor: pointer;
}
#huanchong1{
background-image: url('Login/login-v2-load_01.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 28%;
height: 8%;
cursor: pointer;
text-align: right;
padding-top: 4%;
padding-right: 2%;
}
#shuru{
left: 20%;
width: 70%;
position: relative;
top: 40%;
}
#uid{
width: 100%;
}
#pwd{
padding-top: 8%;
padding-bottom: 8%;
width: 100%;
}
	</style>
	<body style=" height: 100%">
		<div id="backimg">
			<div id="denglu" >
				<div id="shuru">
					<form action="dengluchuli.php" method="post" id="myform">
						<div id="uid">
							用户名:
							<input type="text" name="uid"  style="width: 40%; height: 8%" />
						</div>
						<div  id="pwd" >
							密    码:
							<input type="text" name="pwd" style="width: 40%; height: 8%"  />
						</div>
						<div id="huanchong" onclick="denglu()" style="display: block;"></div>
						<div id="huanchong1" style="display: none;">
							<img src="Login/loading.gif" alt="" />
						</div>
					</form>
				</div>
			</div>
		</div>

	</body>
	<script type="text/javascript">function denglu() {
	var a=document.getElementById("huanchong");
	var b=document.getElementById("huanchong1");
	a.style.display="none";
	b.style.display="block";
	document.getElementById("myform").submit();
}</script>
</html>

  

横向长度使用的百分比以,纵向也是用的百分比,前提是使用html5 或者html4 的头部声明:

<!doctype html  HTML>

body标签设置百分比为100%:

<body style=" height: 100%">

登录时失败会直接显示失败,由于做得比较简单,没有进行完善就直接输出了:

session实现购物车

登陆界面的php跳转代码,首先我做了一个登录类(LOGIN.class.php),只是为了以后方便:

<?php
class DBDA {
	public $host = "localhost";
	public $uid = "root";
	public $pwd = "";
	public $dbname = "12345";

	//成员方法
	public function Query($sql, $type = 1) {
		$db = new MySQLi($this -> host, $this -> uid, $this -> pwd, $this -> dbname);
		$r = $db -> query($sql);

		if ($type == 1) {
			return $r -> fetch_all();
		} else {
			return $r;
		}
	}

}

class LoGin {
	public static $uid;
	public static $pwd;
	function __construct($x, $y) {
		self::$uid = $x;
		self::$pwd = $y;
	}

	static function logi($table, $username, $password, $name) {
		$db = new DBDA();
		$nnn = self::$uid;
		$sql = " select $name,$password from $table where $username='$nnn '";
		$at = $db -> Query($sql);
		$p = self::$pwd;
		if (!empty($p) && $p == $at[0][1]) {
			$_SESSION["uid"] = $at[0][0];
			header("location:main.php");
		} else {
			echo "用户名或密码错误";
		}
	}

}
?>

  

还有一个访问数据库的类(DBDA.class.php),直接上代码:

<?php
class DBDA {
	public $host = "localhost";
	public $uid = "root";
	public $pwd = "";
	public $dbname = "12345";

	//成员方法
	public function Query($sql, $type = 1) {
		$db = new MySQLi($this -> host, $this -> uid, $this -> pwd, $this -> dbname);
		$r = $db -> query($sql);

		if ($type == 1) {
			return $r -> fetch_all();
		} else {
			return $r;
		}
	}

}

  

使用时直接输入变量和登录数据库的信息就可以了(dengluchuli.php):

<?php
session_start();
include("LOGIN.class.php");
$dd = new LoGin($_POST["uid"],$_POST["pwd"]);
$ae = $dd::logi("login","username","password","name");
?>

 

登录界面做完之后是主界面:

<!doctype html HTML>
<html lang="en">
	<head>
		<meta charset="UTF-8" />
		<title>Document</title>
	</head>
	<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#right {
		position: relative;
		float: right;
		width: 60%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
	table {
		text-align: center;
	}
	table tr td {
		height: 40px;
	}
	table tr th {
		height: 40px;
	}
</style>
	<body style="height: 100%;">

		<div id="back">
			<div id="top" >
				大苹果购物网

			</div>
			<div id="denglu">
				欢迎您,
				<span style=" color:white;"> <?php
				session_start();

				if (empty($_SESSION["uid"])) {
					header("location:denglu.php");
					exit ;
				}
				include ("DBDA.class.php");

				echo $_SESSION["uid"];
				?> </span>
				!
			</div>

			<div style="height: 70%; ">
				<div id="left">
					<ul>
						<li>
							<a href="main.php">
								浏览商品
							</a>
						</li>
						<li>
							<a href=" zhanghu.php ">
								查看账户
							</a>
						</li>
						<li>
							<a href="gouwuche.php">
								查看购物车
							</a>
						</li>
						<li>
							<a href="dingdan.php">
								订单信息
							</a>
						</li>
					</ul>
				</div>
				<div id="right">

					<?php

					if (!empty($_SESSION["gwc"])) {
						$atter = $_SESSION["gwc"];
						$sum = 0;
						$total = 0;
						foreach ($atter as $v) {
							$db = new DBDA();
							$sql = " select price from fruit where name = '{$v[0]}' ";
							$at1 = $db -> Query($sql);
							$total = $total + $at1[0][0] * $v[1];
							$sum = $sum + $v[1];
						}
						echo "<div style=' background-color: white;  width: 100%; ' >购物车中有{$sum}件商品,总价格为:{$total} 元。</div>";

					}
				?>

<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr style="background-color: darksalmon;"><th>代号</th><th>水果名称</th><th>水果价格</th><th>原产地</th><th>货架</th><th>库存量</th><th></th></tr>
<?php
$dd = new DBDA();
$sql1 = " select * from fruit ";
$at = $dd -> Query($sql1);
for ($i = 0; $i < count($at); $i++) {
	if ($i % 2 == 0) {
		echo " <tr style=' background-color:  cornflowerblue ;'>
<td>  {$at[$i][0]}</td>
<td>{$at[$i][1]}</td>
<td>{$at[$i][2]}</td>
<td>{$at[$i][3]}</td>
<td>{$at[$i][4]}</td>
<td>{$at[$i][5]}</td>
<td><a href='jia.php?name={$at[$i][1]}' onclick=\"return confirm('确定购买么')\">购买 </a></td>
</tr> ";
	} else {
		echo " <tr style='background-color:whitesmoke ;'>
<td>  {$at[$i][0]}</td>
<td>{$at[$i][1]}</td>
<td>{$at[$i][2]}</td>
<td>{$at[$i][3]}</td>
<td>{$at[$i][4]}</td>
<td>{$at[$i][5]}</td>
<td><a href='jia.php?name={$at[$i][1]}' onclick=\"return confirm('确定购买么')\">购买 </a></td>
</tr> ";
	}

}
					?>

					</table>
				</div>
			</div>
			<div id="bottom" style="padding-top: 1%;">
				发瑞
			</div>
		</div>
	</body>

</html>

  

然后是实现点击购买动态的在表格上方显示商品数量和总价(jia.php):

<?php
session_start();
if (empty($_SESSION["uid"])) {
	header("location:denglu.php");
	exit ;
}
$name = $_GET["name"];
include ("DBDA.class.php");
$db = new DBDA();
$sql = " select price,numbers from fruit where name='{$name}' ";
$at = $db -> Query($sql);
if (empty($_SESSION["gwc"])) {
	$atter = array( array($name, 1, $at[0][0], $at[0][1]));
	$_SESSION["gwc"] = $atter;
} else {
	$atter = $_SESSION["gwc"];
	if (panduan($name, $atter)) {
		for ($i = 0; $i < count($atter); $i++) {
			if ($name == $atter[$i][0]) {
				$atter[$i][1]++;
			}
		}
		$_SESSION["gwc"] = $atter;
	} else {
		$arr = array($name, 1, $at[0][0], $at[0][1]);
		$atter[] = $arr;
		$_SESSION["gwc"] = $atter;
	}
}
function panduan($name, $atter) {
	$n = 0;
	foreach ($atter as $v) {
		if ($name == $v[0]) {
			$n++;
		}
	}
	if ($n == 0) {
		return false;
	} else {
		return true;
	}
}

header("location:main.php");
?>

  session实现购物车

查看账户界面比较简单,就是直接访问数据库就可以了:

<!doctype html HTML>
<html lang="en">
	<head>
		<meta charset="UTF-8" />
		<title>Document</title>
	</head>
	<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#he {
		height: 70%;
	}
	#right {
		background-color: white;
		position: relative;
		float: right;
		width: 55%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
		margin-right: 5%;
		margin-top: 2%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
</style>
	<body style="height: 100%;">

		<div id="back">
			<div id="top" >
				大苹果购物网

			</div>
			<div id="denglu">
				欢迎您,
				<span style=" color:white;"> <?php
				session_start();

				if (empty($_SESSION["uid"])) {
					header("location:denglu.php");
					exit ;
				}
				include ("DBDA.class.php");

				echo $_SESSION["uid"];
				?></span>
				!
			</div>

			<div  id="he">
				<div id="left">
					<ul>
						<li>
							<a href="main.php">
								浏览商品
							</a>
						</li>
						<li>
							<a href="zhanghu.php">
								查看账户
							</a>
						</li>
						<li>
							<a href="gouwuche.php">
								查看购物车
							</a>
						</li>
						<li>
							<a href="dingdan.php">
								订单信息
							</a>
						</li>
					</ul>
				</div>
				<div id="bao">

					<div id="right">
						您的账户中还有余额
						<span style="color: red;" > <?php

						$uid = $_SESSION["uid"];

						$db = new DBDA();
						$sql = " select account from login where name='{$uid}' ";
						$at = $db -> Query($sql);
						echo $at[0][0];
						?></span>

						元。
					</div>
				</div>
			</div>
			<div id="bottom" style="padding-top: 1%;">
				发瑞
			</div>
		</div>
	</body>

</html>

  

session实现购物车

 

 查看订单界面(dingdan.php)也比较简单,但是数据库中的内容是在提交订单界面,把数据传入数据库的,然后这个界面直接访问数据库就可以了:

<!doctype html HTML>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Document</title>
</head>

<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#right {
		position: relative;
		float: right;
		width: 60%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
	table {
		text-align: center;
	}
	table tr td {
		height: 40px;
	}
	table tr th {
		height: 40px;
	}
</style>
<body style="height: 100%;">

<div id="back">
<div id="top" >
大苹果购物网

</div>
<div id="denglu">
欢迎您,
<span style=" color:white;">
<?php
session_start();

if (empty($_SESSION["uid"])) {
	header("location:denglu.php");
	exit ;

}

echo $_SESSION["uid"];
?>
</span>
!
</div>

<div style="height: 70%; ">
<div id="left">
<ul>
<li><a href="main.php">浏览商品</a></li>
<li><a href="zhanghu.php">查看账户</a></li>
<li><a href="gouwuche.php">查看购物车</a></li>
<li><a href="dingdan.php">订单信息</a></li>
</ul>
</div>
<div id="right">
<table border="0" cellspacing="0" cellpadding="0" width="90%">
<tr style="background-color:salmon;"><th>订单号</th><th>订购人</th><th>订购时间</th><th></th></tr>

<?php

include ("DBDA.class.php");
$db = new DBDA();
$sql = "select * from orders ";
$v = $db -> Query($sql);
for ($i = 0; $i < count($v); $i++) {
	if ($i % 2 == 0) {
		echo " <tr style='background-color: burlywood;'><td> {$v[$i][0]}</td><td> {$v[$i][1]}</td><td> {$v[$i][2]}</td><td><a href='chakan.php?code={$v[$i][0]}'> 查看详情</a></td></tr> ";
	} else {
		echo "<tr style='background-color: darkgrey;'><td> {$v[$i][0]}</td><td> {$v[$i][1]}</td><td> {$v[$i][2]}</td><td><a href='chakan.php?code={$v[$i][0]}'> 查看详情</a></td></tr>";
	}
}
?>
</table>

</div>
</div>
<div id="bottom" style="padding-top: 1%;">
发瑞
</div>
</div>
</body>
</html>

session实现购物车

  

查看详情(chakan.php)也是直接通过上一层的a标签get一个索引:

<!doctype html HTML>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Document</title>
</head>

<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#right {
		position: relative;
		float: right;
		width: 60%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
	table {
		text-align: center;
	}
	table tr td {
		height: 40px;
	}
	table tr th {
		height: 40px;
	}
</style>
<body style="height: 100%;">

<div id="back">
<div id="top" >
大苹果购物网

</div>
<div id="denglu">
欢迎您,
<span style=" color:white;">
<?php
session_start();

if (empty($_SESSION["uid"])) {
	header("location:denglu.php");
	exit ;
}

echo $_SESSION["uid"];
?>
</span>
!
</div>

<div style="height: 70%; ">
<div id="left">
<ul>
<li><a href="main.php">浏览商品</a></li>
<li><a href="zhanghu.php">查看账户</a></li>
<li><a href="gouwuche.php">查看购物车</a></li>
<li><a href="dingdan.php">订单信息</a></li>
</ul>
</div>
<div id="right">
<table border="0" cellspacing="0" cellpadding="0" width="90%">
<tr style="background-color:salmon;"><th>水果名称</th><th></th><th>水果数量</th></tr>

<?php

include ("DBDA.class.php");
$db = new DBDA();

$sql = "select fruitname,count from orderdetails where ordercode='{$_GET["code"]}' ";
$v = $db -> Query($sql);

for ($i = 0; $i < count($v); $i++) {
	if ($i % 2 == 0) {
		echo " <tr style='background-color: burlywood;'><td> {$v[$i][0]}</td><td> ×</td><td> {$v[$i][1]}</td></tr>";
	} else {
		echo "<tr style='background-color: darkgrey;'><td> {$v[$i][0]}</td><td> ×</td><td> {$v[$i][1]}</td></tr>";
	}
}
?>
</table>

</div>
</div>
<div id="bottom" style="padding-top: 1%;">
发瑞
</div>
</div>
</body>
</html>

  

session实现购物车

 

 这个项目主要是查看购物车界面比较复杂,需要多条件判断,引入多个session。

 首先购物车里的信息是放在   $_SESSION["gwc"]     里面,

 还有 购物商品总数  $_SESSION["sum"]   购物商品总价格  $_SESSION["total"] 。订单确认之后访问数据库减少相应金额,订单数据同时也导入数据库,同时库存也相应减少。

 

上代码(gouwuche.php):

<!doctype html HTML>
<html lang="en">
	<head>
		<meta charset="UTF-8" />
		<title>Document</title>
	</head>

	<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#right {
		position: relative;
		float: right;
		width: 60%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
	table {
		text-align: center;
	}
	table tr td {
		height: 40px;
	}
	table tr th {
		height: 40px;
	}
</style>
	<body style="height: 100%;">

		<div id="back">
			<div id="top" >
				大苹果购物网

			</div>
			<div id="denglu">
				欢迎您,
				<span style=" color:white;"> <?php
				session_start();

				if (empty($_SESSION["uid"])) {
					header("location:denglu.php");
					exit ;
				}
				if (!empty($_SESSION["sz"])) {
					echo " <script>alert('输入须为大于零的数')   </script> ";
					$_SESSION["sz"] = '';
				}

				echo $_SESSION["uid"];
				?> </span>
				!
			</div>

			<div style="height: 70%; ">
				<div id="left">
					<ul>
						<li>
							<a href="main.php">
								浏览商品
							</a>
						</li>
						<li>
							<a href="zhanghu.php">
								查看账户
							</a>
						</li>
						<li>
							<a href="gouwuche.php">
								查看购物车
							</a>
						</li>
						<li>
							<a href="dingdan.php">
								订单信息
							</a>
						</li>
					</ul>
				</div>
				<div id="right">

					<table border="0" cellspacing="0" cellpadding="0" width="80%">
						<tr style="background-color: darksalmon;">
							<th colspan="5">购物车中有以下商品</th>
						</tr>
						<tr style="background-color:whitesmoke ; ">
							<td>商品名称</td><td>商品单价</td><td>购买数量</td><td>库存</td><td></td>
						</tr>

						<form action="tijiao.php" method="post">

						<?php

						if (!empty($_SESSION["gwc"])) {
							$_SESSION["gwc"] = array_values($_SESSION["gwc"]);
							$atter = $_SESSION["gwc"];
							for ($i = 0; $i < count($atter); $i++) {
								if ($i % 2 == 0) {
									echo " <tr style='background-color:cornflowerblue;'><td>{$atter[$i][0]} </td><td>{$atter[$i][2]} </td> <td><input type='text' name='{$atter[$i][0]}'  value='{$atter[$i][1]}'  style='width:20%' />  </td><td>{$atter[$i][3]}</td> <td> <a href ='shanchu.php?name={$i}' onclick=\"return confirm('确定删除么')\">删除</a> </td></tr> ";
								} else {
									echo " <tr style='background-color:whitesmoke ;'><td>{$atter[$i][0]} </td><td>{$atter[$i][2]} </td><td><input type='text' name='{$atter[$i][0]}'  value='{$atter[$i][1]}'  style='width:20%' />  </td><td>{$atter[$i][3]}</td><td> <a href ='shanchu.php?name={$i}' onclick=\"return confirm('确定删除么')\">删除</a> </td></tr> ";
								}
							}
						}
					?>
<tr style='text-align: right;'><td colspan='5'> <input type='submit'    value='提交订单' style='width: 20%; height: 100%;'  />
</form>
<div id="xianshi" style=" float: left; ">
<?php

if (!empty($_SESSION["low"])) {
	echo $_SESSION["low"];
	unset($_SESSION["low"]);
} else if (!empty($_SESSION["cun"])) {
	echo $_SESSION["cun"];
	unset($_SESSION["cun"]);
} else {
	if (!empty($_SESSION["success"])) {
		echo $_SESSION["success"];
		unset($_SESSION["success"]);
	}

}
						?>
						</div>

						</td> </tr>
						<tr style='text-align: right;'>
							<td colspan='5'>
								<a href="qingkong.php">
									<input type="button"  style='width: 20%; height: 100%;' value="清空购物车" />
								</a></td>
						</tr>
					</table>

				</div>
			</div>
			<div id="bottom" style="padding-top: 1%;">
				发瑞
			</div>
		</div>
	</body>
</html>

  

session实现购物车

没有添加购物车是是空。

 

添加过商品了:

session实现购物车

 

通关文本框输入数字来操作购买数量:

session实现购物车

存货不足时:

session实现购物车

余额不足时:

session实现购物车

判断条件会先判断余额,在判断库存,最后点击提交订单确认确认:

session实现购物车

确认之前会跳转一个处理界面(tijiao.php)是判断输入信息是否合法,输入库存是否符合,余额是否符合:

<?php
session_start();
if (empty($_SESSION["uid"])) {
	header("location:denglu.php");
	exit ;
}
$atter = $_SESSION["gwc"];
for ($i = 0; $i < count($atter); $i++) {
	if (!empty($_POST[$atter[$i][0]])) {
		$sz = $_POST[$atter[$i][0]];
		if (is_numeric($sz) && $sz > 0) {
			$atter[$i][1] = $_POST[$atter[$i][0]];
		} else {
			$_SESSION["sz"] = "输入须为大于零的数字";
			header("location:gouwuche.php");
			exit ;
		}

	}
}
$_SESSION["gwc"] = $atter;

include ("DBDA.class.php");
//求商品数和总价格
$sum = 0;
$total = 0;
for ($i = 0; $i < count($atter); $i++) {
	$dbd = new DBDA();
	$sqld = " select price from fruit where name = '{$atter[$i][0]}' ";
	$at1 = $dbd -> Query($sqld);
	$total = $total + $at1[0][0] * $atter[$i][1];
	$sum = $sum + $atter[$i][1];
}

$uid = $_SESSION["uid"];

$db = new DBDA();
$sql = " select account from login where name = '{$uid}' ";
$ss = $db -> Query($sql);

if (!empty($atter) && $ss[0][0] < $total) {
	$_SESSION["low"] = "账户余额不足";
	header("location:gouwuche.php");
} else {
	$cunbuzu = "";
	foreach ($atter as $v) {
		if ($v[1] > $v[3]) {
			$cunbuzu = $cunbuzu . $v[0] . "的存货不足。";
			$_SESSION["cun"] = $cunbuzu;

		}

	}
	if (!empty($cunbuzu)) {
		header("location:gouwuche.php");
		exit ;
	}
	if (empty($cunbuzu) && !empty($atter)) {
		$_SESSION["price"] = $total;
		$_SESSION["sum"] = $sum;
		header("location:querengoumai.php");
	} else {
		header("location:gouwuche.php");
	}

}
?>

  

购物车中点击删除会删除本条数据,点击清空会删除所有数据(qingkong.php)。

<?php
session_start();
if(empty($_SESSION["uid"]))
{
header("location:denglu.php");
exit;
}
$_SESSION["gwc"] = "";
header("location:gouwuche.php");
?>

  

删除一条数据代码(shanchu.php):

<?php
session_start();
if(empty($_SESSION["uid"]))
{
header("location:denglu.php");
exit;
}
$atter = $_SESSION["gwc"];
$i = $_GET["name"];

if( count($atter)==1  )
{
	$atter = "";
}
else{
		unset($atter[$i]);
	}
$_SESSION["gwc"]=$atter;
header("location:gouwuche.php");
?>

  

确认界面点击返回购物车信息不变,账户余额不变,点击购买操作数据库和引入session。

直接上代码(querengoumai.php):

<!doctype html HTML>
<html lang="en">
	<head>
		<meta charset="UTF-8" />
		<title>Document</title>
	</head>
	<style type="text/css">
	* {
		margin: 0px auto;
		padding: 0px;
	}
	a {
		text-decoration: none;
	}
	#back {
		background-image: url(Login/bg.jpg);
		background-size: 100% 100%;
		background-repeat: no-repeat;
		height: 100%;
		width: 100%;
	}
	#top {
		height: 10%;
		font-size: 36px;
		padding-top: 2%;
		padding-left: 4%;
		font-family: "微软雅黑";
		font-weight: 700;
		color: white;
	}
	#denglu {
		text-align: right;
		padding-right: 5%;
		font-size: 24px;
	}
	#left {
		padding-left: 15%;
		position: relative;
		float: left;
		height: 70%;
		padding-top: 10%;
	}
	#left ul li {
		display: block;
		margin-top: 20%;
		font-size: 24px;
	}
	#he {
		height: 70%;
	}
	#right {
		position: relative;
		float: right;
		width: 55%;
		padding-right: 5%;
		padding-top: 2%;
		height: 82%;
		margin-right: 5%;
		margin-top: 2%;
	}
	#bottom {
		font-size: 24px;
		color: white;
		text-align: center;
	}
</style>
	<body style="height: 100%;">

		<div id="back">
			<div id="top" >
				大苹果购物网

			</div>
			<div id="denglu">
				欢迎您,
				<span style=" color:white;"> <?php
				session_start();

				if (empty($_SESSION["uid"])) {
					header("location:denglu.php");
					exit ;
				}
				include ("DBDA.class.php");

				echo $_SESSION["uid"];
				?> </span>
				!
			</div>

			<div  id="he">
				<div id="left">
					<ul>
						<li>
							<a href="main.php">
								浏览商品
							</a>
						</li>
						<li>
							<a href="zhanghu.php">
								查看账户
							</a>
						</li>
						<li>
							<a href="gouwuche.php">
								查看购物车
							</a>
						</li>
						<li>
							<a href="dingdan.php">
								订单信息
							</a>
						</li>
					</ul>
				</div>
				<div id="bao">

					<div id="right">

						<table border="0" cellspacing="0" cellpadding="0" width="50%" style="text-align: center;">
							<tr style="background-color:red;">
								<th colspan="3">订单详情</th>
							</tr>
							<?php
							$atter = $_SESSION["gwc"];
							for ($i = 0; $i < count($atter); $i++) {
								if ($i % 2 == 0) {
									echo "<tr style='background-color: blueviolet;'><td> {$atter[$i][0]} </td><td>× </td><td> {$atter[$i][1]} </td></tr> ";
								} else {
									echo "<tr style='background-color:greenyellow;'><td> {$atter[$i][0]} </td><td>× </td><td> {$atter[$i][1]} </td></tr> ";
								}
								$total = $_SESSION["price"];
								$sum = $_SESSION["sum"];
							}
						?>
<tr style="background-color:white;"><td colspan="3">商品总价为<?php echo "$total"   ?>
							元</td></tr>
							<tr style="background-color:white;">
								<td colspan="3">
									<a href="goumaichuli.php">
										<input type="button" name="" id="" value="确认购买" />
									</a>
									<a href="gouwuche.php">
										<input type="button" name="" id="" value="返回购物车" />
									</a></td>
							</tr>
						</table>
					</div>
				</div>
			</div>
			<div id="bottom" style="padding-top: 1%;">
				发瑞
			</div>
		</div>
	</body>

</html>

  

 之后是购买提交之后的后台数据库处理界面(goumaichuli.php):

<?php
session_start();
if(empty($_SESSION["uid"]))
{
header("location:denglu.php");
exit;
}
include("DBDA.class.php");
$total = $_SESSION["price"];
$atter = $_SESSION["gwc"];
$uid = $_SESSION["uid"];
$db= new DBDA();
$sql = " select account from login where name = '{$uid}' ";
$ss = $db->Query($sql);
$ss[0][0] = $ss[0][0]-$total;
	    $_SESSION["success"] = "购买成功";
		$sql1 = " update login set account={$ss[0][0]} where name='{$uid }'  ";
		$zhifu = $db->Query($sql1,0);
		for($i =0 ;$i<count($atter);$i++)
		{
			$df = new DBDA();
			$sqq =  " select numbers from fruit where name = '{$atter[$i][0]}'  ";
			$tt = $df->Query($sqq);
			$tt[0][0] = $tt[0][0] -$atter[$i][1];
			$df1 = new DBDA();
			$sqq1 = " update fruit set numbers='{$tt[0][0]}' where name = '{$atter[$i][0]}' ";
			$tt1 = $df1->Query($sqq1,0);
		}

//订单表制作
$ddbzz = $_SESSION["gwc"];

$time = date("Y-m-d,h:i:s");
$sqldd = " select count(*) from orders ";
$nb = $df1->Query($sqldd);
$code = $nb[0][0];
$code = $num=str_pad($code,4,"0",STR_PAD_LEFT);
$sqlgmr = " select username from login where name = '{$uid}' ";
$nn = $df1->Query($sqlgmr);
$ordercode = $nn[0][0].$code;
$sqltj = " insert into orders values('{$ordercode}','{$uid}','{$time}') ";
$ntj= $df1->Query($sqltj,0);

//订单详情表

foreach($ddbzz as $n)
{
	$sqllz= " insert into orderdetails values('','{$ordercode}','{$n[0]}','{$n[1]}') ";
	$ordertj = $df1->Query($sqllz,0);
}

unset($_SESSION["gwc"] );
header("location:gouwuche.php")
?>

  

查看数据库,数据库中内容改变成功。

 

 

 代码还剩媒体查询内容,以登录界面做例子就是屏宽在范围之内用另一套css样式,直接代码:

@media only screen and (max-width: 500px){                 //屏宽小于500px
* { margin: 0px auto; padding: 0px}
#backimg{
background-image: url('Login/bg.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 100%;
height: 100%;

}
#denglu{
background-image: url('Login/bg2.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 80%;
height: 40%;
position: absolute;
left: 5%;
top: 23%
}
#huanchong{
background-image: url('Login/login-v2-load_02.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 30%;
height: 12%;
cursor: pointer;
}
#huanchong1{
background-image: url('Login/login-v2-load_01.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 28%;
height: 8%;
cursor: pointer;
text-align: right;
padding-top: 4%;
padding-right: 2%;
}
#shuru{
left: 20%;
width: 70%;
position: relative;
top: 40%;
}
#uid{
width: 100%;
}
#pwd{
padding-top: 8%;
padding-bottom: 8%;
width: 100%;
}
}
@media only screen and (min-width: 500px){                                   //屏宽大于500
* { margin: 0px auto; padding: 0px}
#backimg{
background-image: url('Login/bg.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 100%;
height: 100%;

}
#denglu{
background-image: url('Login/bg2.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 55%;
height: 38%;
position: absolute;
left: 20%;
top: 23%
}
#huanchong{
background-image: url('Login/login-v2-load_02.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 30%;
height: 10%;
cursor: pointer;
}
#huanchong1{
background-image: url('Login/login-v2-load_01.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 28%;
height: 7%;
cursor: pointer;
text-align: right;
padding-top: 4%;
padding-right: 2%;
}
#shuru{
left: 20%;
width: 70%;
position: relative;
top: 40%;
}
#uid{
width: 100%;
}
#pwd{
padding-top: 8%;
padding-bottom: 8%;
width: 100%;
}
}
@media only screen and (min-width: 768px){                                  //屏宽768以上
* { margin: 0px auto; padding: 0px}
#backimg{
background-image: url('Login/bg.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 100%;
height: 100%;

}
#denglu{
background-image: url('Login/bg2.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 50%;
height: 48%;
position: absolute;
left: 20%;
top: 23%
}
#huanchong{
background-image: url('Login/login-v2-load_02.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 30%;
height: 12%;
cursor: pointer;
}
#huanchong1{
background-image: url('Login/login-v2-load_01.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 28%;
height: 8%;
cursor: pointer;
text-align: right;
padding-top: 4%;
padding-right: 2%;
}
#shuru{
left: 20%;
width: 70%;
position: relative;
top: 40%;
}
#uid{
width: 100%;
}
#pwd{
padding-top: 8%;
padding-bottom: 8%;
width: 100%;
}
}
@media only screen and (min-width: 1024px){                               //屏宽1024以上
* { margin: 0px auto; padding: 0px}
#backimg{
background-image: url('Login/bg.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 100%;
height: 100%;

}
#denglu{
background-image: url('Login/bg2.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 40%;
height: 48%;
position: absolute;
left: 30%;
top: 23%
}
#huanchong{
background-image: url('Login/login-v2-load_02.jpg');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 30%;
height: 12%;
cursor: pointer;
}
#huanchong1{
background-image: url('Login/login-v2-load_01.png');
background-size: 100% 100%;
background-repeat:no-repeat;
width: 28%;
height: 8%;
cursor: pointer;
text-align: right;
padding-top: 4%;
padding-right: 2%;
}
#shuru{
left: 20%;
width: 70%;
position: relative;
top: 40%;
}
#uid{
width: 100%;
}
#pwd{
padding-top: 8%;
padding-bottom: 8%;
width: 100%;
}
}
	</style>

  

会实现:

响应式

session实现购物车

session实现购物车

其他是相同道理:

session实现购物车

session实现购物车

上一篇:C. Garland 找规律找规律找规律


下一篇:使用MongoDB和JSP实现一个简单的购物车系统