Home Backend Development PHP Tutorial A useful php paging class

A useful php paging class

Jul 25, 2016 am 09:02 AM

  1. /**
  2. Class to paginate queries
  3. @link http://bbs.it-home.org
  4. */
  5. class paging
  6. {
  7. private $pageSize; //The number of items displayed on each page. The default is 10 items.
  8. private $totlePage; //How many records are there in total? private $dbConnection; //Database connection
  9. private $nowPageIndex; //The number of pages currently displayed
  10. private $show; //Use that method to display navigation, the default method It is the method of using show1() Home Page | Previous Page | Next Page | Last Page.
  11. /**
  12. Constructor to establish a database connection
  13. @$pageSizeP The number of items displayed on each page is 10 by default.
  14. @$show Which method to use to display navigation, the default method is to use show1() Home page | Previous page | Next page | Last page.
  15. */
  16. public function _construct($pageSizeP=10,$show="show1")
  17. {
  18. $this->dbConnection = @mysql_connect("localhost","username","password" );
  19. if($this->dbConnection)
  20. {
  21. die("");
  22. }
  23. mysql_select_db($this->dbConnection,"databaseName");
  24. $this->show = $show;
  25. $this->pageSize = $pageSizeP;
  26. }
  27. /**
  28. Destructor, closes the database connection.
  29. */
  30. public function _destruct()
  31. {
  32. @mysql_close($this->dbConnection);
  33. }
  34. /**
  35. Query the database and display the number of records in the database.
  36. @$sql SQL statement to query the database.
  37. @$charset queries the character set used by the database. The default is UTF-8.
  38. @return Returns the result of database query, saves it as an array, and then returns it, the number of items is uncertain.
  39. */
  40. public function querySQL($sql,$charset="UTF-8")
  41. {
  42. mysql_query("SET NAMES ".$charset);
  43. $rs = @mysql_query($sql);
  44. if(!$rs )
  45. {
  46. die("");
  47. }
  48. $num = @mysql_num_rows($rs);
  49. $this->totlePage= ceil($num/$this->pageSize);
  50. $this-> nowPageIndex = (isset($_POST['page']) || $_POST['page'] >= 1):$_POST['page']?1;
  51. if($this->nowPageIndex >$ this->totlePage)
  52. {
  53. $this->nowPageIndex = $this->totlePage;
  54. }
  55. $start = ($this->nowPageIndex - 1)*$this->pageSize;
  56. mysql_free_result( $rs);
  57. $sql .= "LIMIT $start,$this->pageSize";
  58. $rs = @mysql_query($sql);
  59. if(!$rs)
  60. {
  61. die("");
  62. }
  63. $rows = array();
  64. while($row = @mysql_fetch_row($rs))
  65. {
  66. $rows[] = $row;
  67. }
  68. @mysql_free_result($rs);
  69. return $rows;
  70. }
  71. /**
  72. Show navigation orchid.
  73. @$arg Parameters for calling the function that displays navigation.
  74. $img1 is an array that saves the images of navigation connections. used when calling show1().
  75. $size is the number of pages displayed in one row of the navigation blueprint. used when calling show2().
  76. */
  77. public function show($arg)
  78. {
  79. $func = $this->show;
  80. $this->$func($arg);
  81. }
  82. /**
  83. The navigation is displayed in the order of Home Page | Previous Page | Next Page | Last Page.
  84. @$img1 The image path array corresponding to the home page | previous page | next page | last page. The default is NULL, which does not display images.
  85. */
  86. private function show1($img1 = NULL)
  87. {
  88. $url = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
  89. $str = "
  90. 当前$this->nowPageIndex页/共$this->totlePage页";
  91. if(isset($img) || $img != NULL)
  92. {
  93. $str .= "首页
  94. $str .= ">上一页
  95. $str .= ">下一页
  96. $str .= ">末页
  97. ";
  98. }
  99. else
  100. {
  101. $str .= "首页>
  102. $str .= ">上一页
  103. $str .= ">下一页
  104. $str .= ">末页
  105. ";
  106. }
  107. echo $str;
  108. }
  109. /**
  110. Take 1|2|3|. . . to display navigation.
  111. @$size The number of pages displayed in each row of the navigation orchid. The default is 10.
  112. */
  113. private function show2($size =10)
  114. {
  115. $url = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
  116. $str = "
  117. ";
  118. for($index = 1 ; $index <= $this->totlePage ; $index++)
  119. {
  120. $str .= "
  121. ";
  122. if($index == $size)
  123. {
  124. $str .="
  125. ";
  126. }
  127. }
  128. $str .= "
  129. $str .= "$index
  130. ";
  131. echo $str;
  132. }
  133. }
  134. ?>
复制代码


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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Apr 05, 2025 am 12:04 AM

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

Describe the SOLID principles and how they apply to PHP development. Describe the SOLID principles and how they apply to PHP development. Apr 03, 2025 am 12:04 AM

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set permissions of unixsocket after system restart? How to automatically set permissions of unixsocket after system restart? Mar 31, 2025 pm 11:54 PM

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

Explain the concept of late static binding in PHP. Explain the concept of late static binding in PHP. Mar 21, 2025 pm 01:33 PM

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

How to send a POST request containing JSON data using PHP's cURL library? How to send a POST request containing JSON data using PHP's cURL library? Apr 01, 2025 pm 03:12 PM

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Framework Security Features: Protecting against vulnerabilities. Framework Security Features: Protecting against vulnerabilities. Mar 28, 2025 pm 05:11 PM

Article discusses essential security features in frameworks to protect against vulnerabilities, including input validation, authentication, and regular updates.

Customizing/Extending Frameworks: How to add custom functionality. Customizing/Extending Frameworks: How to add custom functionality. Mar 28, 2025 pm 05:12 PM

The article discusses adding custom functionality to frameworks, focusing on understanding architecture, identifying extension points, and best practices for integration and debugging.

See all articles