购物

于 2018-02-01 16:17:00 发布
阅读量85 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： php json 数据库
原文链接：http://www.cnblogs.com/navyouth/p/8399646.html
本文介绍了一个使用PHP开发的简易购物网站实现过程，包括用户登录、主页展示、购物车功能及订单处理等模块的设计与实现。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

一、登陆页面

封装BDDA

<?php
class DBDA{
	public $host="localhost"; //服务器地址
	public $uid="root"; //用户名
	public $pwd="123"; //密码
	public $dbname="shopping"; //数据库名称
	
	/*
		执行一条SQL语句的方法
		@param sql 要执行的SQL语句
		@param type SQL语句的类型，0代表查询 1代表增删改
		@return 如果是查询语句返回二维数组，如果是增删改返回true或false
	*/
	public function query($sql,$type=0){
		$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
		$result = $db->query($sql);
		if($type){
			return $result;
		}else{
			return $result->fetch_all();
		}
	}
	public function strquery($sql,$type=0){
		$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
		$result = $db->query($sql);
		if($type){
			return $result;
			}else{
				$arr = $result->fetch_all();
				$str = "";
				foreach($arr as $v){
					$str .= implode("^",$v)."|";
					}
				$str = substr($str,0,strlen($str)-1);
				return $str;
				}
		}
	//返回json数据的方法
	public function jsonquery($sql,$type=0){
		$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
		$result = $db->query($sql);
		if($type){
			return $result;
		}else{
			$arr = $result->fetch_all(MYSQLI_ASSOC);//关联数组
			return json_encode($arr);//转换json
			//json_decode()分解json
		}
	}
}

 

css样式表

            *{
			margin:0px auto;
			padding:0px;
			}
		#login{
			background-color:#0CF;
			width:30%;
			height:200px;
			margin-top:50px;
			border:5px double #060;
			}
		#dl{
			color:#00F;
			background-color:#9FF;
			height:30px;
			text-indent:10px;
			vertical-align:bottom;
			line-height:30px;
			}
		#pwd{
			background-color:#CFF;
			height:70px;
			}
		#sb{
			background-color:#060;
			width:200px;
			height:30px;
			color:#CFF;
			margin-top:3px;
			}

 布局样式

<body>
	<form method="post" action="dengluchuli.php">
    <div id="login">
        <div align="left" id="dl">登录页面</div><br />
        <div id="yhm" align="center">用户名：
        <input type="text" placeholder="请输入用户名" name="uid"/></div><br />
        <div id="pwd" align="center">密   码：
        <input type="password" placeholder="请输入密码" name="pwd"/></div>
        <div align="center"><input type="submit" value="登录" id="sb"/></div>
    </div>
    </form>
</body>

 

二、登录处理

<?php
session_start();
require_once "../DBDA.class.php";
$db = new DBDA();

$uid = $_POST["uid"];
$pwd = $_POST["pwd"];

$sql = "select password from login where username='{$uid}'";
$mm = $db->strquery($sql);
if(!empty($pwd) && $pwd==$mm){
	$_SESSION["uid"] = $uid;
	header("location:main.php");
}else{
	header("location:denglu.php");
}

 三、主页的css样式

　　　　　　　　　　　　　*{
			margin:0px auto;
			padding:0px;
			}
    	　　　　　　#shang{
			background-color:#0FF;
			width:100%;
			height:60px;
			vertical-align:bottom;
			line-height:90px;
			text-indent:10px;
			}
		　　#zuo{
			float:left;
			background-color:#999;
			width:30%;
			height:500px;
			}
		.caidan{
			width:80%;
			height:60px;
			background-color:#69F;
			margin-top:20px;
			text-align:center;
			vertical-align:middle;
			line-height:60px;
			font-weight:bold;
			}
		　　#yous{
			height:40px;
			width:100%;
			background-color:#FFF;
			vertical-align:bottom;
			line-height:60px;
			text-indent:10px;
			color:#009;
			font-size:20px;
			}	
		　　#you{
			background-color:#06F;
			width:70%;
			height:500px;
			float:left;
			}
		　　table{
			color:#CF0;
			text-align:center;
			}

 主页布局

