


Detailed explanation of paging program in php based on message board_PHP tutorial
The article focuses on the paging principle in PHP. At the same time, we use an implementation to explain how to implement paging in PHP. This is based on the square board program I wrote. Friends in need can refer to it. It is very useful. Suitable for beginners.
The key problem of paging actually lies in the two numbers following the limit keyword of Mysql. The first one is the starting row number that needs to be recorded, and the second number is how many rows are obtained after this starting row number. Recording - Don’t mistake this for the starting line and the ending line, which are very different.
Look at line 19 of our index.php:
The code is as follows | Copy code | ||||
|
代码如下 | 复制代码 |
if(isset($_GET['page'])&&$_GET['page']!=”) $page=$_GET['page']; |
The code is as follows | Copy code |
if(isset($_GET['page'])&&$_GET['page']!=”) $page=$_GET['page']; else $page=0;
|
代码如下 | 复制代码 |
$recordSql = "SELECT a . * , b.name, b.email, b.qq, c.revert_time, c.revert FROM post a LEFT JOIN revert c ON ( a.id = c.post_id ) , guest b WHERE a.guest_id = b.id ORDER BY a.id DESC " LIMIT 0,10"; |
We define the variable $pagesize ourselves on line 7, which is how many records are displayed on each page. We define 10. When the variable $page=0, our statement will eventually look like this:
It is to get 10 record results starting from 0 record - this includes the 0th record;
What about when $page=1? As you can imagine - at this time $page*$pagesize=10, of course it has never been... I won't say it anymore, it would be too long to say.代码如下 | 复制代码 |
mysql_num_rows(mysql_query($sql)); |
The code is as follows | Copy code |
mysql_num_rows(mysql_query($sql)); |
Get the total number of records and then add the limit keyword.
Okay, we have obtained the total number of records and set the number of records displayed on each page to 10. Now all we need is the total number of pages. I won’t talk about this elementary school problem, right? Of course, the total number of records divided by the number displayed on each page is the total number of pages. Of course, there are times when the division is inexhaustible. For example, the total number of records is 11 and 10 are displayed on each page. How many pages do we need to divide it into? Of course it's two pages. How can we make 11/10=2? -Obviously wrong, but real life is not perfect mathematics. Use the ceil function. This was mentioned in the previous chapter, so I won’t go into detail here.
Look what we have now:
代码如下 | 复制代码 |
总记录数,$numRecord = mysql_num_rows(mysql_query($sql)); 总页数,$totalpage = ceil($numRecord/$pagesize); |
We have nothing missing, except how to display "previous page, next page". It's very simple, just two judgments. Look at lines 159-163 of index.php:
Line 160:
代码如下 | 复制代码 |
if($page>0) echo "上一页|" ; |
If the variable $page>0, that is, the current page number is greater than 0, indicating that there is a previous page, then the "previous page" link will be displayed. The $page in this link needs to be reduced by one, for example, the current page is 2 , then of course the previous page is 1, right? When we click on the previous page, page=1 will be passed along with this link. This method of passing variables based on the link is the get method. This returns to line 8 and line 9 of the program for processing.
In line 161, our judgment is that if the current page number is less than the total number of records -1 - because our page number starts from 0, the total number of records must be subtracted by one to make the judgment realistic. If this judgment is true, it means that there is the next page. Of course, $page will be increased by one on the next page.
That’s it for the entire paging. Just remember how to get the total number of records, how to add the limit keyword to the sql statement, and how to determine whether to display the previous or next page. Everything is ok
Complete code
The code is as follows
|
Copy code | |||||||||
if(isset($_GET['page'])&&$_GET['page']!='') $page=$_GET['page'];
else $page=0; $sql = "SELECT a . * , b.name, b.email, b.qq, c.revert_time, c.revert
FROM post a
LEFT JOIN revert c ON ( a.id = c.post_id ) , guest b
WHERE a.guest_id = b.id
ORDER BY a.id DESC";
$numRecord = mysql_num_rows(mysql_query($sql));
$totalpage = ceil($numRecord/$pagesize); $recordSql = $sql. " LIMIT ".$page*$pagesize.",".$pagesize;
$result = mysql_query($recordSql);
Message from:name?> |Email:email?>|QQ: php echo $rs->qq?>|Message time:post_time+8*3600)?> |
reply | Delete |
Message content: post))?> Reply content:revert))?>[revert_time!="") echo date("Y-m-d H:i: s",$rs->revert_time+8*3600)?> ] |
if($page>0) echo "Previous page|" ; if($page<$totalpage-1) echo "Next page" ; ?> |

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











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,

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.
