Home > Developer > PHP

Share: an example of PHP paging instance code

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
Share: an example of PHP paging instance code

  2. /**
  3. * Filename: ext_page.class.php
  4. * @ Package: phpbean
  5. * Descr paging ption: powerful paging mode. it adopts four paging modes, which are similar to baidu and google by default.
  6. * 2.0 added: supports custom styles and styles, and supports both PHP4 and PHP5,
  7. * Example:
  8. * Mode: 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. Enable AJAX:
  16. $ Ajaxpage = new page (array ('total' => 1000, 'perpage' => 20, 'Ajax '=> 'Ajax _ page ', 'page _ name' => 'test '));
  17. Echo 'MoDe: 1
    '. $ Ajaxpage-> show ();
  18. Use the inherited custom paging display mode.
  19. Edit: Script school http://bbs.it-home.org
  20. */
  21. Class _ page
  22. {
  23. /**
  24. * Config, public
  25. */
  26. Var $ page_name = "PB_page"; // page label, used to control url pages. For example, xxx. php? PB_page = PB_page in 2
  27. Var $ next_page = '>'; // Next page
  28. Var $ pre_page = '<'; // Previous Page
  29. Var $ first_page = 'first'; // home page
  30. Var $ last_page = 'Lala'; // The Last page.
  31. Var $ pre_bar = '<'; // The Last Page
  32. Var $ next_bar = '>'; // Next page
  33. Var $ format_left = '[';
  34. Var $ format_right = ']';
  35. Var $ is_ajax = false; // whether the AJAX paging mode is supported
  37. /**
  38. * Private
  39. *
  40. */
  41. Var $ pagebarnum = 10; // control the number of records.
  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 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); // you can specify the current page.
  71. $ This-> _ set_url ($ url); // sets 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']); // enable the ajax mode
  75. }
  76. /**
  77. * Set the value of the variable name specified in the class. if the change volume does not belong to this class, throw an exception
  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. * Open the inverted AJAX mode.
  93. *
  94. * @ Param string $ action the 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 that displays the 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 for displaying the "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 for displaying the "homepage"
  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 for displaying 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 for displaying the jump button
  179. *
  180. * @ Return string
  181. */
  182. Function select ()
  183. {
  184. $ Return ='';For ($ I = 1; $ I <= $ this-> totalpage; $ I ++){If ($ I ==$ this-> nowindex ){$ Return. =''. $ I .'';} Else {$ Return. =''. $ I .'';}}Unset ($ I );$ Return. ='';
  185. Return $ return;
  186. }
  188. /**
  189. * Obtain the limit value in the mysql statement.
  190. *
  191. * @ Return string
  192. */
  193. Function offset ()
  194. {
  195. Return $ this-> offset;
  196. }
  198. /**
  199. * Control the display style by page (you can add the 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 = 'next page ';
  210. $ This-> pre_page = 'previous page ';
  211. Return $ this-> pre_page (). $ this-> nowbar (). $ this-> next_page (). 'Di '. $ this-> select (). 'Page ';
  212. Break;
  213. Case '2 ':
  214. $ This-> next_page = 'next page ';
  215. $ This-> pre_page = 'previous page ';
  216. $ This-> first_page = 'homepage ';
  217. $ This-> last_page = 'Last page ';
  218. Return $ this-> first_page (). $ this-> pre_page (). '[nth '. $ this-> nowindex. 'page] '. $ this-> next_page (). $ this-> last_page (). 'Di '. $ this-> select (). 'Page ';
  219. Break;
  220. Case '3 ':
  221. $ This-> next_page = 'next page ';
  222. $ This-> pre_page = 'previous page ';
  223. $ This-> first_page = 'homepage ';
  224. $ This-> last_page = '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 = 'next page ';
  229. $ This-> pre_page = 'previous 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 (private method )-----------------------------------------------------------*/
  245. /**
  246. * Set the url header address
  247. * @ Param: String $ url
  248. * @ Return boolean
  249. */
  250. Function _ set_url ($ url = "")
  251. {
  252. If (! Empty ($ url )){
  253. // Manually set
  254. $ This-> url = $ url. (stristr ($ url ,'? '))? '&':'? '). $ This-> page_name. "= ";
  255. } Else {
  256. // Automatically obtain
  257. If (empty ($ _ SERVER ['query _ string']) {
  258. // When QUERY_STRING does not exist
  259. $ This-> url = $ _ SERVER ['request _ URI ']. "? ". $ This-> page_name." = ";
  260. } Else {
  261. //
  262. If (stristr ($ _ SERVER ['query _ string'], $ this-> page_name. '= ')){
  263. // The address has page parameters.
  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 the current page
  281. *
  282. */
  283. Function _ set_nowindex ($ nowindex)
  284. {
  285. If (empty ($ nowindex )){
  286. // System retrieval
  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. // Manually set
  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 the text displayed by page. 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. * Obtain the link address
  324. */
  325. Function _ get_link ($ url, $ text, $ style = ''){
  326. $ Style = (empty ($ style ))? '': 'Class =" '. $ style .'"';
  327. If ($ this-> is_ajax ){
  328. // If the AJAX mode is used
  329. Return 'Ajax _ action_name. '(\ ''. $ url.' \ ')">'. $ 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 the database access capability.
  344. Class Page extends _ Page {
  345. Var $ db; // db connected object
  346. Var $ _ SQL _Query = ''; // query the database SQL
  347. Var $ _ Total = 0; // The Total number of queried records.
  348. Var $ _ Rst = array (); // query records.
  349. /**
  350. * The paging query class library.
  351. *
  352. * @ Param String $ the SQL statement used to query SQL records.
  353. * @ Param int $ pagenuber: the number of records per page.
  354. * @ Param int $ pagen current page.
  355. * @ Param String $ parameter. index. php? Xx = B & bb = 33
  356. * @ Param String $ tag of the current page of pname. the default value is index. php? Xx = B & bb = 33 & page = 2 if you have special requirements
  357. You can modify the $ pname parameter. for example, $ pname = 'DB _ page' is changed to 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 record of the current page and return an array.
  390. */
  391. Function findByAll (){
  392. Return $ this-> _ Rst;
  393. }
  394. /**
  395. * Display page information.
  396. *
  397. * @ Param int $ model
  398. */
  399. Function dispaly_links ($ model ){
  400. $ This-> show ($ model );
  401. }
  402. /**
  403. * Number of returned Records.
  404. *
  405. * @ Return Int
  406. */
  407. Function getCount (){
  408. Return $ this-> _ Total;
  409. }
  410. /**
  411. * Number of query result records ..
  412. *
  413. * @ Return Int
  414. */
  415. Function getRows (){
  416. Return count ($ this-> _ Rst );
  417. }
  418. /**
  419. * Execute the query function.
  420. * Calculate the array.
  421. * Private method.
  422. */
  423. Function setData (){
  424. $ This-> _ Rst = $ this-> db-> getResults ($ this-> _ SQL _Query );
  425. }
  426. }
  428. ?>

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
share php code online share php code php paging instance of example of encryption code php instance php paging script

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More