<body>
<?php
	session_start();
	if(empty($_SESSION["uid"])){
		header("location:denglu.php");
		exit;
	}
?>
    <div>
    	<div id="shang"><h2>超牛逼购物网</h2></div>
        <div>
        	<div id="zuo">
            	<div class="caidan"><a href="main.php">浏览商品</a></div>
                <div class="caidan"><a href="zhanghu.php">查看账户</a></div>
                <div class="caidan"><a href="gouwuche.php">查看购物车</a></div>
            </div>
            <div id="you">
            <div id="yous">
<?php
	require_once"../DBDA.class.php";
	$db = new DBDA();
	if(!empty($_SESSION["gwc"])){
		$arr = $_SESSION["gwc"];
		$count = count($arr);//购物车中商品的数量
		$sum = 0;//商品总价
		foreach($arr as $v){
			$sql = "select price from fruit where ids ='{$v[0]}'";
			$danjia = $db->strquery($sql);
			$sum +=$danjia*$v[1];
		}
		echo "购物车中总共有{$count}种商品，总价为：{$sum}元";
	}
?>
            </div>
            <table border="1" bordercolor="#CCFFFF" width="100%">
            	<tr bgcolor="#339999" height="40">
                	<td>水果代号</td>
                    <td>水果名称</td>
                    <td>水果价格</td>
                    <td>水果产地</td>
                    <td>货架</td>
                    <td>库存量</td>
                    <td>操作</td>
                </tr>
<?php
	$sql = "select * from fruit";
	$arr = $db->query($sql);
	foreach($arr as $v){
		echo"<tr>
	<td>{$v[0]}</td>
	<td>{$v[1]}</td>
	<td>{$v[2]}</td>
	<td>{$v[3]}</td>
	<td>{$v[4]}</td>
	<td>{$v[5]}</td>
	<td><a href='tianjia.php?code={$v[0]}'><input type='button' value='添加购物车'/></a></td>
		</tr>";
	}
?>                
            </table>
            </div>
        </div>
    </div>
</body>

账号信息

<?php
	session_start();
	if(empty($_SESSION["uid"])){
		header("location:login.php");
		exit;
	}
?>
<body>
<div>
    <div id="shang"><h2>账户信息</h2></div>
    <div>
        <div id="zuo">
            <div class="caidan"><a href="main.php">浏览商品</a></div>
            <div class="caidan"><a href="zhanghu.php">查看账户</a></div>
            <div class="caidan"><a href="gouwuche.php">查看购物车</a></div>
        </div>
        <div id="you">
            <div id="yous">账户基本信息</div>
            <table border="1" bordercolor="#CCFFFF" width="100%">
            	<tr bgcolor="#339999" height="40">
                	<td>用户名</td>
                    <td>姓名</td>
                    <td>账户余额</td>
                </tr>
<?php
	$uid = $_SESSION["uid"];
	require_once "../DBDA.class.php";
	$db = new DBDA();
	$sql = "select * from login where username = '{$uid}'";
	$arr = $db->query($sql);
	foreach($arr as $v){
		echo"<tr>
			<td>{$v[0]}</td>
			<td>{$v[1]}</td>
			<td>{$v[3]}</td>
		</tr>";
	}
?>
		</table>
        </div>
    </div>
</div>
</body>

 

购物车

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
<link href="main.css" rel="stylesheet" type="text/css">
<style type="text/css">
	#st{
		background-color:#390;
		color:#FFF;
		font-size:20px;
		margin-left:450px;
		}
</style>
</head>
<?php
	session_start();
	if(empty($_SESSION["uid"])){
		header("location:login.php");
		exit;
	}
?>
<body>
	<form action="dingdantijiao.php" method="post">
	<div>
    	<div id="shang"><h2>购物车</h2></div>
        <div>
        	<div id="zuo">
            	<div class="caidan"><a href="main.php">浏览商品</a></div>
                <div class="caidan"><a href="zhanghu.php">查看账户</a></div>
                <div class="caidan"><a href="gouwuche.php">查看购物车</a></div>
            </div>
            <div id="you">
            <div id="yous">购物车有以下商品</div>
            <table border="1" bordercolor="#CCFFFF" width="100%">
            	<tr bgcolor="#339999" height="40">
                	<td>商品名称</td>
                    <td>商品单价</td>
                    <td>购买数量</td>
                    <td>操作</td>
                </tr>
