容易的利用php谢了一个分页的功能模块-php教程-PHP中文网

容易的利用php谢了一个分页的功能模块

php中文网

发布： 2016-06-13 12:21:48

原创

1030人浏览过

简单的利用php谢了一个分页的功能模块

先贴张图看看效果

立即学习“PHP免费学习笔记（深入）”；

magento(麦进斗)

Magento是一套专业开源的PHP电子商务系统。Magento设计得非常灵活，具有模块化架构体系和丰富的功能。易于与第三方应用系统无缝集成。Magento开源网店系统的特点主要分以下几大类，网站管理促销和工具国际化支持SEO搜索引擎优化结账方式运输快递支付方式客户服务用户帐户目录管理目录浏览产品展示分析和报表Magento 1.6 主要包含以下新特性：•持久性购物 - 为不同的

查看详情

立即学习“PHP免费学习笔记（深入）”；

在贴一下代码吧

<?<span style="color: #000000;">php        </span><span style="color: #800080;">$localhost</span> = "localhost"<span style="color: #000000;">;    </span><span style="color: #800080;">$username</span> = "root"<span style="color: #000000;">;    </span><span style="color: #800080;">$password</span> = "root"<span style="color: #000000;">;    </span><span style="color: #800080;">$db</span> = "test";         <span style="color: #008000;">//</span><span style="color: #008000;">信息</span>        <span style="color: #800080;">$pagesize</span> = 5<span style="color: #000000;">;                                  </span><span style="color: #800080;">$conn</span> = <span style="color: #008080;">mysql_connect</span>(<span style="color: #800080;">$localhost</span>,<span style="color: #800080;">$username</span>,<span style="color: #800080;">$password</span>); <span style="color: #008000;">//</span><span style="color: #008000;">链接数据库</span>            <span style="color: #0000ff;">if</span>(!<span style="color: #800080;">$conn</span><span style="color: #000000;">){            </span><span style="color: #0000ff;">echo</span> "数据库链接失败".<span style="color: #008080;">mysql_error</span><span style="color: #000000;">();        }        </span><span style="color: #008080;">mysql_query</span>("SET NAMES 'UTF8'");    <span style="color: #008000;">//</span><span style="color: #008000;">编码转化</span>    <span style="color: #800080;">$db_select</span> = <span style="color: #008080;">mysql_select_db</span>(<span style="color: #800080;">$db</span>);  <span style="color: #008000;">//</span><span style="color: #008000;">选择表                                        //查询记录总数</span>    <span style="color: #800080;">$total_sql</span> = "select COUNT(*) from page"<span style="color: #000000;">;    </span><span style="color: #800080;">$total_result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$total_sql</span><span style="color: #000000;">);    </span><span style="color: #800080;">$total_row_arr</span> = <span style="color: #008080;">mysql_fetch_row</span>(<span style="color: #800080;">$total_result</span><span style="color: #000000;">);    </span><span style="color: #800080;">$total_row</span> = <span style="color: #800080;">$total_row_arr</span>[0];         <span style="color: #008000;">//</span><span style="color: #008000;">总条数    //总页数</span>    <span style="color: #800080;">$total</span> = <span style="color: #008080;">ceil</span>(<span style="color: #800080;">$total_row</span> / <span style="color: #800080;">$pagesize</span><span style="color: #000000;">);        </span><span style="color: #008000;">//</span><span style="color: #008000;">当前页数</span>    <span style="color: #800080;">$page</span> = @<span style="color: #800080;">$_GET</span>['p'] ? <span style="color: #800080;">$_GET</span>['p'] : 1<span style="color: #000000;">;         </span><span style="color: #008000;">//</span><span style="color: #008000;">limit 下限</span>    <span style="color: #800080;">$offset</span> = (<span style="color: #800080;">$page</span> - 1)*<span style="color: #800080;">$pagesize</span><span style="color: #000000;">;            </span><span style="color: #800080;">$sql</span> = "select * from page order by id limit {<span style="color: #800080;">$offset</span>},{<span style="color: #800080;">$pagesize</span>}"<span style="color: #000000;">;        </span><span style="color: #800080;">$result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span><span style="color: #000000;">);        </span><span style="color: #0000ff;">echo</span> "<p>PHP分页代码的小模块</p>"<span style="color: #000000;">;    </span><span style="color: #0000ff;">echo</span> "<table border=1 cellspacing=0 WIDTH=60% align=center>"<span style="color: #000000;">;    </span><span style="color: #0000ff;">echo</span> "<tr><td>ID</td><td>NAME</td></tr>"<span style="color: #000000;">;        </span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$row</span> = <span style="color: #008080;">mysql_fetch_assoc</span>(<span style="color: #800080;">$result</span><span style="color: #000000;">)){        </span><span style="color: #800080;">$id</span> = <span style="color: #800080;">$row</span>['id'<span style="color: #000000;">];        </span><span style="color: #800080;">$name</span> = <span style="color: #800080;">$row</span>['name'<span style="color: #000000;">];        </span><span style="color: #0000ff;">echo</span> "<tr><td>".<span style="color: #800080;">$id</span>."</td><td>".<span style="color: #800080;">$name</span>."</td></tr>"<span style="color: #000000;">;    }        </span><span style="color: #0000ff;">echo</span> "</table>"<span style="color: #000000;">;    </span><span style="color: #008000;">//</span><span style="color: #008000;">上一页 、下一页</span>        <span style="color: #800080;">$pageprev</span> = <span style="color: #800080;">$page</span> -1<span style="color: #000000;"> ;        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$page</span> > <span style="color: #800080;">$total</span><span style="color: #000000;">){            </span><span style="color: #800080;">$pagenext</span> = <span style="color: #800080;">$total</span><span style="color: #000000;">;        } </span><span style="color: #0000ff;">else</span><span style="color: #000000;">{            </span><span style="color: #800080;">$pagenext</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: #0000ff;">echo</span> "<h3> <a href='page.php?p={<span style="color: #800080;">$pageprev</span>}'>上一页</a> 丨<a href='page.php?p={<span style="color: #800080;">$pagenext</span>}'>下一页</a></h3>"<span style="color: #000000;">;                </span><span style="color: #008080;">mysql_free_result</span>(<span style="color: #800080;">$result</span><span style="color: #000000;">);    </span><span style="color: #008080;">mysql_close</span>(<span style="color: #800080;">$conn</span><span style="color: #000000;">);</span>?>

登录后复制

关键点： 1、$sql = "select * from page order by id limit {$offset},{$pagesize}";

　　　　 2、echo "

这两点是关键能体现分页技术和php 代码艺术的地方~

和大家一起学习吧~