📄 show.php
字号:
<!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=gb2312" />
<title>显示页面</title>
<style type="text/css">
<!--
.STYLE2 {color: #5E5E5E}
-->
</style>
<style type="text/css">
a:link{cursor: hand; font-size: 11pt ; color: #3C3C3C; }
a:active{ cursor: hand; font-size: 11pt ;color: 333399; }
a:hover{ cursor: hand; font-size: 11pt ; color:#3300FF; background:#666699;}
a:visited{ cursor: hand; font-size: 11pt ;color: #000000; text-decoration:none }
.STYLE3 {color: #6666CC}
</style>
</head>
<body text="#5E5E5E">
<div align="center">
<?
include("head.inc");
if(!$_GET[page]) $page=1;
else $page=$_GET[page];
//include("isload.inc");
if(empty($_COOKIE["test"])) //没记录验证有无登陆！
{?>
<span class="STYLE3"> 请先登陆........</span></div>
<META HTTP-EQUIV=Refresh CONTENT="0; URL=index.php">;
<?
}
require('db_start.inc');
$sql="SELECT * FROM web_user ORDER BY `id` DESC ";//sql语句
$result = mysql_query($sql);
$num=mysql_num_rows($result);
$list_num=5; //每页条数
$count_num=ceil($num/$list_num);//页数
?>
<div align="center"><a href="index.php">主页 </a>|<a href="find.php">查询</a> <? if($_COOKIE[test]==jixian) {?>|<a href="register.php">插入</a><? }?>|<a href="end.php">注销</a>
</br></br>
<? echo "总条数:".$num;echo "页数:".$count_num; ?></div>
<table width="800" border="1" align="center" cellspacing="0" >
<tr bgcolor="#E7E7E7" >
<td width="70" ><div align="center" class="STYLE2">姓名</div></td>
<td width="100"> <div align="center" class="STYLE2"><span class="STYLE2">生日</span></div></td>
<td width="100"> <div align="center" class="STYLE2">电话</div></td>
<td width="170"><div align="center" class="STYLE2">身份证</div></td>
<td width="170"> <div align="center" class="STYLE2">兴趣</div></td>
<td width="150"> <div align="center" class="STYLE2">住址</div></td>
<td width="40"><div align="center" class="STYLE2">其他 </div> </td>
</tr>
<tr>
<td colspan="7" height="3"></td>
</tr>
<?
$offset=($page-1)*$list_num;//起始位
$sql1="SELECT * FROM `web_user` ORDER BY `id` ASC LIMIT $offset , $list_num";
$result1=mysql_query($sql1);
while($row=mysql_fetch_row($result1))//返回结果
{ //print_r($row);
?>
<tr bgcolor="#EFEFEF" height="25" >
<td width="70" ><div align="center"><span class="STYLE2"><a href="detial.php?id=<? echo $row[0];?>"><? echo $row[2];?></a></span></div></td>
<td width="100"> <div align="center"><span class="STYLE2"><? echo $row[4]."/".$row[5]."/".$row[6];?></span></div></td>
<td width="100"> <div align="center"><span class="STYLE2"><? echo $row[8];?></span></div></td>
<td width="170"><div align="center"><span class="STYLE2"><? echo $row[11];?></span></div></td>
<td width="170"> <div align="center"><span class="STYLE2"><? echo $row[7];?></span></div></td>
<td width="150"> <div align="center"><span class="STYLE2"><? echo $row[12];?></span></div></td>
<td width="40">
<form id="form1" name="form1" method="post" action=" delete.php">
<input type="checkbox" name="test[]" value="<? echo $row[0];?>" />
</td>
</tr>
<tr>
<td colspan="7" height="3"></td>
</tr>
<?
}
?>
</table>
<?
if($_COOKIE[test]==jixian)
{
?>
<div align="center"><input type="submit" name="delete" value="删除" /></div>
<?
}
?>
</form>
<div align="center">
<?
if($num)
{
// echo "<div align="."center".">";
if($page==1)
{
echo "首页| ";
echo "上一页| ";
}
if($page!=1)
{
echo "<a href=show.php?page=1".">首页| </a>";
echo "<a href=show.php?page=".($page-1).">上一页|   </a>";
}
if($page<$count_num)
{
echo"<a href=show.php?page=".($page+1).">下一页| </a>";
echo"<a href=show.php?page=".$count_num.">尾页</a>";
}
if($page==$count_num)
{
echo "下一页| ";
echo "尾页";
}
//echo "</div>";
}//$num==0;
else
{
echo "没有记录！";
}
?>
</div>
</br>
</br>
<? include("copyright.inc");?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -