php浏览数据分页-CSDN博客

本文链接：https://blog.csdn.net/ycydynq/article/details/147710995

会自动加载mysqli数据库操作类

https://blog.csdn.net/ycydynq/article/details/147660044?spm=1011.2415.3001.5331

<?php
   spl_autoload_register(function($class_name){
       require "./inc/{$class_name}.class.php";
   });

   //配置参数
$param=array(
     'host'=>"127.0.0.1",
     'user'=>'root',
     'pwd'=>'123456',
     'dbname'=>'datagoods'
);
//获取单例
$db=MYSQLDB::getInstance($param);
$pagesize=10;
/*
    $rowcount   总记录数
    $pagecount 总页数
    $pagecount=ceil($rowcount/$pagesize);
    获取总记录数
    select count(*) from products
*/
//第一步：获取总记录数
$rowcount=$db->fetchColumn('select count(*) from products');
//求出总页数
$pagecount=ceil($rowcount/$pagesize);
//获取当前页

if(empty($_GET)){
     $pageno=1;
}
else{
   $pageno=$_GET['page'];
   $pageno=$pageno<1?1:$pageno;
   $pageno=$pageno>$pagecount?$pagecount:$pageno;
}

$startno=($pageno-1)*$pagesize;
//获取当前页面数据，并遍历显示
//$list=$db->fetchAll("select * from products limit {$startno},{$pagesize}");
//分页优化
$list=$db->fetchAll("select * from products  where proid>=(select proid from products limit {$startno},1) limit {$pagesize}");
//echo "<pre>";
//var_dump($list);
?>
<table>
  <tr><td>编号</td>
     <td>名称</td>
     <td>规格</td>
     <td>价格</td>
     <td>库存</td>
     <td>网站</td>
</tr>
<?php
foreach($list as $k=>$v):
?>
<tr><td><?=$v['proID']?></td>
     <td><?=$v['proname']?></td>
     <td><?=$v['proguige']?></td>
     <td><?=$v['proprice']?></td>
     <td><?=$v['proamount']?></td>
     <td><?=$v['proweb']?></td>
</tr>
<?php
endforeach
?>
</table>
<?php

echo "<br/>";
//循环显示页码
?>
一共有<?=$rowcount?>条记录 每页放<?=$pagesize?>条数据，当前第<?=$pageno?>页<br/>
<a href="?page=1">首页</a>
<a href="?page=<?=$pageno-1?>">上一页</a>
<?php
for($i=1;$i<=$pagecount;$i++){
	echo "&nbsp;<a href='?page={$i}'> {$i} </a>&nbsp;";
}

?>

<a href="?page=<?=$pageno+1?>">下一页</a>
<a href="?page=<?=$pagecount?>">尾页</a>