search

Home  >  Article  >  Backend Development  >  PHP paging principle simple paging code summary

PHP paging principle simple paging code summary

WBOY
WBOYOriginal
2016-07-25 08:52:511000browse

  3. //Determine how many items are displayed on each page

  4. //count(*) Query the total number of items
  5. //Calculate the total number of pages ceil()
  6. //Judge $_GET and assign the current page number
  7. //mysql query limit (current page number-1)*number of items per page, number of items per page
  8. //If the total number of items is not empty, loop mysql_fetch_array()
  9. //$_SERVER['PHP_SELF']
  10. //Previous page?page=Current page-1
  11. //Next page?page=Current page+1
  12. //edit: bbs.it-home.org
  13. include("conn.php" );
  14. $perpagenum = 3;
  15. $total = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM message"));
  16. $Total = $total[0];
  17. $Totalpage =ceil($Total/$perpagenum) ;

  18. if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage ){

  19. $page = 1;
  20. }else{
  21. $page = $_GET['page'];
  22. }

  23. $start = ($page-1)*$perpagenum;

  24. $sql = "SELECT * FROM message ORDER BY id DESC LIMIT $start,$perpagenum";
  25. $result = mysql_query($sql);
  26. $contents = mysql_fetch_array($result);
  27. ?>
  30. if($total){
  31. do{
  32. $user = $contents['user'];
  33. $contact = $contents['contact'];
  34. $content = $contents['content'];
  35. $date = $contents['date'];

  36. ?>

  38. < ;td width="193" height="22">Nickname:
  45. }
  46. //php paging starts
  47. while($contents=mysql_fetch_array($result));
  48. $per = $page-1;
  49. $next= $page+1;
  50. echo "
    Total".$ Total." comments, ".$perpagenum." messages per page, total ".$page."/".$Totalpage." pages. ";
  51. if($page!=1){
  52. echo "Homepage".
  53. "Previous page";
  54. }
  55. if($page!=$Totalpage){
  56. echo "Next page";
  57. echo "Last page";
  58. }
  59. ?>
  60. }
  61. ?>
  62. Posted in:

Copy code


Statement：
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
Previous article：PHP ninety-nine multiplication table implementation codeNext article：PHP ninety-nine multiplication table implementation code

Related articles

See more