PHP分页类的使用

PHP分页类的使用

page.class.php

<?phpclass Page {private $total_rows;//数据库总条数private $per_page_rows;//每页显示条数private $limit;private $uri;private $total_pages;//总页数private $config=array("header"=>"记录条数","prev"=>"上一页","next"=>"下一页","first"=>"首 页","last"=>"尾 页");private $list_length=8;public function __construct($total_rows,$per_page_rows=10,$url_args){$this->total_rows=$total_rows;$this->per_page_rows=$per_page_rows;$this->uri=$this->get_uri($url_args);$this->page = !empty($_GET['page']) ? $_GET['page'] : 1;$this->total_pages=ceil($this->total_rows/$this->per_page_rows);$this->limit=$this->set_limit();}private function set_limit() {return "limit ".($this->page-1)*$this->per_page_rows.",{$this->per_page_rows}";}private function get_uri($url_args) {$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"],"?") ? "" : "?").$url_args;$parse=parse_url($url);if (isset($parse['query'])) {parse_str($parse['query'],$params);//把url字符串解析为数组unset($params['page']);//删除数组下标为page的值$url=$parse['path'].'?'.http_build_query($params);//再次构建url}return $url;}public function __get($args) {if ($args=="limit") {return $this->limit;}else{return null;} }private function start_page(){if ($this->total_rows==0) {return 0;}else{return (($this->page-1)*$this->per_page_rows)+1;}}private function end_page(){return min($this->page*$this->per_page_rows,$this->total_rows);}private function go_first() {$html="";if ($this->page==1) {$html.="&nbsp;{$this->config['first']}&nbsp;";}else{$html.="&nbsp;<a href='{$this->uri}&page=1'>{$this->config['first']}</a>&nbsp;";}return $html;}private function go_prev() {$html="";if ($this->page==1) {$html.="&nbsp;{$this->config['prev']}&nbsp;";}else{$html.="&nbsp;<a href='{$this->uri}&page={$this->page}-1'>{$this->config['prev']}</a>&nbsp;";}return $html;}private function go_next() {$html="";if ($this->page==$this->total_pages) {$html.="&nbsp;{$this->config['next']}&nbsp;";}else{$html.="&nbsp;<a href='{$this->uri}&page={$this->page}+1'>{$this->config['next']}</a>&nbsp;";}return $html;}private function go_last() {$html="";if ($this->page==$this->total_pages) {$html.="&nbsp;{$this->config['last']}&nbsp;";}else{$html.="&nbsp;<a href='{$this->uri}&page={$this->total_pages}'>{$this->config['last']}</a>&nbsp;";}return $html;}private function go_page() {return '&nbsp;<input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->total_pages.')?'.$this->total_pages.':this.value;location=\''.$this->uri.'&page=\'+page+\'\'}" value="'.$this->page.'" style="width:25px;" /><input type="button" onclick="javascript:var page=(this.previousSibling.value>'.$this->total_pages.')?'.$this->total_pages.':this.previousSibling.value;location=\''.$this->uri.'&page=\'+page+\'\'" value="GO" />&nbsp;';}private function page_list() {$link_page="";$i_num=floor($this->list_length/2);for ($i = $i_num; $i >= 1; $i--) {$page=$this->page-$i;if ($page<1) {continue;}else{$link_page.="&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";}}$link_page.="&nbsp;{$this->page}&nbsp;";for ($i = 1; $i < $i_num; $i++) {$page=$this->page+$i;if ($page<=$this->total_pages) {$link_page.="&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";}else{break;}}return $link_page;}public function out_page($display=array(0,1,2,3,4,5,6,7,8)) {$display_html='';$html[0]="&nbsp;共有<b>{$this->total_rows}</b>{$this->config['header']}&nbsp;";$html[1]="&nbsp;每页显示<b>".($this->end_page()-$this->start_page()+1)."</b>条,本页显示从<b>{$this->start_page()}</b>--<b>{$this->end_page()}</b>{$this->config['header']}&nbsp;";$html[2]="&nbsp;<b>{$this->page}</b>/<b>{$this->total_pages}</b>页&nbsp;";$html[3]=$this->go_first();$html[4]=$this->go_prev();$html[5]=$this->page_list();$html[6]=$this->go_next();$html[7]=$this->go_last();$html[8]=$this->go_page();foreach ($display as $index){$display_html.=$html[$index];}return $display_html;}}
?>

page_demo.php

<?php
header("content-type:text/html;charset=utf-8");
require_once './page.class.php';
require_once '../config/config.db.php';
//数据库中的总条数:total_rows;
//每一页显示的条数:per_page_rows$sql="select * from cp_sd_day";$rt=mysql_query($sql);$total_rows=mysql_num_rows($rt);$per_page_rows=10;$page=new Page($total_rows,$per_page_rows);$sql="select * from cp_sd_day {$page->limit}";$rt=mysql_query($sql);echo '<table width="1000" border="1">';echo '<caption><h1>cp_sd_day</h1></caption>';while (!!$row=mysql_fetch_assoc($rt)) {echo '<tr>';echo '<td>'.$row['date_no'].'</td>';echo '<td>'.$row['max_notwin'].'</td>';echo '<td>'.$row['sum_last_miss'].'</td>';echo '<td>'.$row['last_miss'].'</td>';echo '<td>'.$row['last_miss_sort'].'</td>';echo '</tr>';}echo '<tr><td colspan="5" align="right">'.$page->out_page(array(2,3,4,5,6,7,8)).'</td></tr>';echo '</table>';
?>