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

最新推荐文章于 2021-03-19 00:46:44 发布

Tango糖果π

最新推荐文章于 2021-03-19 00:46:44 发布

阅读量1.4k

点赞数 1

分类专栏： php 文章标签： php pdo mysql 分页

本文链接：https://blog.csdn.net/mahaokun/article/details/53281720

版权

php 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

<?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>