分享:一例PHP翻頁(分頁)類的執行個體代碼

/** * filename: ext_page.class.php * @package:phpbean * descrīption:超強分頁類，四種分頁模式，預設採用類似baidu,google的分頁風格。 * 2.0增加功能：支援自訂風格，自訂樣式，同時支援PHP4和PHP5, * example: * 模式四種分頁模式： require_once('../libs/classes/page.class.php'); $page=new page(array('total'=>1000,'perpage'=>20)); echo 'mode:1 '.$page->show(); echo 'mode:2 '.$page->show(2); echo 'mode:3 '.$page->show(3); echo 'mode:4 '.$page->show(4); 開啟AJAX： $ajaxpage=new page(array('total'=>1000,'perpage'=>20,'ajax'=>'ajax_page','page_name'=>'test')); echo 'mode:1 '.$ajaxpage->show(); 採用繼承自訂分頁顯示模式。 編輯整理：指令碼學堂 http://bbs.it-home.org */ class _page { /** * config ,public */ var $page_name="PB_page";//page標籤，用來控制url頁。比如說xxx.php?PB_page=2中的PB_page var $next_page='>';//下一頁 var $pre_page='<';//上一頁 var $first_page='First';//首頁 var $last_page='Last';//尾頁 var $pre_bar='<<';//上一分頁條 var $next_bar='>>';//下一分頁條 var $format_left='['; var $format_right=']'; var $is_ajax=false;//是否支援AJAX分頁模式 /** * private * */ var $pagebarnum=10;//控制記錄條的個數。 var $totalpage=0;//總頁數 var $ajax_action_name='';//AJAX動作名 var $nowindex=1;//當前頁 var $url="";//url地址頭 var $offset=0; /** * constructor建構函式 * * @param array $array['total'],$array['perpage'],$array['nowindex'],$array['url'],$array['ajax']... */ function page($array) { if(is_array($array)){ if(!array_key_exists('total',$array))$this->error(__FUNCTION__,'need a param of total'); $total=intval($array['total']); $perpage=(array_key_exists('perpage',$array))?intval($array['perpage']):10; $nowindex=(array_key_exists('nowindex',$array))?intval($array['nowindex']):''; $url=(array_key_exists('url',$array))?$array['url']:''; }else{ $total=$array; $perpage=10; $nowindex=''; $url=''; } if((!is_int($total))||($total<0))$this->error(__FUNCTION__,$total.' is not a positive integer!'); if((!is_int($perpage))||($perpage<=0))$this->error(__FUNCTION__,$perpage.' is not a positive integer!'); if(!empty($array['page_name']))$this->set('page_name',$array['page_name']);//設定pagename $this->_set_nowindex($nowindex);//設定當前頁 $this->_set_url($url);//設定連結地址 $this->totalpage=ceil($total/$perpage); $this->offset=($this->nowindex-1)*$perpage; if(!empty($array['ajax']))$this->open_ajax($array['ajax']);//開啟AJAX模式 } /** * 設定類中指定變數名的值，如果改變數不屬於這個類，將throw一個exception * * @param string $var * @param string $value */ function set($var,$value) { if(in_array($var,get_object_vars($this))) $this->$var=$value; else { $this->error(__FUNCTION__,$var." does not belong to PB_Page!"); } } /** * 開啟倒AJAX模式 * * @param string $action 預設ajax觸發的動作。 */ function open_ajax($action) { $this->is_ajax=true; $this->ajax_action_name=$action; } /** * 擷取顯示"下一頁"的代碼 * * @param string $style * @return string */ function next_page($style='') { if($this->nowindex<$this->totalpage){ return $this->_get_link($this->_get_url($this->nowindex+1),$this->next_page,$style); } return ''.$this->next_page.''; } /** * 擷取顯示“上一頁”的代碼 * * @param string $style * @return string */ function pre_page($style='') { if($this->nowindex>1){ return $this->_get_link($this->_get_url($this->nowindex-1),$this->pre_page,$style); } return ''.$this->pre_page.''; } /** * 擷取顯示“首頁”的代碼 * * @return string */ function first_page($style='') { if($this->nowindex==1){ return ''.$this->first_page.''; } return $this->_get_link($this->_get_url(1),$this->first_page,$style); } /** * 擷取顯示“尾頁”的代碼 * * @return string */ function last_page($style='') { if($this->nowindex==$this->totalpage){ return ''.$this->last_page.''; } return $this->_get_link($this->_get_url($this->totalpage),$this->last_page,$style); } function nowbar($style='',$nowindex_style='') { $plus=ceil($this->pagebarnum/2); if($this->pagebarnum-$plus+$this->nowindex>$this->totalpage)$plus=($this->pagebarnum-$this->totalpage+$this->nowindex); $begin=$this->nowindex-$plus+1; $begin=($begin>=1)?$begin:1; $return=''; for($i=$begin;$i<$begin+$this->pagebarnum;$i++) { if($i<=$this->totalpage){ if($i!=$this->nowindex) $return.=$this->_get_text($this->_get_link($this->_get_url($i),$i,$style)); else $return.=$this->_get_text(''.$i.''); }else{ break; } $return.="\n"; } unset($begin); return $return; } /** * 擷取顯示跳轉按鈕的代碼 * * @return string */ function select() { $return=''; for($i=1;$i<=$this->totalpage;$i++) { if($i==$this->nowindex){ $return.=''.$i.''; }else{ $return.=''.$i.''; } } unset($i); $return.=''; return $return; } /** * 擷取mysql 語句中limit需要的值 * * @return string */ function offset() { return $this->offset; } /** * 控制分頁顯示風格（你可以增加相應的風格） * * @param int $mode * @return string */ function show($mode=1) { switch ($mode) { case '1': $this->next_page='下一頁'; $this->pre_page='上一頁'; return $this->pre_page().$this->nowbar().$this->next_page().'第'.$this->select().'頁'; break; case '2': $this->next_page='下一頁'; $this->pre_page='上一頁'; $this->first_page='首頁'; $this->last_page='尾頁'; return $this->first_page().$this->pre_page().'[第'.$this->nowindex.'頁]'.$this->next_page().$this->last_page().'第'.$this->select().'頁'; break; case '3': $this->next_page='下一頁'; $this->pre_page='上一頁'; $this->first_page='首頁'; $this->last_page='尾頁'; return $this->first_page().$this->pre_page().$this->next_page().$this->last_page(); break; case '4': $this->next_page='下一頁'; $this->pre_page='上一頁'; return $this->pre_page().$this->nowbar().$this->next_page(); break; case '5': return $this->pre_bar().$this->pre_page().$this->nowbar().$this->next_page().$this->next_bar(); break; case '6': return $this->select(); break; case '7': return $this->nowbar(); break; } } /*----------------private function (私人方法)-----------------------------------------------------------*/ /** * 設定url頭地址 * @param: String $url * @return boolean */ function _set_url($url="") { if(!empty($url)){ //手動設定 $this->url=$url.((stristr($url,'?'))?'&':'?').$this->page_name."="; }else{ //自動擷取 if(empty($_SERVER['QUERY_STRING'])){ //不存在QUERY_STRING時 $this->url=$_SERVER['REQUEST_URI']."?".$this->page_name."="; }else{ // if(stristr($_SERVER['QUERY_STRING'],$this->page_name.'=')){ //地址存在頁面參數 $this->url=str_replace($this->page_name.'='.$this->nowindex,'',$_SERVER['REQUEST_URI']); $last=$this->url[strlen($this->url)-1]; if($last=='?'||$last=='&'){ $this->url.=$this->page_name."="; }else{ $this->url.='&'.$this->page_name."="; } }else{ // $this->url=$_SERVER['REQUEST_URI'].'&'.$this->page_name.'='; }//end if }//end if }//end if } /** * 設定當前頁面 * */ function _set_nowindex($nowindex) { if(empty($nowindex)){ //系統擷取 if(isset($_GET[$this->page_name])){ $this->nowindex=intval($_GET[$this->page_name]); } if(isset($_POST['PB_Page_Select'])){ $this->nowindex=$_POST['PB_Page_Select']; } }else{ //手動設定 $this->nowindex=intval($nowindex); } } /** * 為指定的頁面返回地址值 * * @param int $pageno * @return string $url */ function _get_url($pageno=1) { return $this->url.$pageno; } /** * 擷取分頁顯示文字，比如說預設情況下_get_text('1')將返回[1] * * @param String $str * @return string $url */ function _get_text($str) { return $this->format_left.$str.$this->format_right; } /** * 擷取連結地址 */ function _get_link($url,$text,$style=''){ $style=(empty($style))?'':'class="'.$style.'"'; if($this->is_ajax){ //如果是使用AJAX模式 return 'ajax_action_name.'(\''.$url.'\')">'.$text.''; }else{ return ''.$text.''; } } /** * 出錯處理方式 */ function error($function,$errormsg) { die('Error in file '.__FILE__.' ,Function '.$function.'() :'.$errormsg); } } // 繼承分頁類，加入資料庫訪問能力. class Page extends _Page { var $db; //db connected object var $_Sql_Query = ''; //查詢資料庫的sql var $_Total = 0; //查詢到的總記錄.必須先是 var $_Rst = array(); //查詢到的記錄. /** * 分頁查詢類庫. * * @param String $Sql 記錄查詢的SQL 陳述式. * @param int $pagenuber 每頁多少條記錄. * @param int $pagen 當前頁面. * @param String $url 分頁連結帶入的參數. index.php?xx=b&bb=33 * @param String $pname 當前第幾頁的標記,預設是 index.php?xx=b&bb=33&page=2 如果有特殊要求 可以修改 $pname的參數. 比如: $pname='db_page',則變成: index.php?xx=b&bb=33&db_page=2 * @return Mysql_Page */ function Page($db, $sql_query = '', $max_rows_per_page = 20, $current_page_number = 0, $url = '', $parameters = '', $pname = 'PB_page',$otc = '*') { $this -> db = $db; $pos_to = strlen($sql_query); $pos_from = strpos($sql_query, ' from', 0); $pos_group_by = strpos($sql_query, ' group by', $pos_from); if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by; $pos_having = strpos($sql_query, ' having', $pos_from); if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having; $pos_order_by = strpos($sql_query, ' order by', $pos_from); if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by; $reviews_count = $this -> db -> getResults("select count($otc) as total " . substr($sql_query, $pos_from, ($pos_to - $pos_from))); $query_num_rows = $reviews_count[0]['total']; $this -> _Total = $query_num_rows; $num_pages = ceil($query_num_rows / $max_rows_per_page); if ($current_page_number > $num_pages) { $current_page_number = $num_pages; } $offset = ($max_rows_per_page * ($current_page_number - 1)); if ($offset < 0) $offset = 0; if ($offset > 0) { $offset = $offset + 1; } $this -> _Sql_Query = $sql_query . " limit " . $offset . ", " . $max_rows_per_page; $this -> setData(); //查詢資料庫. parent :: page(array('total' => $query_num_rows, 'perpage' => $max_rows_per_page, 'page_name' => $pname, 'url' => $url, 'parameters' => $parameters)); } /** * 取得當前頁面的記錄,返回一個數組. */ function findByAll() { return $this -> _Rst; } /** * 顯示分頁資訊. * * @param int $model */ function dispaly_links($model) { $this -> show($model); } /** * 返回記錄數. * * @return Int */ function getCount() { return $this -> _Total; } /** * 取查詢結果記錄數.. * * @return Int */ function getRows() { return count($this -> _Rst); } /** * 執行查詢功能. * 計算數組. * 私人方法. */ function setData() { $this -> _Rst = $this -> db -> getResults($this -> _Sql_Query); } } ?> 複製代碼