<?php
	require_once "../DBDA.class.php";
	$db = new DBDA();
	$sql = "select * from ordertails";
	$arr = $_SESSION["gwc"];
	foreach($arr as $v){
		$sql = "select name,price from fruit where ids='{$v[0]}'";
		$name = $db->query($sql);
		echo "<tr>
    	<td>{$name[0][0]}</td>
		<td>{$name[0][1]}</td>
        <td>{$v[1]}</td>
        <td><a href='del.php?code={$v[0]}'><input type='button' value='删除' /></a></td>
    </tr>";
	}
?>              
            </table>
            <br>
            <a href="dingdantijiao.php?ids={$v[0]}" rel="external nofollow" id="st">提交订单</a>
            </div>
        </div>
    </div>
    </form>
    
</body>
</html>

 

删除商品处理

<?php
session_start();
$code = $_GET["code"];
$arr = $_SESSION["gwc"];
//var_dump($arr);
//取索引2（数量）
foreach ($arr as $k=>$v)
{
    if($v[0]==$code)
    {
        if($v[1]>1){
            //要删除的数据
           $arr[$k][1]-=1;
        }
        else{
            //数量为1的情况下，移除该数组
            unset($arr[$k]);
        }
    }

}

$_SESSION["gwc"] = $arr;
//记得扔到session里面
header("location:gouwuche.php");
//删除完跳转回去

 提交订单

<?php
session_start(); 
$ids = $_GET["ids"];
//查看余额
$uid = $_SESSION["uid"];
require_once "../DBDA.class.php";
$db = new DBDA();
$sql = "select account from login where username='{$uid}'";
$arr = $db->query($sql,0);
$aye = $arr[0][0];//余额
//var_dump($aye);
if(!empty($_SESSION["gwc"])){
	 $arr = $_SESSION["gwc"];
	 $sum = 0;
	 //$numbers = count($arr);
	 foreach($arr as $v){
	  $sql = "select * from fruit where ids='{$v[0]}'";
	  $price = $db->query($sql,0);
	  $dj = $price[0][2];
	  $sum = $sum+$dj*$v[1];
	 } 
}else{
 echo "您还未购买商品!";
 //header("shopping_list.php");
 exit;
}
//判断余额是否满足购买
if($aye>=$sum){
 //判断库存
	 foreach($arr as $v){
		  $skc = "select name,numbers from fruit where ids='{$v[0]}'";
		  $akc = $db->query($sql,0);
		  //var_dump($akc);
		  $kc = $akc[0][4];//库存
		  //var_dump($kc);
		   
		  if($kc<$v[1]){
		   echo "库存不足!";
		   exit;
		  }
	 }
	 //提交订单
	 //账户扣除余额
	 $skye = "update login set account=account-'{$sum}' where username='{$uid}'";
	 $zhye = $db->query($skye,1);
	  
	 //扣除库存
	 foreach($arr as $v){
		 $skckc = "update fruit set numbers=numbers-'{$v[1]}' where ids='{$v[0]}'";
		 $sykc = $db->query($skckc,1);
	 }
	 //添加订单
	 $ddh = date("Y-m-d H:i:s");
	 $time = time();
	 $stjd = "insert into orders values('{$time}','{$uid}','{$ddh}')";
	 $wcdh = $db->query($stjd,1);
	 //添加订单详情
	 foreach($arr as $v){
		  $ddxq = "insert into orderdetails values('','{$ddh}','{$v[0]}','{$v[1]}')";
		  $axq = $db->query($ddxq,1);
	 } 
}else{
 echo "余额不足,请充值!";
 exit;
}
unset($_SESSION["gwc"]);
header("location:main.php");

 

 

转载于:https://www.cnblogs.com/navyouth/p/8399646.html

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值