关于分页的问题 - JBTALKS.CC

<?php session_start(); ?>
<?php
//建立连接数据库
$link=mysql_connect("localhost","root","") or die("you could notconnect mysql");
//连接的数据库名称
mysql_select_db("databasename") or die("could not select database!");
//取得记录总数
$query="SELECT count(*) FROM member order by mem_name asc";
$rs = mysql_query($query);
$rows=mysql_fetch_array($rs);
$numrows=$rows[0];
//设定每一页显示的记录数
$pagesize = 4;
//计算总页数
$pages=intval($numrows/$pagesize);
if($numrows%$pagesize)
$pages++;
//设置页数
if(isset($_POST['page']))
$page=intval($_POST['page']);
else{
$page = 1; //没有页数则显示第一页；
}
//计算记录偏移量
$offset = ($page-1)*$pagesize;
//读取指定的记录数
$query1="select * from member order by mem_name asc limit $offset,$pagesize";
$rs = mysql_query($query1);
?>
<!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>Admin Control Panel-会员中心</title>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script src="Scripts/checkAdminProfile.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
</head>
<body>
<ul id="MenuBar1" class="MenuBarHorizontal">
<li><a class="MenuBarItemSubmenu" href="adminControl.php">主页</a>
<ul>
<li><a href="adminProfile.php">个人中心</a></li>
<li><a href="#">增新活动</a></li>
<li><a href="#">增新图片</a></li>
<li><a href="#">更新关于我们</a></li>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu">员工中心</a>
<ul>
<li><a href="girl_list.php">员工资料</a></li>
<li><a href="#">更新介绍</a></li>
<li><a href="#">添新部落格</a></li>
</ul>
</li>
<li><a href="member_list.php">会员中心</a> </li>
<li><a href="phpPages/logout.php">登出</a></li>
</ul>
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
<table width="100%" border="0" cellpadding="5" cellspacing="2" class="tableBorder" id="datagridUser">
<thead>
<tr class="tableheader">
<td colspan="7"><b>会员中心</b></td>
</tr>
</thead>
<tbody>
<tr class="altRowColor2">
<td align="left"><strong>中文名</strong></td>
<td align="left"><strong>邮件</strong></td>
<td align="left"><strong>地址</strong></td>
<td align="left"><strong>电话</strong></td>
<td align="left"><strong>查看资料</strong></td>
</tr>
<?php
if($rows=mysql_fetch_array($rs))
{
$i = 0;
do{
$i++;
?>
<tr class="altRowColor1">
<td align="left"><?php echo $rows['mem_name']; ?></td>
<td align="left"><?php echo $rows['mem_email']; ?></td>
<td align="left"><?php echo $rows['mem_add']; ?></td>
<td align="left"><?php echo $rows['mem_tel']; ?></td>
<input name="id" type="hidden" id="id" value="<?php echo $rows['id']; ?>">
<td align="left"><a href="memProfile.php?id=<?php echo $rows['mem_id']; ?>">View</a></td>
</tr>
<?php
}
while($rows=mysql_fetch_array($rs));
echo " </tbody>";
echo " <tfoot>";
echo "</tfoot>";
echo "</table>";
}
$first = 1;
$prev =$page-1;
$next = $page+1;
$last=$pages;
if($page>1)
{
echo "<a href='member_list.php?page=".$first."'>首页 |</a>";
echo "<a href='member_list.php?page=".$prev."'> 上一页 |</a>";
}
if($page<$pages)
{
echo "<a href='member_list.php?page=".$next."'> 下一页 |</a>";
echo "<a href='member_list.php?page=".$last."'> 最后一页</a>";
}
echo "<div align = 'center'>共有" .$pages. "页(" .$page. "/" .$pages.")";
for($i=1; $i<$page; $i++)
echo "<a href='member_list.php?page=".$i."'>[".$i."]</a>";
echo "[" .$page. "]";
for($i=$page+1; $i<=$pages;$i++)
echo "<a href='member_list.php?page=".$i."'>[".$i."]</a>";
echo"</div>";
?>
</body>
</html>
<?php
mysql_close();
?>

复制代码