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

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

Steps

Source code

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;
}

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

Copy after login

• ##

  //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>";
   }
  }

  Copy after login

  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!