How to implement paging navigation ideas with PHP and MYSQL

This article mainly introduces the detailed explanation of the paging navigation ideas of PHP and MYSQL. It is very good and has reference value. Friends in need can refer to it

Expected effect

#Ideas

Through SQL statement

SELECT * FROM table LIMIT start end To pass from MySql database

Steps

Enter page number p;

Get data based on page number php->mysql

Display data paging bar

Source code

github link

Note

##The styles of table, input, button and other controls will not be inherited body needs to be redefined as follows

input,label, select,option,textarea,button,fieldset,legend,table{
font-size:18px;
FONT-FAMILY:verdana;
}

##When splicing the query database language, after the LIMIT keyword Spaces must be left, and the spliced ​​content must be wrapped in brackets

$sql= "SELECT * FROM pages LIMIT ".(($page-1)*5).",5";

When the page is displayed, the author The logic is relatively complex and can be simplified and sorted out

• ##

  //1，主要是$total_pages > $show_page，特殊情况再另外考虑；
  //2，再利用for循环显示全部；
  //3，再考虑前面的省略号
  if($total_pages>$show_page){
   //考虑正常情况下，...456...下一页 尾页
   if($page-$page_off> 1) 
  $page_banner.="...";
  $start=$page-$page_off;
   //非正常情况下，12...下一页 尾页
   if($start== 0)
  $start= 1;
  $end=$page+$page_off;
   //...78 总共8页
   if($end>$total_pages)
  $end=$total_pages;
   for($i=$start;$i<=$end;$i++){
   //当前页显示高亮
   if($page==$i){
  $page_banner.="<span class=&#39;current&#39;>$i</span>";
   }else{
  $page_banner.="<a href=&#39;".$_SERVER[&#39;PHP_SELF&#39;]."?p=".$i."&#39;>{$i}</a>";
   }
   }
   if($page+$page_off<$total_pages)
  $page_banner.="...";
   //显示尾页与下一页
   if($page<$total_pages){
  $page_banner.="<a href=&#39;".$_SERVER[&#39;PHP_SELF&#39;]."?p=".($page+1)."&#39;>下一页></a>";
  $page_banner.="<a href=&#39;".$_SERVER[&#39;PHP_SELF&#39;]."?p=".($total_pages)."&#39;>尾页</a>";
   }else{
  $page_banner.="<span class=&#39;disable&#39;>下一页></span>";
  $page_banner.="<span class=&#39;disable&#39;>尾页</span>";
   }
  }

  Final effect

  The above is the entire content of this article, I hope it will be helpful to everyone's study.

  

  Related recommendations: Examples of PDO transaction processing operations in

  
  

  PHP

  
  PHP

  PDO transaction processing operation example

  
  PHP

  Simple method of parsing xml into an array

  
  

  The above is the detailed content of How to implement paging navigation ideas with PHP and MYSQL. For more information, please follow other related articles on the PHP Chinese website!