Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Share: An example code of PHP page turning (paging) class

Share: An example code of PHP page turning (paging) class

WBOY
Release： 2016-07-25 08:52:25
Original
980 people have browsed it
  2. /**
  3. * filename: ext_page.class.php
  4. * @package:phpbean
  5. * descrīption: Super powerful paging class, four paging modes, the default paging style is similar to Baidu and Google.
  6. * 2.0 added functions: supports custom styles, custom styles, supports both PHP4 and PHP5,
  7. * example:
  8. * Four paging modes:
  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. Turn on AJAX:
  16. $ajaxpage=new page(array('total'=>1000,'perpage'=> ;20,'ajax'=>'ajax_page','page_name'=>'test'));
  17. echo 'mode:1
    '.$ajaxpage->show();
  18. Use inheritance customization Pagination display mode.
  19. Editing: Scripting School http://bbs.it-home.org
  20. */
  21. class _page
  22. {
  23. /**
  24. * config ,public
  25. */
  26. var $page_name="PB_page";//page tag, used to control url Page. For example, PB_page in xxx.php?PB_page=2
  27. var $next_page='>';//Next page
  28. var $pre_page='<';//Previous page
  29. var $first_page='First' ;//Homepage
  30. var $last_page='Last';//Last page
  31. var $pre_bar='<<';//Previous paging bar
  32. var $next_bar='>>';//Next A paging bar
  33. var $format_left='[';
  34. var $format_right=']';
  35. var $is_ajax=false;//Whether AJAX paging mode is supported
  37. /**
  38. * private
  39. *
  40. */
  41. var $pagebarnum= 10;//Control the number of record strips.
  42. var $totalpage=0;//Total number of pages
  43. var $ajax_action_name='';//AJAX action name
  44. var $nowindex=1;//Current page
  45. var $url="";//url address header
  46. var $offset=0;
  48. /**
  49. * constructor构造函数
  50. *
  51. * @param array $array['total'],$array['perpage'],$array['nowindex'],$array['url'],$array['ajax']...
  52. */
  53. function page($array)
  54. {
  55. if(is_array($array)){
  56. if(!array_key_exists('total',$array))$ this->error(__FUNCTION__,'need a param of total');
  57. $total=intval($array['total']);
  58. $perpage=(array_key_exists('perpage',$array))?intval( $array['perpage']):10;
  59. $nowindex=(array_key_exists('nowindex',$array))?intval($array['nowindex']):'';
  60. $url=(array_key_exists('url ',$array))?$array['url']:'';
  61. }else{
  62. $total=$array;
  63. $perpage=10;
  64. $nowindex='';
  65. $url='';
  66. }
  67. if((!is_int($total))||($total<0))$this->error(__FUNCTION__,$total.' is not a positive integer!');
  68. if((!is_int( $perpage))||($perpage<=0))$this->error(__FUNCTION__,$perpage.' is not a positive integer!');
  69. if(!empty($array['page_name']) )$this->set('page_name',$array['page_name']);//Set pagename
  70. $this->_set_nowindex($nowindex);//Set the current page
  71. $this->_set_url( $url);//Set the link address
  72. $this->totalpage=ceil($total/$perpage);
  73. $this->offset=($this->nowindex-1)*$perpage;
  74. if (!empty($array['ajax']))$this->open_ajax($array['ajax']);//Open AJAX mode
  75. }
  76. /**
  77. * Set the value of the specified variable name in the class. If the change does not belong to this class, an exception will be thrown
  78. *
  79. * @param string $var
  80. * @param string $value
  81. */
  82. function set($ var,$value)
  83. {
  84. if(in_array($var,get_object_vars($this)))
  85. $this->$var=$value;
  86. else {
  87. $this->error(__FUNCTION__,$var. " does not belong to PB_Page!");
  88. }
  90. }
  91. /**
  92. * Turn on reverse AJAX mode
  93. *
  94. * @param string $action Default ajax triggered action.
  95. */
  96. function open_ajax($action)
  97. {
  98. $this->is_ajax=true;
  99. $this->ajax_action_name=$action;
  100. }
  101. /**
  102. * Get the code to display "next page"
  103. *
  104. * @param string $style
  105. * @return string
  106. */
  107. function next_page($style='')
  108. {
  109. if($this->nowindex<$this->totalpage){
  110. return $this->_get_link($this->_get_url($this->nowindex+1),$this->next_page,$style);
  111. }
  112. return ''.$this->next_page.'';
  113. }
  115. /**
  116. * Get the code to display "previous page"
  117. *
  118. * @param string $style
  119. * @return string
  120. */
  121. function pre_page($style='')
  122. {
  123. if($this->nowindex>1){
  124. return $this->_get_link($this->_get_url($this->nowindex-1),$this->pre_page,$style);
  125. }
  126. return ''.$this->pre_page.'';
  127. }
  129. /**
  130. * Get the code to display "Home Page"
  131. *
  132. * @return string
  133. */
  134. function first_page($style='')
  135. {
  136. if($this->nowindex==1){
  137. return ''.$this->first_page.'';
  138. }
  139. return $this->_get_link($this->_get_url(1),$this->first_page,$style);
  140. }
  142. /**
  143. * Get the code to display the "last page"
  144. *
  145. * @return string
  146. */
  147. function last_page($style='')
  148. {
  149. if($this->nowindex==$this->totalpage){
  150. return ''.$this->last_page.'';
  151. }
  152. return $this->_get_link($this->_get_url($this->totalpage),$this->last_page,$style);
  153. }
  155. function nowbar($style='',$nowindex_style='')
  156. {
  157. $plus=ceil($this->pagebarnum/2);
  158. if($this->pagebarnum-$plus+$this->nowindex>$this->totalpage)$plus=($this->pagebarnum-$this->totalpage+$this->nowindex);
  159. $begin=$this->nowindex-$plus+1;
  160. $begin=($begin>=1)?$begin:1;
  161. $return='';
  162. for($i=$begin;$i<$begin+$this->pagebarnum;$i++)
  163. {
  164. if($i<=$this->totalpage){
  165. if($i!=$this->nowindex)
  166. $return.=$this->_get_text($this->_get_link($this->_get_url($i),$i,$style));
  167. else
  168. $return.=$this->_get_text(''.$i.'');
  169. }else{
  170. break;
  171. }
  172. $return.="n";
  173. }
  174. unset($begin);
  175. return $return;
  176. }
  177. /**
  178. * Get the code to display the jump button
  179. *
  180. * @return string
  181. */
  182. function select()
  183. {
  184. $return='';
  185. return $return;
  186. }
  188. /**
  189. * Get the value required for limit in the mysql statement
  190. *
  191. * @return string
  192. */
  193. function offset()
  194. {
  195. return $this->offset;
  196. }
  198. /**
  199. * Control paging display style (you can add corresponding style)
  200. *
  201. * @param int $mode
  202. * @return string
  203. */
  204. function show($mode=1)
  205. {
  206. switch ($mode)
  207. {
  208. case '1':
  209. $this->next_page='下一页';
  210. $this->pre_page='上一页';
  211. return $this->pre_page().$this->nowbar().$this->next_page().'第'.$this->select().'页';
  212. break;
  213. case '2':
  214. $this->next_page='下一页';
  215. $this->pre_page='上一页';
  216. $this->first_page='首页';
  217. $this->last_page='尾页';
  218. return $this->first_page().$this->pre_page().'[第'.$this->nowindex.'页]'.$this->next_page().$this->last_page().'第'.$this->select().'页';
  219. break;
  220. case '3':
  221. $this->next_page='下一页';
  222. $this->pre_page='上一页';
  223. $this->first_page='首页';
  224. $this->last_page='尾页';
  225. return $this->first_page().$this->pre_page().$this->next_page().$this->last_page();
  226. break;
  227. case '4':
  228. $this->next_page='下一页';
  229. $this->pre_page='上一页';
  230. return $this->pre_page().$this->nowbar().$this->next_page();
  231. break;
  232. case '5':
  233. return $this->pre_bar().$this->pre_page().$this->nowbar().$this->next_page().$this->next_bar();
  234. break;
  235. case '6':
  236. return $this->select();
  237. break;
  238. case '7':
  239. return $this->nowbar();
  240. break;
  241. }
  243. }
  244. /*----------------private function (私有方法)-----------------------------------------------------------*/
  245. /**
  246. * Set url header address
  247. * @param: String $url
  248. * @return boolean
  249. */
  250. function _set_url($url="")
  251. {
  252. if(!empty($url)){
  253. //手动设置
  254. $this->url=$url.((stristr($url,'?'))?'&':'?').$this->page_name."=";
  255. }else{
  256. //自动获取
  257. if(empty($_SERVER['QUERY_STRING'])){
  258. //不存在QUERY_STRING时
  259. $this->url=$_SERVER['REQUEST_URI']."?".$this->page_name."=";
  260. }else{
  261. //
  262. if(stristr($_SERVER['QUERY_STRING'],$this->page_name.'=')){
  263. //地址存在页面参数
  264. $this->url=str_replace($this->page_name.'='.$this->nowindex,'',$_SERVER['REQUEST_URI']);
  265. $last=$this->url[strlen($this->url)-1];
  266. if($last=='?'||$last=='&'){
  267. $this->url.=$this->page_name."=";
  268. }else{
  269. $this->url.='&'.$this->page_name."=";
  270. }
  271. }else{
  272. //
  273. $this->url=$_SERVER['REQUEST_URI'].'&'.$this->page_name.'=';
  274. }//end if
  275. }//end if
  276. }//end if
  277. }
  279. /**
  280. * Set current page
  281. *
  282. */
  283. function _set_nowindex($nowindex)
  284. {
  285. if(empty($nowindex)){
  286. //系统获取
  288. if(isset($_GET[$this->page_name])){
  289. $this->nowindex=intval($_GET[$this->page_name]);
  290. }
  291. if(isset($_POST['PB_Page_Select'])){
  292. $this->nowindex=$_POST['PB_Page_Select'];
  293. }
  294. }else{
  295. //手动设置
  296. $this->nowindex=intval($nowindex);
  297. }
  298. }
  300. /**
  301. * Return the address value for the specified page
  302. *
  303. * @param int $pageno
  304. * @return string $url
  305. */
  306. function _get_url($pageno=1)
  307. {
  308. return $this->url.$pageno;
  309. }
  311. /**
  312. * Get pagination display text, for example, by default _get_text('1') will return [1]
  313. *
  314. * @param String $str
  315. * @return string $url
  316. */
  317. function _get_text($str)
  318. {
  319. return $this->format_left.$str.$this->format_right;
  320. }
  322. /**
  323. * Get link address
  324. */
  325. function _get_link($url,$text,$style=''){
  326. $style=(empty($style))?'':'class="'.$style.'"';
  327. if($this->is_ajax){
  328. //如果是使用AJAX模式
  329. return ''.$text.'';
  330. }else{
  331. return ''.$text.'';
  332. }
  333. }
  334. /**
  335. * Error handling method
  336. */
  337. function error($function,$errormsg)
  338. {
  339. die('Error in file '.__FILE__.' ,Function '. $function.'() :'.$errormsg);
  340. }
  341. }
  343. // Inherit the paging class and add database access capabilities.
  344. class Page extends _Page {
  345. var $db; //db connected object
  346. var $_Sql_Query = ''; //Query the sql of the database
  347. var $_Total = 0; //The total records queried. Must first be
  348. var $_Rst = array(); //The records queried.
  349. / **
  350. * Paging query library.
  351. *
  352. * @param String $Sql Record query SQL statement.
  353. * @param int $pagenuber How many records per page.
  354. * @param int $pagen Current page.
  355. * @param String $url Parameters brought into the paging link. index.php?xx=b&bb=33
  356. * @param String $pname The mark of the current page. The default is index.php?xx=b&bb=33&page=2 if there are special requirements
  357. You can modify the parameters of $pname. For example: $pname='db_page', it becomes: index.php?xx=b&bb=33&db_page=2
  358. * @return Mysql_Page
  359. */
  361. function Page($db, $sql_query = '', $max_rows_per_page = 20, $current_page_number = 0, $url = '', $parameters = '', $pname = 'PB_page', $otc = '*') {
  362. $this -> db = $db;
  363. $pos_to = strlen($sql_query);
  364. $pos_from = strpos($sql_query, ' from', 0);
  365. $pos_group_by = strpos ($sql_query, ' group by', $pos_from);
  366. if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by;
  367. $pos_having = strpos($sql_query, ' having ', $pos_from);
  368. if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having;
  369. $pos_order_by = strpos($sql_query, ' order by', $pos_from);
  370. if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by; ​​
  371. $reviews_count = $this -> db -> getResults("select count($otc) as total " . substr($sql_query, $pos_from, ($pos_to - $pos_from)));
  372. $query_num_rows = $reviews_count[0]['total'];
  373. $this -> _Total = $query_num_rows;
  374. $num_pages = ceil($query_num_rows / $max_rows_per_page);
  375. if ($current_page_number > $num_pages) {
  376. $current_page_number = $num_pages;
  377. }
  378. $offset = ($max_rows_per_page * ($current_page_number - 1));
  379. if ($offset < 0) $offset = 0;
  380. if ($offset > 0) {
  381. $offset = $offset + 1;
  382. }
  383. $this -> _Sql_Query = $sql_query . " limit " . $offset . ", " . $max_rows_per_page;
  384. $this -> setData(); //Query the database.
  385. parent :: page(array('total' => $query_num_rows, 'perpage' => $max_rows_per_page, 'page_name' = > $pname, 'url' => $url, 'parameters' => $parameters));
  386. }
  388. /**
  389. * Get the records of the current page and return an array.
  390. */
  391. function findByAll() {
  392. return $this -> _Rst;
  393. }
  394. /**
  395. * Display paging information.
  396. *
  397. * @param int $model
  398. */
  399. function dispaly_links($model) {
  400. $this -> show($model);
  401. }
  402. /**
  403. * Returns the number of records.
  404. *
  405. * @return Int
  406. */
  407. function getCount() {
  408. return $this -> _Total;
  409. }
  410. /**
  411. * Get the number of query result records..
  412. *
  413. * @return Int
  414. */
  415. function getRows() {
  416. return count($this -> _Rst);
  417. }
  418. /**
  419. * Execute query function.
  420. * Calculate array.
  421. * Private method.
  422. */
  423. function setData() {
  424. $this -> _Rst = $this -> db -> getResults($this -> _Sql_Query);
  425. }
  426. }
  428. ?>
Copy code


Related labels：
分享:一例PHP翻页(分页)类的实例代码
source：php.cn
Previous article：thinkphp paging method and implementation code Next article：How to rebuild index after deleting elements from php array?
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2060
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2215
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1870
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1753
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1779
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template