分页

mysqli.php

  
  

   
   <?php
$db=new mysqli();
$db->connect('localhost','root','root','test');
$sql="select count(*) from user";
$res=$db->query($sql); 
$row=$res->fetch_row();
$pg_size=3;
$pg_total=ceil($row[0]/$pg_size);//总页数
$pg_now=@$_GET['pg_now']?$_GET['pg_now']:1;
$pg_start=($pg_now-1)*$pg_size;
$sql="select * from user limit $pg_start,$pg_size";
$res=$db->query($sql);
$rows=$res->fetch_all(MYSQLI_ASSOC);
  
  
  
  


  
  
  
  

   
   
?>
<center>
<table width="400" border="1">
<tr bgcolor="#ccc"><th >ID</th><th>name</th><th>pass</th></tr>
<?php
foreach($rows as $key=>$v){
 echo "<tr>";
 echo "<td>{$v['id']}</td>";
 echo "<td>{$v['name']}</td>";
 echo "<td>{$v['pass']}</td>";
 echo "</tr>";
}
?>
</table>
<?php
echo "<h3>当前页：".$pg_now."  &nbsp;&nbsp;&nbsp;&nbsp;总页数：".$pg_total."</h3>";
echo "<h3>";
echo "<a href='mysqli.php?pg_now=1'>首页</a>  &nbsp;&nbsp;";
//上一页
if($pg_now>1){
 $pre_pg=$pg_now-1;
 
 echo "<a href='mysqli.php?pg_now=$pre_pg'><<</a>";
}
//循环显示页码
for($i=1;$i<=$pg_total;$i++){
 echo "<a href='mysqli.php?pg_now={$i}'>  {$i}  </a>";
}
  
  
  
  

   
   //下一页
if($pg_now<$pg_total){
 $next_pg=$pg_now+1;
 echo "&nbsp;&nbsp;<a href='mysqli.php?pg_now=$next_pg'>>></a>";
 
}
echo "&nbsp;&nbsp;<a href='mysqli.php?pg_now=$pg_total'>尾页</a>  ";
?>
</h3>
<h3>
<form action="mysqli.php" method='get'>
跳转到：<input type='text' name="pg_now">
<input type='submit' value="GO">
</form>
</h3>
</center>
  
  

效果如图：