php--分页显示记录-白红宇的个人博客

php--分页显示记录

发布日期：2021-05-06 21:18:38 浏览次数：36 分类：原创文章

本文共 2366 字，大约阅读时间需要 7 分钟。

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

数据库

上一篇：php--如何创建画布

下一篇：PHP脚本程序的工作流程

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章