日期:2014-05-17 浏览次数:20438 次
<?php
class paging {
public static $count = 0;
public static $size = 0;
public static $page = 0;
static function prepare($sql, $pagesize='')
{ $pagesize=constant("page_size");
$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=10;
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 / constant("page_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);
}
return $tpl."当前第".$page."页|共".$count."页";
}
}
/*
把
$sql =".....";
$rs = mysql_query($sql);
或
$rs = mysql_query("select ....");
之类的
改作
include 'paging.php';
$rs = paging::prepare($sql, 每页行数);
在需要出现分页条的地方写入
paging::bar();
就可以了
*/
?>
class paging {
//增加一个方法,用于在静态调用的方法间传递数据
function para($na) {
static $ar;
if(func_num_args() == 1) return $ar[$na];
$ar[$na] = func_get_arg(1);
}
function prepare($sql, $pagesize='') {
$pagesize=constant("page_size");
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$pageon =