Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

PHP paging code and paging principle small example

WBOY
Release： 2016-07-25 08:52:50
Original
1080 people have browsed it
  2. if ($_get['count']) {
  3. $count = $_get['count'];
  4. } else {
  5. $count =select count(*) from tablename where …..
  6. }
Copy the code

If only the first page is calculated and the subsequent pages are not used, will this improve efficiency? There is another situation, that is, in the case of fuzzy query, there is an application. I estimate that most of the query results are less than 20, that is, there is only one page of results, so it is unnecessary to calculate the total number, and it is fuzzy. Query efficiency is also relatively low. So I suddenly thought of jumping out of the original thinking, why do we have to calculate the total number of rows first and then get the list?

You can query the list first. If the number of list results = 20, then query the total number of rows, because if it is less than 20, there is actually only one page. The total number of rows is equal to the number of list results found. The pseudo code is:

  2. if ($_get['page']<2) {
  3. $list = select * from tablename where … limit 0,20 Directly query the first 20 items on the first page
  4. if (count($list )=20) {
  5. $count =select count(*) from tablename where …..
  6. } else {
  7. $count =count($list);
  8. }
  9. } else {
  10. $count = $_get['count' ];
  11. $list = select * from tablename where … limit page-1*20,page-1*20+20
  12. }
Copy code


Related labels：
php分页代码与分页原理小例子
source：php.cn
Previous article：PHP verification code PHP non-preset image generates verification code Next article：PHP ninety-nine multiplication table implementation code
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1914
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2088
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1756
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1656
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1666
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template