PHP PDO MySql 分页显示用户列表index.php

本文主要是介绍PHP PDO MySql 分页显示用户列表index.php，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

<?php include "i_conn.php" ?>
<?php
$nPageSize = 1;  //每页显示数$nPage = @$_REQUEST["page"];  //当前页
if(!is_numeric($nPage)){$nPage = 0;
}
if($nPage<=0){$nPage = 1;
}$totalPages = 0; //总页数
$strSQL = "select count(*) as nTotal from Users";
$rst = $pdo->query($strSQL);
$rstInfo=$rst->fetch();
$nTotal = $rstInfo["nTotal"];  //总记录数
$totalPages = intval($nTotal/$nPageSize);
if($nTotal%$nPageSize>0){$totalPages = $totalPages + 1;
}
?>
<!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>
</head><body>
<h3>用户列表</h3>
<a href="useredit.php">添加用户</a>
<table width="100%" border="1" cellpadding="0" cellspacing="0"><tr><td>用户编号</td><td>用户名</td><td>密码</td><td>真实姓名</td><td>编辑</td></tr><?php//$strSQL = "select * from Users order by UserID desc";$strSQL = "select * from Users order by UserID desc limit ".(($nPage-1)*$nPageSize).",".$nPageSize;$rst=$pdo->query($strSQL);while($rstInfo=$rst->fetch()){?><tr><td><?php echo $rstInfo["UserID"]; ?></td><td><?php echo $rstInfo["UserName"]; ?></td><td><?php echo $rstInfo["UserPwd"]; ?></td><td><?php echo $rstInfo["RealName"]; ?></td><td><a href="useredit.php?Opt=1&UserID=<?php echo $rstInfo["UserID"]; ?>">修改</a> | <a href="userdelete.php?UserID=<?php echo $rstInfo["UserID"]; ?>">删除</a></td></tr><?php}?><tr><td colspan="5"><a href="index.php?page=1">首页</a><a href="index.php?page=<?php echo $nPage<=1?1:$nPage-1; ?>">上一页</a><a href="index.php?page=<?php echo $nPage>=$totalPages?$totalPages:$nPage+1; ?>">下一页</a><a href="index.php?page=<?php echo $totalPages; ?>">尾页</a></td></tr>
</table><?php
$rstInfo = NULL;
$rst = NULL;
$pdo = NULL;
?>
</body>
</html>