<?php
//数据库:test
//表名:users(userID,useName,uerPwd);
$connect=mysql_connect("localhost","root","123456") or die("连接数据库失败");
mysql_select_db("test") or die("数据库无法使用");

$sql="select * from users";
$query=mysql_query("select * from users");
echo "数据库连接成功";
//设计每个页要显示的记录数
$pagesize=4;
//表中总的记录数
$records=mysql_num_rows($query);
//总共要用多少页
if($records%$pagesize==0)
{
$totalpages=(int)($records/$pagesize);
}
else
{
$totalpages=(int)($records/$pagesize)+1;
}
//看用户是选择了哪个页
if(isset($_GET['page']))
{
$p=(int)$_GET['page'];
}
else
{
$p=1;
}
//计算出起始记录
$start=$pagesize*($p-1);
$query2=mysql_query("select * from  users limit $start,$pagesize");
echo "<table boeder=6>";
echo "<tr><td>用户ID</td><td>用户名</td><td>密码</td></tr>";
while($row=mysql_fetch_array($query2))
{
$userid=$row['userID'];
$username=$row['userName'];
$userpwd=$row['uerPWD'];
echo "<tr>";
echo "<td>$userid</td>";
echo "<td>$username</td>";
echo "<td>$userpwd</td>";
}
echo "</table>";
if($p>1)
{
$pre_page=$p-1;
echo "<a href='?page=$pre_page'>上一页</a>";
}
if($p<$totalpages)
{
$next_page=$p+1;
echo "<a href='?page=$next_page'>下一页</a>";
}
?>