分页.php

最新推荐文章于 2023-02-01 09:00:21 发布

Vivian_shuang

最新推荐文章于 2023-02-01 09:00:21 发布

阅读量306

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/Vivian_shuang/article/details/52213873

版权

php 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        table{
            border:1px solid gainsboro;
        }
        th,tr,td{
            border:1px solid deeppink;
        }
    </style>

</head>
<body>
    <table>
        <th>id</th>
        <th>用户名</th>
        <th>密码</th>
        <th>电话</th>
        <?php
            require_once "initsql.php";
            define("PAGE_COUNT",5);
            if ($_GET){
                $page = @$_GET["page"];
            }else{
                $page = 0;
            }
            $start = $page * PAGE_COUNT;
            $sql = "SELECT * FROM user LIMIT {$start},5";
            $result = mysql_query($sql);
            while($row = mysql_fetch_assoc($result)){
                echo "<tr>";
                foreach ($row as $value){
                    echo "<td>";
                    echo $value;
                    echo "</td>";
                }
                echo "</tr>";
            }
        ?>
    </table>
    <?php
        $sql = "SELECT COUNT(id) FROM user";
        $result = mysql_query($sql);
        $row = mysql_fetch_row($result);
        // 总条数
        $count = $row[0];
        // 上一页
        if ($page > 0){
            $lastPage = $page - 1;
            echo "<a href='fenye2.php?page= $lastPage}'>上一页</a>";
        }
        for($i = 0; $i < ceil($count / 5); $i++){
            $showPage = $i + 1;
            echo "<a href='fenye2.php?page={$i}'>{$showPage}</a>";
        }
        // 下一页
        if ($page < ceil($count / 5) - 1){
            $nexttPage = $page + 1;
            echo "<a href='fenye2.php?page={$nexttPage}'>下一页</a>";
        }

    ?>
</body>
</html>

Vivian_shuang

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分页.php

html>html lang="en">head> meta charset="UTF-8"> meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> me
复制链接

扫一扫