PHP implements Baidu-like paging
This article mainly shares with you examples of how to implement Baidu-like paging in PHP. I hope it can help you. Let’s take a look at the renderings first.
Basic strategy
1, First, query the total number of records
2, Set the number displayed on each page and calculate the total number of pages
3, Add a get value num to represent which page is currently being accessed. If there is no get value for num, the default current page should be set to the first page!
4, Take a string to save the page number link. This string is also called the page number string!
5, When querying, you should use the limit clause for restriction (limit clause paging principle)
Complete Baidu-like paging function
Paging requirements
1, When the current page is the first 3 pages, the initial page displayed $startNum is 1, and the last page displayed $endNum is 5
2. When the current page is page 4, $startNum is 2, $endNum = $startNum +4. When the current page is page 5, $startNum is 3, and so on
3, the page number The starting position cannot exceed the total number of pages $pages – 4;
The code is as follows:
Code
//应该加载视图文件之前和提取帖子的结果集之前进行分页 //以下的代码都和分页相关 //(1)定义当前选中的页码数 $pageNum = isset($_GET['num'])?$_GET['num']: 1; //(2)定义每一页显示的记录数 $rowsPerPage = 5; //(3)查询总记录 $sql="select count(*) as sum frompublish"; $result = my_query($sql); $row = mysql_fetch_assoc($result); $rowCount = $row['sum'];//得到总记录数 //(4)计算总页数 $pages = ceil($rowCount/$rowsPerPage);//得到总页数 //(5)拼凑页码字符串 $strPage = '';//页码字符串 //拼凑出首页 $strPage .= "<ahref='./list_father.php?num=1'>首页</a>"; //拼凑出上一页 $preNum = $pageNum == 1 ? 1 : $pageNum-1; $strPage .= "<ahref='./list_father.php?num=$preNum'>上一页</a>"; //确定显示的初始页$startNum if($pageNum<=3){ $startNum= 1; }else{ $startNum= $pageNum - 2; } //确定显示的初始页$startNum的最大值 if($startNum > $pages- 4){ $startNum= $pages-4; } //防止页码出现复制 if($startNum<=1){ $startNum=1; } //确定显示的最后一页 $endNum $endNum=$startNum+4; //防止最后一页越界; if($endNum>=$pages){ //$endNum=$pageNum;//错误 $endNum=$pages; } //拼凑出中间的页码 for($i=$startNum;$i<=$endNum;$i++){ //如果$i刚好是选中的当前页,标红 if($i==$pageNum){ $strPage.= "<a href='./list_father.php?num=$i'><fontcolor='red'>$i</font></a>"; }else{ $strPage.= "<a href='./list_father.php?num=$i'>$i</a>"; } //$strPage.= "<a href='./list_father.php?num=$i'>$i</a>"; } /*for($i=1;$i<=$pages;$i++){ $strPage.= "<a href='./list_father.php?num=$i'>$i</a>"; }*/ ////拼凑出下一页 $nextNum = $pageNum == $pages ? $pages :$pageNum+1; $strPage .= "<a href='./list_father.php?num=$nextNum'>下一页</a>"; //拼凑出尾页 $strPage .= "<ahref='./list_father.php?num=$pages'>尾页</a>"; //提取帖子的结果集 $offset = $rowsPerPage*($pageNum-1); $sql="select * from publish left joinuser on pub_owner=user_name order by pub_time desc limit$offset,$rowsPerPage"; $result=my_query($sql);//得到了资源结果集
Related recommendations:
Share a JavaScript sample code that imitates Baidu paging function
PHP digital paging class code (imitation Baidu paging effect)
jQuery imitation Baidu paging footprint effect code_jquery
The above is the detailed content of PHP implements Baidu-like paging. For more information, please follow other related articles on the PHP Chinese website!

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,

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.

In PHP, you can effectively prevent CSRF attacks by using unpredictable tokens. Specific methods include: 1. Generate and embed CSRF tokens in the form; 2. Verify the validity of the token when processing the request.

In PHP8, match expressions are a new control structure that returns different results based on the value of the expression. 1) It is similar to a switch statement, but returns a value instead of an execution statement block. 2) The match expression is strictly compared (===), which improves security. 3) It avoids possible break omissions in switch statements and enhances the simplicity and readability of the code.

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.

The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.

PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.
