php分页代码-php手册-PHP中文网

php分页代码

php中文网

发布： 2016-06-14 00:02:37

原创

1473人浏览过

今天在bt5中一不小心发现了自己实习时，看php写的一个php分页代码。没啥看点，看了跟网上他们写的也没啥不同。

贴出来也给跟我一样的菜鸟瞅瞅吧。我这php算是速成产品，当时写个这分页，也出现不少问题。不过问题出现的多，才能学到东西，哈哈·····喜欢问题···

我的数据库就两个字段一个id，一个doc，id还是自增字段。

代码小浣熊

代码小浣熊是基于商汤大语言模型的软件智能研发助手，覆盖软件需求分析、架构设计、代码编写、软件测试等环节

查看详情

<html>
<head>
<title><span style="color: #000000;">
ShowData
</span></title>
</head>
<body>
<h2>ShowData</h2>
<?<span style="color: #000000;">php
    </span><span style="color: #008000;">//</span><span style="color: #008000;">连接数据库    </span>
    <span style="color: #800080;">$page</span> = 1<span style="color: #000000;">;
        </span><span style="color: #800080;">$db</span> = <span style="color: #008080;">mysql_connect</span>('127.0.0.1','root','toor'<span style="color: #000000;">);
        </span><span style="color: #008080;">mysql_select_db</span>('test',<span style="color: #800080;">$db</span><span style="color: #000000;">);
    
        </span><span style="color: #800080;">$pagesize</span> = 3;    <span style="color: #008000;">//</span><span style="color: #008000;">每页显示到数量
    
    //计算一共有多少记录，用于计算页数</span>
    <span style="color: #800080;">$rs</span> = <span style="color: #008080;">mysql_query</span>("select count(*) from info",<span style="color: #800080;">$db</span><span style="color: #000000;">);
    </span><span style="color: #800080;">$row</span> = @<span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$rs</span><span style="color: #000000;">);
    </span><span style="color: #800080;">$numrows</span> = <span style="color: #800080;">$row</span>[0<span style="color: #000000;">];

    </span><span style="color: #008000;">//</span><span style="color: #008000;">计算页数</span>
    <span style="color: #800080;">$pages</span> = <span style="color: #008080;">intval</span>(<span style="color: #800080;">$numrows</span> / <span style="color: #800080;">$pagesize</span><span style="color: #000000;">);
    </span><span style="color: #0000ff;">if</span> (<span style="color: #800080;">$numrows</span> % <span style="color: #800080;">$pagesize</span><span style="color: #000000;">)
    {
        </span><span style="color: #800080;">$pages</span>++<span style="color: #000000;">;
    }

    </span><span style="color: #008000;">//</span><span style="color: #008000;">设置页数</span>
    <span style="color: #0000ff;">if</span> (<span style="color: #0000ff;">isset</span>(<span style="color: #800080;">$_GET</span>['page'<span style="color: #000000;">]))
    {    
        </span><span style="color: #800080;">$page</span> = <span style="color: #008080;">intval</span>(<span style="color: #800080;">$_GET</span>['page'<span style="color: #000000;">]);
    }
    </span><span style="color: #0000ff;">else</span><span style="color: #000000;">
    {
        </span><span style="color: #800080;">$page</span> = 1;        <span style="color: #008000;">//</span><span style="color: #008000;">其他情况，都指向第一页</span>
<span style="color: #000000;">    }
    
    </span><span style="color: #008000;">//</span><span style="color: #008000;">计算记录的偏移量</span>
    <span style="color: #800080;">$offset</span> = <span style="color: #800080;">$pagesize</span> * (<span style="color: #800080;">$page</span> - 1<span style="color: #000000;">);

    </span><span style="color: #008000;">//</span><span style="color: #008000;">读取指定记录</span>
    <span style="color: #800080;">$rs</span> = <span style="color: #008080;">mysql_query</span>("select * from info order by id limit <span style="color: #800080;">$offset</span>,<span style="color: #800080;">$pagesize</span>",<span style="color: #800080;">$db</span><span style="color: #000000;">);

    </span><span style="color: #008000;">//</span><span style="color: #008000;">把数据用表格显示出来</span>
    <span style="color: #0000ff;">if</span> (<span style="color: #800080;">$row</span> = @<span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$rs</span><span style="color: #000000;">))
    {
        </span><span style="color: #800080;">$i</span> = 0<span style="color: #000000;">;
        </span>?>
        <table border='0' width='80%'>
        <tr>
        <td width='50%'>
        <p align='center'>ID</td>
        <td width='50%'>
        <p align='center'>DOC</td>
        </tr>
        <?<span style="color: #000000;">php
            </span><span style="color: #0000ff;">do</span><span style="color: #000000;">{
                </span><span style="color: #800080;">$i</span>++<span style="color: #000000;">;
        </span>?>
        <tr align='center'>
        <td width='50%'><?=<span style="color: #800080;">$row</span>['id']?></td>
        <td width='50%'><?=<span style="color: #800080;">$row</span>['doc']?></td>
        </tr>
        <?<span style="color: #000000;">php
            }
            </span><span style="color: #008000;">//</span><span style="color: #008000;">循环显示数据</span>
            <span style="color: #0000ff;">while</span> (<span style="color: #800080;">$row</span> = <span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$rs</span><span style="color: #000000;">));
            </span><span style="color: #0000ff;">echo</span> "</table>"<span style="color: #000000;">;
    }
    </span><span style="color: #0000ff;">echo</span> "<div align='center'> 共".<span style="color: #800080;">$pages</span>."页(".<span style="color: #800080;">$page</span>."/".<span style="color: #800080;">$pages</span>.")"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">for</span> (<span style="color: #800080;">$i</span> = 1;<span style="color: #800080;">$i</span> < <span style="color: #800080;">$page</span>;<span style="color: #800080;">$i</span>++<span style="color: #000000;">)
    {
        </span><span style="color: #0000ff;">echo</span> "$i</span>."'>[".<span style="color: #800080;">$i</span>."]"<span style="color: #000000;">;
    }
    </span><span style="color: #0000ff;">echo</span> "[".<span style="color: #800080;">$page</span>."]"<span style="color: #000000;">;
    </span><span style="color: #0000ff;">for</span> (<span style="color: #800080;">$i</span> = <span style="color: #800080;">$page</span> + 1;<span style="color: #800080;">$i</span> <= <span style="color: #800080;">$pages</span>;<span style="color: #800080;">$i</span>++<span style="color: #000000;">)
    {
        </span><span style="color: #0000ff;">echo</span> "$i</span>."'>[".<span style="color: #800080;">$i</span>."]"<span style="color: #000000;">;
    }
    </span><span style="color: #0000ff;">echo</span> "</div>"<span style="color: #000000;">;

    </span>?>

</body>
</html>

登录后复制