php--分页显示记录

最新推荐文章于 2021-03-10 07:54:21 发布

虾米大王

最新推荐文章于 2021-03-10 07:54:21 发布

阅读量314

点赞数

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

本文链接：https://blog.csdn.net/modern358/article/details/90175979

版权

php 专栏收录该内容

177 篇文章 19 订阅

订阅专栏

<html>
<head>
    <title>分页显示记录</title>
</head>
<body>
    <?php
        $page_index = $_GET['page_index'];
        if($page_index == 0)
        {
            $page_index = 1;
        }

        $page_size = 2;

        $conn = mysqli_connect('localhost','root','','t2');
        if(empty($conn))
        {
            die("数据库连接失败！".mysqli_connect_error()."<br>");
        }

        $sql = 'select count(*) from student';
        $results = mysqli_query($conn,$sql);
        $row = $results->fetch_row();
        $record_count = $row[0];

        if($record_count)
        {
            if($record_count < $page_size)
            {
                $page_count = 1;
            }

            if($record_count % $page_size == 0)
            {
                $page_count = $record_count / $page_size;
            }
            else
            {
                $page_count = (int)($record_count/$page_size) + 1;
            }


        }
        else
        {
            $page_count = 0;
        }

        mysqli_query($conn,'set names utf8');
        echo "<br> 当前页面：".$page_index."/".$page_count;
        echo "<table width='400' border='1'>";
        echo "<tr><td>学号</td><td>姓名</td></tr>";
        $sql1 = "select * from student limit ".($page_index - 1) * $page_size.",".$page_size;
        $results = mysqli_query($conn,$sql1);
        while($row = $results->fetch_row())
        {
            echo "<tr>";
            echo "<td>".$row[0]."</td>";
            echo "<td>".$row[1]."</td>";
            echo "</tr>";
        }
        echo "</table>";

        mysqli_close($conn);

        if($page_index == 1)
        {
            echo "<a href='13.php?page_index=1'>首页</a>";
        }
        else
        {
            echo "首页";
        }
        echo "&nbsp;&nbsp;&nbsp;&nbsp;";
        if($page_index >= 2)
        {
            echo "<a href='13.php?page_index=".($page_index - 1)."'>上一页</a>";
        }
        else
        {
            echo "上一页";
        }
        echo "&nbsp;&nbsp;&nbsp;&nbsp;";
        if($page_index < $page_count)
        {
            echo "<a href='13.php?page_index=".($page_index + 1)."'>下一页</a>";
        }
        else
        {
            echo "下一页";
        }
        echo "&nbsp;&nbsp;&nbsp;&nbsp;";
        if($page_index == $page_count)
        {
            echo "<a href='13.php?page_index=".($page_count)."'>尾页</a>";
        }
        else
        {
            echo "尾页";
        }

    ?>
</body>
</html>

数据库

虾米大王

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
php--分页显示记录

<html><head> <title>分页显示记录</title></head><body> <?php $page_index = $_GET['page_index']; if($page_index == 0) { $...
复制链接

扫一扫