分享:一例PHP翻页(分页)类的实例代码

2. /**
3. * filename: ext_page.class.php
4. * @package:phpbean
5. * descrīption:超强分页类，四种分页模式，默认采用类似baidu,google的分页风格。
6. * 2.0增加功能：支持自定义风格，自定义样式，同时支持PHP4和PHP5,
7. * example:
8. * 模式四种分页模式：
9. require_once('../libs/classes/page.class.php');
10. $page=new page(array('total'=>1000,'perpage'=>20));
11. echo 'mode:1
    '.$page->show();
12. echo '

    ---

    mode:2
    '.$page->show(2);
13. echo '

    ---

    mode:3
    '.$page->show(3);
14. echo '

    ---

    mode:4
    '.$page->show(4);
15. 开启AJAX：
16. $ajaxpage=new page(array('total'=>1000,'perpage'=>20,'ajax'=>'ajax_page','page_name'=>'test'));
17. echo 'mode:1
    '.$ajaxpage->show();
18. 采用继承自定义分页显示模式。
19. 编辑整理：脚本学堂 http://bbs.it-home.org
20. */
21. class _page
22. {
23. /**
24. * config ,public
25. */
26. var $page_name="PB_page";//page标签，用来控制url页。比如说xxx.php?PB_page=2中的PB_page
27. var $next_page='>';//下一页
28. var $pre_page=' var $first_page='First';//首页
29. var $last_page='Last';//尾页
30. var $pre_bar=' var $next_bar='>>';//下一分页条
31. var $format_left='[';
32. var $format_right=']';
33. var $is_ajax=false;//是否支持AJAX分页模式
35. /**
36. * private
37. *
38. */
39. var $pagebarnum=10;//控制记录条的个数。
40. var $totalpage=0;//总页数
41. var $ajax_action_name='';//AJAX动作名
42. var $nowindex=1;//当前页
43. var $url="";//url地址头
44. var $offset=0;
46. /**
47. * constructor构造函数
48. *
49. * @param array $array['total'],$array['perpage'],$array['nowindex'],$array['url'],$array['ajax']...
50. */
51. function page($array)
52. {
53. if(is_array($array)){
54. if(!array_key_exists('total',$array))$this->error(__FUNCTION__,'need a param of total');
55. $total=intval($array['total']);
56. $perpage=(array_key_exists('perpage',$array))?intval($array['perpage']):10;
57. $nowindex=(array_key_exists('nowindex',$array))?intval($array['nowindex']):'';
58. $url=(array_key_exists('url',$array))?$array['url']:'';
59. }else{
60. $total=$array;
61. $perpage=10;
62. $nowindex='';
63. $url='';
64. }
65. if((!is_int($total))||($totalerror(__FUNCTION__,$total.' is not a positive integer!');
66. if((!is_int($perpage))||($perpageerror(__FUNCTION__,$perpage.' is not a positive integer!');
67. if(!empty($array['page_name']))$this->set('page_name',$array['page_name']);//设置pagename
68. $this->_set_nowindex($nowindex);//设置当前页
69. $this->_set_url($url);//设置链接地址
70. $this->totalpage=ceil($total/$perpage);
71. $this->offset=($this->nowindex-1)*$perpage;
72. if(!empty($array['ajax']))$this->open_ajax($array['ajax']);//打开AJAX模式
73. }
74. /**
75. * 设定类中指定变量名的值，如果改变量不属于这个类，将throw一个exception
76. *
77. * @param string $var
78. * @param string $value
79. */
80. function set($var,$value)
81. {
82. if(in_array($var,get_object_vars($this)))
83. $this->$var=$value;
84. else {
85. $this->error(__FUNCTION__,$var." does not belong to PB_Page!");
86. }
88. }
89. /**
90. * 打开倒AJAX模式
91. *
92. * @param string $action 默认ajax触发的动作。
93. */
94. function open_ajax($action)
95. {
96. $this->is_ajax=true;
97. $this->ajax_action_name=$action;
98. }
99. /**
100. * 获取显示"下一页"的代码
101. *
102. * @param string $style
103. * @return string
104. */
105. function next_page($style='')
106. {
107. if($this->nowindextotalpage){
108. return $this->_get_link($this->_get_url($this->nowindex+1),$this->next_page,$style);
109. }
110. return ''.$this->next_page.'';
111. }
113. /**
114. * 获取显示“上一页”的代码
115. *
116. * @param string $style
117. * @return string
118. */
119. function pre_page($style='')
120. {
121. if($this->nowindex>1){
122. return $this->_get_link($this->_get_url($this->nowindex-1),$this->pre_page,$style);
123. }
124. return ''.$this->pre_page.'';
125. }
127. /**
128. * 获取显示“首页”的代码
129. *
130. * @return string
131. */
132. function first_page($style='')
133. {
134. if($this->nowindex==1){
135. return ''.$this->first_page.'';
136. }
137. return $this->_get_link($this->_get_url(1),$this->first_page,$style);
138. }
140. /**
141. * 获取显示“尾页”的代码
142. *
143. * @return string
144. */
145. function last_page($style='')
146. {
147. if($this->nowindex==$this->totalpage){
148. return ''.$this->last_page.'';
149. }
150. return $this->_get_link($this->_get_url($this->totalpage),$this->last_page,$style);
151. }
153. function nowbar($style='',$nowindex_style='')
154. {
155. $plus=ceil($this->pagebarnum/2);
156. if($this->pagebarnum-$plus+$this->nowindex>$this->totalpage)$plus=($this->pagebarnum-$this->totalpage+$this->nowindex);
157. $begin=$this->nowindex-$plus+1;
158. $begin=($begin>=1)?$begin:1;
159. $return='';
160. for($i=$begin;$ipagebarnum;$i++)
161. {
162. if($itotalpage){
163. if($i!=$this->nowindex)
164. $return.=$this->_get_text($this->_get_link($this->_get_url($i),$i,$style));
165. else
166. $return.=$this->_get_text(''.$i.'');
167. }else{
168. break;
169. }
170. $return.="\n";
171. }
172. unset($begin);
173. return $return;
174. }
175. /**
176. * 获取显示跳转按钮的代码
177. *
178. * @return string
179. */
180. function select()
181. {
182. $return='';
     for($i=1;$itotalpage;$i++)
     {
     if($i==$this->nowindex){
     $return.='
     '.$i.'';
     }else{
     $return.='
     '.$i.'';
     }
     }
     unset($i);
     $return.='
     ';
183. return $return;
184. }
186. /**
187. * 获取mysql 语句中limit需要的值
188. *
189. * @return string
190. */
191. function offset()
192. {
193. return $this->offset;
194. }
196. /**
197. * 控制分页显示风格（你可以增加相应的风格）
198. *
199. * @param int $mode
200. * @return string
201. */
202. function show($mode=1)
203. {
204. switch ($mode)
205. {
206. case '1':
207. $this->next_page='下一页';
208. $this->pre_page='上一页';
209. return $this->pre_page().$this->nowbar().$this->next_page().'第'.$this->select().'页';
210. break;
211. case '2':
212. $this->next_page='下一页';
213. $this->pre_page='上一页';
214. $this->first_page='首页';
215. $this->last_page='尾页';
216. return $this->first_page().$this->pre_page().'[第'.$this->nowindex.'页]'.$this->next_page().$this->last_page().'第'.$this->select().'页';
217. break;
218. case '3':
219. $this->next_page='下一页';
220. $this->pre_page='上一页';
221. $this->first_page='首页';
222. $this->last_page='尾页';
223. return $this->first_page().$this->pre_page().$this->next_page().$this->last_page();
224. break;
225. case '4':
226. $this->next_page='下一页';
227. $this->pre_page='上一页';
228. return $this->pre_page().$this->nowbar().$this->next_page();
229. break;
230. case '5':
231. return $this->pre_bar().$this->pre_page().$this->nowbar().$this->next_page().$this->next_bar();
232. break;
233. case '6':
234. return $this->select();
235. break;
236. case '7':
237. return $this->nowbar();
238. break;
239. }
241. }
242. /*----------------private function (私有方法)-----------------------------------------------------------*/
243. /**
244. * 设置url头地址
245. * @param: String $url
246. * @return boolean
247. */
248. function _set_url($url="")
249. {
250. if(!empty($url)){
251. //手动设置
252. $this->url=$url.((stristr($url,'?'))?'&':'?').$this->page_name."=";
253. }else{
254. //自动获取
255. if(empty($_SERVER['QUERY_STRING'])){
256. //不存在QUERY_STRING时
257. $this->url=$_SERVER['REQUEST_URI']."?".$this->page_name."=";
258. }else{
259. //
260. if(stristr($_SERVER['QUERY_STRING'],$this->page_name.'=')){
261. //地址存在页面参数
262. $this->url=str_replace($this->page_name.'='.$this->nowindex,'',$_SERVER['REQUEST_URI']);
263. $last=$this->url[strlen($this->url)-1];
264. if($last=='?'||$last=='&'){
265. $this->url.=$this->page_name."=";
266. }else{
267. $this->url.='&'.$this->page_name."=";
268. }
269. }else{
270. //
271. $this->url=$_SERVER['REQUEST_URI'].'&'.$this->page_name.'=';
272. }//end if
273. }//end if
274. }//end if
275. }
277. /**
278. * 设置当前页面
279. *
280. */
281. function _set_nowindex($nowindex)
282. {
283. if(empty($nowindex)){
284. //系统获取
286. if(isset($_GET[$this->page_name])){
287. $this->nowindex=intval($_GET[$this->page_name]);
288. }
289. if(isset($_POST['PB_Page_Select'])){
290. $this->nowindex=$_POST['PB_Page_Select'];
291. }
292. }else{
293. //手动设置
294. $this->nowindex=intval($nowindex);
295. }
296. }
298. /**
299. * 为指定的页面返回地址值
300. *
301. * @param int $pageno
302. * @return string $url
303. */
304. function _get_url($pageno=1)
305. {
306. return $this->url.$pageno;
307. }
309. /**
310. * 获取分页显示文字，比如说默认情况下_get_text('1')将返回[1]
311. *
312. * @param String $str
313. * @return string $url
314. */
315. function _get_text($str)
316. {
317. return $this->format_left.$str.$this->format_right;
318. }
320. /**
321. * 获取链接地址
322. */
323. function _get_link($url,$text,$style=''){
324. $style=(empty($style))?'':'class="'.$style.'"';
325. if($this->is_ajax){
326. //如果是使用AJAX模式
327. return ''.$text.'';
328. }else{
329. return ''.$text.'';
330. }
331. }
332. /**
333. * 出错处理方式
334. */
335. function error($function,$errormsg)
336. {
337. die('Error in file '.__FILE__.' ,Function '.$function.'() :'.$errormsg);
338. }
339. }
341. // 继承分页类，加入数据库访问能力.
342. class Page extends _Page {
343. var $db; //db connected object
344. var $_Sql_Query = ''; //查询数据库的sql
345. var $_Total = 0; //查询到的总记录.必须先是
346. var $_Rst = array(); //查询到的记录.
347. /**
348. * 分页查询类库.
349. *
350. * @param String $Sql 记录查询的SQL 语句.
351. * @param int $pagenuber 每页多少条记录.
352. * @param int $pagen 当前页面.
353. * @param String $url 分页链接带入的参数. index.php?xx=b&bb=33
354. * @param String $pname 当前第几页的标记,默认是 index.php?xx=b&bb=33&page=2 如果有特殊要求
355. 可以修改 $pname的参数. 比如: $pname='db_page',则变成: index.php?xx=b&bb=33&db_page=2
356. * @return Mysql_Page
357. */
359. function Page($db, $sql_query = '', $max_rows_per_page = 20, $current_page_number = 0, $url = '', $parameters = '', $pname = 'PB_page',$otc = '*') {
360. $this -> db = $db;
361. $pos_to = strlen($sql_query);
362. $pos_from = strpos($sql_query, ' from', 0);
363. $pos_group_by = strpos($sql_query, ' group by', $pos_from);
364. if (($pos_group_by $pos_having = strpos($sql_query, ' having', $pos_from);
365. if (($pos_having $pos_order_by = strpos($sql_query, ' order by', $pos_from);
366. if (($pos_order_by $reviews_count = $this -> db -> getResults("select count($otc) as total " . substr($sql_query, $pos_from, ($pos_to - $pos_from)));
367. $query_num_rows = $reviews_count[0]['total'];
368. $this -> _Total = $query_num_rows;
369. $num_pages = ceil($query_num_rows / $max_rows_per_page);
370. if ($current_page_number > $num_pages) {
371. $current_page_number = $num_pages;
372. }
373. $offset = ($max_rows_per_page * ($current_page_number - 1));
374. if ($offset if ($offset > 0) {
375. $offset = $offset + 1;
376. }
377. $this -> _Sql_Query = $sql_query . " limit " . $offset . ", " . $max_rows_per_page;
378. $this -> setData(); //查询数据库.
379. parent :: page(array('total' => $query_num_rows, 'perpage' => $max_rows_per_page, 'page_name' => $pname, 'url' => $url, 'parameters' => $parameters));
380. }
382. /**
383. * 取得当前页面的记录,返回一个数组.
384. */
385. function findByAll() {
386. return $this -> _Rst;
387. }
388. /**
389. * 显示分页信息.
390. *
391. * @param int $model
392. */
393. function dispaly_links($model) {
394. $this -> show($model);
395. }
396. /**
397. * 返回记录数.
398. *
399. * @return Int
400. */
401. function getCount() {
402. return $this -> _Total;
403. }
404. /**
405. * 取查询结果记录数..
406. *
407. * @return Int
408. */
409. function getRows() {
410. return count($this -> _Rst);
411. }
412. /**
413. * 执行查询功能.
414. * 计算数组.
415. * 私有方法.
416. */
417. function setData() {
418. $this -> _Rst = $this -> db -> getResults($this -> _Sql_Query);
419. }
420. }
422. ?>

复制代码