Home Backend Development PHP Tutorial Detailed explanation of paging program in php based on message board_PHP tutorial

Detailed explanation of paging program in php based on message board_PHP tutorial

Jul 13, 2016 pm 04:59 PM
php Pagination use principle based on us article yes message board program Detailed explanation

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
 代码如下 复制代码

$recordSql = $sql. ” LIMIT “.$page*$pagesize.”,”.$pagesize;

$recordSql = $sql. ” LIMIT “.$page*$pagesize.”,”.$pagesize;

The judgment of the variable $page is obtained in lines 8 and 9 of the program:
 代码如下 复制代码

if(isset($_GET['page'])&&$_GET['page']!=”) $page=$_GET['page'];
else $page=0;

The code is as follows Copy code

if(isset($_GET['page'])&&$_GET['page']!=”) $page=$_GET['page'];

else $page=0;

Of course you have also seen the $_GET['page'] variable which will be discussed below.
 代码如下 复制代码
$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));
What needs to be said is why do we add this limit after getting the total number of rows? It’s very simple. If we add this limit when we get the number of result records, our total number of rows will never be It's greater than 10, because after adding it, the maximum number of records he can return is 10, brother. ——This is obviously not in line with the actual situation. So we are executing:
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
 代码如下 复制代码

$pagesize = 10;//每一页显示多少留言记录
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);


while($rs=mysql_fetch_object($result)){
?>
 
   
 
  if(isset($_SESSION['login'])&&$_SESSION['login']){
?>
   
   
 
  }
?>
 
   
 
 
}
?>
留言人:name?> |Email:email?>|QQ:qq?>|留言时间:post_time+8*3600)?>
回复 | 删除
留言内容:post))?>

   
    回复内容:revert))?>[revert_time!="") echo date("Y-m-d H:i:s",$rs->revert_time+8*3600)?> ]
   

   
   


 
   
 

if($page>0) echo "上一页|" ;
if($page<$totalpage-1) echo "下一页" ;
?>

Copy code
$pagesize = 10;//How many message records are displayed on each page
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);
while($rs=mysql_fetch_object($result)){
?>



if(isset($_SESSION['login'])&&$_SESSION['login']){
?>



}
?>




}
?>
Message from:name?> |Email:email?>|QQ: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" ;
?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631302.htmlTechArticleThe article focuses on the paging principle in php, and we use an implementation to explain how to implement it in php Pagination, this is based on the square board program I wrote, friends in need...
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

Video Face Swap

Video Face Swap

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

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

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)

Hot Topics

Java Tutorial
1664
14
PHP Tutorial
1269
29
C# Tutorial
1248
24
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,

PHP Program to Count Vowels in a String PHP Program to Count Vowels in a String Feb 07, 2025 pm 12:12 PM

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

Explain late static binding in PHP (static::). Explain late static binding in PHP (static::). Apr 03, 2025 am 12:04 AM

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 PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases? What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases? Apr 03, 2025 am 12:03 AM

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: Comparing Two Popular Programming Languages PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM

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 in Action: Real-World Examples and Applications PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM

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: A Key Language for Web Development PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

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

The Enduring Relevance of PHP: Is It Still Alive? The Enduring Relevance of PHP: Is It Still Alive? Apr 14, 2025 am 12:12 AM

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.

See all articles