发表时间:2014-09-05来源:网络
首先一个分页类,如下(摘自网络)可拷贝直接使用
each_disNums = intval($each_disNums); $this->nums = intval($nums); if (!$current_page) { $this->current_page = 1; } else { $this->current_page = intval($current_page); } $this->sub_pages = intval($sub_pages); $this->pageNums = ceil($nums / $each_disNums); $this->subPage_link = $subPage_link; $this->show_SubPages($subPage_type); //echo $this->pageNums."--".$this->sub_pages; } /* __destruct析构函数,当类不在使用的时候调用,该函数用来释放资源。 */ function __destruct() { unset ($each_disNums); unset ($nums); unset ($current_page); unset ($sub_pages); unset ($pageNums); unset ($page_array); unset ($subPage_link); unset ($subPage_type); } /* show_SubPages函数用在构造函数里面。而且用来判断显示什么样子的分页 */ function show_SubPages($subPage_type) { if ($subPage_type == 1) { $this->subPageCss1(); } elseif ($subPage_type == 2) { $this->subPageCss2(); } } /* 用来给建立分页的数组初始化的函数。 */ function initArray() { for ($i = 0; $i sub_pages; $i++) { $this->page_array[$i] = $i; } return $this->page_array; } /* construct_num_Page该函数使用来构造显示的条目 即使:[1][2][3][4][5][6][7][8][9][10] */ function construct_num_Page() { if ($this->pageNums sub_pages) { $current_array = array (); for ($i = 0; $i pageNums; $i++) { $current_array[$i] = $i +1; } } else { $current_array = $this->initArray(); if ($this->current_page current_page pageNums && $this->current_page > $this->pageNums - $this->sub_pages + 1) { for ($i = 0; $i pageNums) - ($this->sub_pages) + 1 + $i; } } else { for ($i = 0; $i current_page - 2 + $i; } } } return $current_array; } /* 构造普通模式的分页 共4523条记录,每页显示10条,当前第1/453页 [首页] [上页] [下页] [尾页] */ function subPageCss1() { $subPageCss1Str = ""; $subPageCss1Str .= "共" . $this->nums . "条记录,"; $subPageCss1Str .= "每页显示" . $this->each_disNums . "条,"; $subPageCss1Str .= "当前第" . $this->current_page . "/" . $this->pageNums . "页 "; if ($this->current_page > 1) { http://blog.csdn.net/tangcheng_ok/article/details/$firstPageUrl = $this->subPage_link . "1"; http://blog.csdn.net/tangcheng_ok/article/details/$prewPageUrl = $this->subPage_link . ($this->current_page - 1); $subPageCss1Str .= "[首页] "; $subPageCss1Str .= "[上一页] "; } else { $subPageCss1Str .= "[首页] "; $subPageCss1Str .= "[上一页] "; } if ($this->current_page pageNums) { http://blog.csdn.net/tangcheng_ok/article/details/$lastPageUrl = $this->subPage_link . $this->pageNums; http://blog.csdn.net/tangcheng_ok/article/details/$nextPageUrl = $this->subPage_link . ($this->current_page + 1); $subPageCss1Str .= " [下一页] "; $subPageCss1Str .= "[尾页] "; } else { $subPageCss1Str .= "[下一页] "; $subPageCss1Str .= "[尾页] "; } echo $subPageCss1Str; } /* 构造经典模式的分页 当前第1/453页 [首页] [上页] 1 2 3 4 5 6 7 8 9 10 [下页] [尾页] */ function subPageCss2() { $subPageCss2Str = ""; $subPageCss2Str .= "当前第" . $this->current_page . "/" . $this->pageNums . "页 "; if ($this->current_page > 1) { http://blog.csdn.net/tangcheng_ok/article/details/$firstPageUrl = $this->subPage_link . "1"; http://blog.csdn.net/tangcheng_ok/article/details/$prewPageUrl = $this->subPage_link . ($this->current_page - 1); $subPageCss2Str .= " 首页 "; $subPageCss2Str .= " 上一页 "; } else { $subPageCss2Str .= " 首页 "; $subPageCss2Str .= " 上一页 "; } $a = $this->construct_num_Page(); for ($i = 0; $i current_page) { $subPageCss2Str .= " " . $s . " "; } else { http://blog.csdn.net/tangcheng_ok/article/details/$url = $this->subPage_link . $s; $subPageCss2Str .= " " . $s . " "; } } if ($this->current_page pageNums) { http://blog.csdn.net/tangcheng_ok/article/details/$lastPageUrl = $this->subPage_link . $this->pageNums; http://blog.csdn.net/tangcheng_ok/article/details/$nextPageUrl = $this->subPage_link . ($this->current_page + 1); $subPageCss2Str .= " 下一页 "; $subPageCss2Str .= " 尾页 "; } else { $subPageCss2Str .= " 下一页 "; $subPageCss2Str .= " 尾页 "; } echo $subPageCss2Str; }}?>
在需要分页的php文件中
include_once ("Pagination.php");//每页显示的条数$pageSize = 10;//总条目数$pageTotal = $db->get_var("select count(*) from tb");//每次显示的页数$sub_pages = 10;//得到当前是第几页if (is_array($_GET) && count($_GET) > 0) { if (isset ($_GET["p"])) { //是否存在"id"的参数 $pageCurrent = $_GET["p"]; }} else { $pageCurrent = 1;}$goodses = $db->get_results("SELECT g.id,* FROM tb as g INNER JOIN (select id from tb order by updatetime desc limit " . ($pageCurrent -1) * $pageSize . ",10 )as g1 ON g.id=g1.id");
显示分页数据
注:本文的Pagination类来自网络,没有标注网址,在原代码的基础上进行了修改,如果涉及任何问题,请留言。在此感谢作者,并作出上述声明。
转载请注明出处:http://blog.csdn.net/tangcheng_ok
上一篇:php页面静态化之真静态
下一篇:php如何同时连接多个数据库
CI框架连接数据库配置操作以及多数据库操作
asp 简单读取数据表并列出来 ASP如何快速从数据库读取大量数据
C语言关键字及其解释介绍 C语言32个关键字详解
C语言中sizeof是什么意思 c语言里sizeof怎样用法详解
最简单的asp登陆界面代码 asp登陆界面源代码详细介绍
PHP中的魔术方法 :__construct, __destruct , __call, __callStatic,__get, __set, __isset, __unset , __sleep,
PHP中include和require区别之我见
PHP中的(++i)前缀自增 和 (i++)后缀自增
将视频设置为Android手机开机动画的教程
php递归返回值的问题
掌上小满app(又名OKKI)下载v6.24.2 安卓版
108.1M |商务办公
星巴克中国官方版app下载v10.9.3 安卓版
138.0M |生活服务
abc reading app手机版下载v7.3.35 安卓最新版本
218.9M |学习教育
智慧联想摄像头app(更名智享家)下载v4.1.6.2 安卓最新版本
211.4M |生活服务
星通货主app下载v902 安卓版
142.5M |生活服务
火花思维官方版下载v2.1.1 安卓手机版
208.6M |学习教育
火山小视频极速版2025(改名抖音火山版)下载v33.4.0 安卓官方正版
248.5M |影音播放
泰州通app下载v2.2.2 安卓版
126.9M |商务办公
2014-09-05
2022-03-17
2014-09-05
2014-09-05
2015-07-05
2022-03-21
2014-09-05
2014-09-05
2014-09-05
2022-03-20