php mysql分頁類別(php新手入門)-php教程-PHP中文網

php mysql分頁類別(php新手入門)

WBOY

發布： 2016-07-25 09:00:54

原創

1487 人瀏覽過

複製程式碼

/***
* php mysql 分頁類
* 整理 http://bbs.it-home.org
*/
class Pagination{
private $_result;
class Pagination{ private $_count; //記錄數
private $_pageMax; //最大頁
private $_page; //當前頁
private $_url;
private $_startPage;//分頁條起碼
private $_endPage; // 分頁條止碼
private $_nextPage; //上一頁
private $_prePage; //下一頁
function __construct( $table, $pageSize, $getPage){
$this->_result = $GLOBALS['db']->query('SELECT * FROM '.$table);
$this->_count = $ GLOBALS['db']->getRecordNum();
$this->_pageMax = ceil($this->_count/$pageSize);
$this->_result = '';
if($_GET[$getPage] == '')
$this->_page = 1;
else
$this->_page= max(intval($_GET[$ getPage]), 1);
$this->_page = min($this->_page, $this->_pageMax);
$offset = ($this ->_page - 1) * $pageSize;
$sql = 'SELECT * FROM '.$table.' LIMIT '. $offset .','. $pageSize;
$this->_result = $GLOBALSALS ['db']->query($sql);
}
function getRecord(){
return $GLOBALS['db']->getRecord();
}
function getPageBar($url = '?', $barLn = 10, $style = 1){
if($style == 1){
if($barLn % 2 != 0 ){
$midder = ceil($barLn / 2);
$big_repair = $midder - 1 ;//當上面以進一法取整，則這裡為減1，反之為加1
}else{
$midder = $big_repair = $barLn / 2;
}
$sml_repair = $midder- 1;
$this->_startPage = ($this-> _page + $midder) > $this->_pageMax ? $this->_pageMax - $barLn : $this->_page - $sml_repair;
$this->_endPage = $this->_page _page + $big_repair;
}elseif($style == 2){
if($this->_page % $barLn = = 0){
$this->_startPage = $this->_page;
}else{
$this->_startPage = ($this->_page > $barLn)? $this->_page - ($this->_page % $barLn ) : 1;
}
$this->_endPage = $this->_startPage + $barLn - 1;
}
$this->_url = $url;
$this->_nextPage = $this->_page + 1;
$this->_prePage = $this->_page - 1;
$this->_startPage = max($ this->_startPage, 1);//至少從第一頁開始
$this->_endPage = min($this->_endPage, $this->_pageMax);//最多只到末頁
$this->_result = '目前是：'.$this->_page.'/'.$this->_pageMax.'頁，共'.$this->_count.'筆記錄';
if ($this->_page > 1)
$this-> _result .= '
9