简易分页类
来源:互联网 发布:java字符串转换成json 编辑:程序博客网 时间:2024/05/17 09:04
<?phpclass Paging { public static $count = 0; public static $size = 0; public static $page = 0; static function prepare($sql, $pagesize=10) { $page = isset($_GET['page']) ? $_GET['page'] : 1; $pageon = ($page - 1) * $pagesize; $sql = preg_replace('/select\s/i', '$0SQL_CALC_FOUND_ROWS ', $sql) . " limit $pageon, $pagesize"; $rs = mysql_query($sql); $p = mysql_query('SELECT FOUND_ROWS()'); list(self::$count) = mysql_fetch_row($p); self::$size = $pagesize; self::$page = $page; return $rs; } static function bar($tpl='') { if(!$tpl) $tpl = '<a href=?reset>首页</a> <a href=?prve>上一页</a> <a href=?next>下一页</a> <a href=?end>尾页</a>'; $count = ceil(self::$count / self::$size); $page = self::$page; unset($_GET['page']); $d = array( 'reset' => 1, 'prve' => $page > 1 ? $page - 1 : 1, 'next' => $page < $count ? $page + 1 : $count, 'end' => $count, ); foreach($d as $k=>$v) { $_GET['page'] = $v; $tpl = str_replace($k, http_build_query($_GET), $tpl); } echo $tpl; }}通常你都有类似这样的语句
$sql =".....";
$rs = mysql_query($sql);
或
$rs = mysql_query("select ....");
你只需改作
include 'paging.php';
$rs = paging::prepare($sql, 每页行数);
在需要出现分页条的地方写入
paging::bar();
就可以了,非常简单!
换一种调用写法,可能感觉要好些
- PHP code
- include 'paging.php';$rs = mysql_paging_query($sql, 20);//替代 mysql_querymysql_paging_bar();//显示分页条
- PHP code
- class Paging { private static $_Instance; private function __clone(){} public static function getInstance() { if(empty(self::$_Instance)) self::$_Instance = new self(); return self::$_Instance; } protected $count = 0; protected $size = 0; protected $page = 0; function prepare($sql, $pagesize=10) { $page = isset($_GET['page']) ? $_GET['page'] : 1; $pageon = ($page - 1) * $pagesize; $sql = preg_replace('/select\s/i', '$0SQL_CALC_FOUND_ROWS ', $sql) . " limit $pageon, $pagesize"; $rs = mysql_query($sql); $p = mysql_query('SELECT FOUND_ROWS()'); list($this->count) = mysql_fetch_row($p); $this->size = $pagesize; $this->page = $page; return $rs; } function bar($tpl='') { if(!$tpl) $tpl = '共{count}页 第{page}页 <a href=?{reset}>首页</a> <a href=?{prve}>上一页</a> <a href=?{next}>下一页</a> <a href=?{end}>尾页</a>'; $count = ceil($this->count / $this->size); $page = $this->page; $d = array( '{reset}' => 1, '{prve}' => $page > 1 ? $page - 1 : 1, '{next}' => $page < $count ? $page + 1 : $count, '{end}' => $count, '{count}' => $count, '{page}' => $page, ); foreach($d as $k=>&$v) { if(in_array($k, array('{reset}', '{prve}', '{next}', '{end}'))) { $_GET['page'] = $v; $v = http_build_query($_GET); } } echo strtr($tpl, $d); }}function mysql_paging_query($sql, $num=10) { return Paging::getInstance()->prepare($sql, $num);}function mysql_paging_bar($tpl='') { return Paging::getInstance()->bar($tpl);}
- 简易分页类
- 简易 PHP+MySQL 分页类
- 一个较简易的分页javascript类
- 一个较简易的分页javascript类
- 自己写的简易分页类
- PHP实现一个简易的分页类
- 简易购物车---分页
- 简易jQuery分页代码.
- php 简易分页代码
- 简易前端分页组件
- 简易前端分页
- jquery 简易分页
- 简易分页组件
- jquery简易分页组件
- 简易xml数据岛分页
- Pager_taglib标签实现简易分页
- Tutorial: Grid组件的简易分页
- Oracle 简易的分页存储过程
- Sql Server 2008 之 Merge
- 七夕夜、离别,涵情经河岸
- ORA-12514 TNS 监听程序当前无法识别连接描述符中请求的服务
- 如何操作Excel模板,往Excel模板中写入数据
- android 之button 屏幕翻转
- 简易分页类
- About Memory leak
- How can selenium web driver get to know when the new window has opened and then resume its execution
- 转 IT管理者必须了解且规避的12大技术陷阱
- MFC之对话框
- 那年,那场青春繁华梦
- 安装好Windows 8后必做的几件事情,让你的Win8跑的更快更流畅。
- Shell赋值
- Extjs添加悬浮框