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

来源：互联网发布：c语言if condition 编辑：程序博客网时间：2024/05/16 10:23
<?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>
0 0