master

分支 (1)

管理

管理

master

php-fruit-mall---p
/
myOrderList.php

<!doctype html>
<html>
	<head>
		<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
		<title>订单信息管理</title>
		<link rel="stylesheet" href="css/mystyle.css" type="text/css"/>
	</head>
	<body class="shop_body">
			<?php
				include 'front-top.php';
				include 'functions.php';
				checkUserLogined();// 判断用户是否登录
			?>
			<h3>订单信息列表</h3>
			<div class="admin_search_bar">
				<form action="<?php echo $_SERVER['PHP_SELF'];?>">
					<ul>
						<li><label>商品名称</label><input type="text" class="txt" name="keyword" autocomplete="off" value="<?php if(isset($_GET['keyword'])) echo $_GET['keyword'];?>"></li>
						<li><button>搜索</button></li>
					</ul>
				</form>
			</div>
			<table border="1" style="width:100%;" class="frm_table">
				<tr>
					<th>订单编号</th>
					<th>商品名称</th>
					<th>商品图片</th>
					<th>订单金额</th>
					<th>收货地址</th>
					<th>下单时间</th>
					<th>操作</th>
				</tr>
				<?php


				//从数据库中读取信息并输出到浏览器表格中
				//1.导入配置文件
					require("dbconfig.php");

					// 当前页
					if(!isset($_GET["page"])){
						$page=1;
					}else{
						$page=$_GET["page"];
					}

					// 数据从第几行开始
					$temp=($page-1)*$front_list_num;

					// 搜索关键字
					if(!isset($_GET['keyword'])){
						$keyword = "";
					}else{
						$keyword = trim($_GET['keyword']);
					}


				//2. 连接数据库，并选择数据库


					$sql_count = "SELECT count(*) as total FROM tb_order a, `user` b, goods c WHERE a.user_id=b.id AND a.goods_id=c.id ";
					// 只能查询自己的订单
					$sql_count .= " AND a.user_id=".$_SESSION['userId'];
					if($keyword){
						$sql_count.= " and c.`name` like '%{$keyword}%'";
					}
					$result = mysql_query($sql_count);
					if($result){
						$res = mysql_fetch_array($result);
						$num = $res['total'];
					}else{
						$num = 0;
					}

					$p_count=ceil($num/$front_list_num);					//总页数为总条数除以每页显示数

				//3. 执行订单信息查询
					$sql = "SELECT a.*,b.username,c.`name` as `goods_name`,c.pic FROM tb_order a, `user` b, goods c WHERE a.user_id=b.id AND a.goods_id=c.id ";
					// 只能查询自己的订单
					$sql .= " AND a.user_id=".$_SESSION['userId'];

					if($keyword){
						$sql .=  " and c.`name` like '%{$keyword}%'";
					}
					$sql .= " limit {$temp},{$front_list_num}";
					$result = mysql_query($sql);


				//4. 解析订单信息（解析结果集）
					while($result && $row = mysql_fetch_assoc($result)){
						echo "<tr>";
						echo "<td width='40'>{$row['order_sn']}</td>";
						echo "<td width='100'>{$row['goods_name']}</td>";
						echo "<td width='60'><img src='./uploads/s_{$row['pic']}'/></td>";
						echo "<td width='60'>{$row['order_money']}</td>";
						echo "<td width='60'>{$row['consignee']}({$row['phone']},{$row['address']})</td>";
						echo "<td width='100'>".$row['createtime']."</td>";
						echo "<td width='60'>
								<a href='myOrderAction.php?action=del&id={$row['id']}' class='op_btn'>删除</a>";
						echo "</tr>";
					}


				//5. 释放结果集，关闭数据库


				?>
			</table>
			<?php
			// 分页
			if($num > 0){
				$prev_page=$page-1;						//定义上一页为该页减1
				$next_page=$page+1;						//定义下一页为该页加1
				//echo "next_page=".$next_page.",p_count=".$p_count;
				echo "<p align=\"center\"> ";
				if ($page<=1)								//如果当前页小于等于1只有显示
				{
					echo "第一页 | ";
				}
				else										//如果当前页大于1显示指向第一页的连接
				{
					echo "<a href='".$_SERVER['PHP_SELF']."?page=1&keyword={$keyword}'>第一页</a> | ";
				}
				if ($prev_page<1)							//如果上一页小于1只显示文字
				{
					echo "上一页 | ";
				}
				else										//如果大于1显示指向上一页的连接
				{
					echo "<a href='".$_SERVER['PHP_SELF']."?page=$prev_page&keyword={$keyword}'>上一页</a> | ";
				}
				if ($next_page>$p_count)						//如果下一页大于总页数只显示文字
				{
					echo "下一页 | ";
				}
				else										//如果小于总页数则显示指向下一页的连接
				{
					echo "<a href='".$_SERVER['PHP_SELF']."?page=$next_page&keyword={$keyword}' class='underline'>下一页</a> | ";
				}
				if ($page>=$p_count)						//如果当前页大于或者等于总页数只显示文字
				{
					echo "最后一页</p>\n";
				}
				else										//如果当前页小于总页数显示最后页的连接
				{
					echo "<a href='".$_SERVER['PHP_SELF']."?page=$p_count&keyword={$keyword}'>最后一页</a></p>\n";
				}
			}else{
				echo "<P align='center'>暂时还没有记录！</p>";
			}
			?>
	</body>
</html>