php实现简单的分布显示

        $page=$_GET["page"];  //计算分页显示

/////////////////////////////////////////////////////////////////////////////////////  if($page==""){  $page=1;  }  if(is_numeric($page)){    $page_size=8;  $query="select * from tb_d order by id desc";  $result=mysqli_query($conn,$query);  //记录总数  $message_count=mysqli_num_rows($result);    //多少页  $page_count=ceil($message_count/$page_size);    //从第几页显示  $offset=($page-1)*$page_size;  echo "page: ".$page."|"."message_count: ".$message_count."|"."page_count: ".$page_count."|"."offset: ".$offset;   }

//limit sql语句从第几页开始，每页显示多少条

 $sqlquery="select * from tb_data order by id asc limit $offset,$page_size";

html显示部分

<table><tr> <td>页次:<?php echo $page;?>/<?php echo $page_count;?>页&nbsp;记录:<?php echo $message_count;?>条&nbsp;</td> <td> <?php if($_GET['page']!=1){   echo "<a href=chanpin-query.php?page=1>首页</a>&nbsp";   echo "<a href='chanpin-query.php?page=".($page-1)."'>上一页</a>"; }  if($page<$page_count){    echo "<a href='chanpin-query.php?page=".($page+1)."'>下一页</a>";     echo "<a href='chanpin-query.php?page=".$page_count."'>尾页</a>";  } ?> </td></tr></table>