PHP+MYSQL分页实现
<?php("Content-type:text/html;");
// 1、传入页码 $page = $_GET['p'];
// 2、根据页码取出数据
$pdo = new PDO('mysql:host=localhost;dbname=ceshi','root','root');
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES,false);
$sql = 'SELECT * FROM `goods` LIMIT :start,:offset';
$limit = ($page-1)*3;
$offset = 3;
$stmt = $pdo->prepare($sql);
$sqlnum = 'SELECT COUNT(*)FROM `goods`';
$stmtnum = $pdo->prepare($sqlnum);
$stmtnum->execute();
$num = $stmtnum->fetch(PDO::FETCH_ASSOC);
$stmt->bindParam(':start',$limit);
$stmt->bindParam(':offset',$offset);
if(!$stmt->execute()){
throw new Exception('查找失败',1);
}
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
($data);
// 3、显示数据+显示分页条
/**总页数**/
$end = ($num['COUNT(*)']/$offset)+1;
$page_banner ='<a href="'.$_SERVER['PHP_SELF'].'?p=1"> 首页</a>';
if($page <=1){
$page_banner .= '<a> 上一页</a>';
}else{
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($page -1).'"> 上一页</a>';
}
if($page+3>4){
$page_banner .= '...';
}
if(($page+4)>=$end){
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($end-3).'"> '.($end-3).'</a>';
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($end-2).'"> '.($end-2).'</a>';
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($end-1).'"> '.($end-1).'</a>';
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($end).'"> '.($end).'</a>';
}else{
for($i=0;$i<4;$i++){
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($page+$i).'"> '.($page+$i).'</a>';
}
}
if(($page+4)<$end){
$page_banner .= '...';
}
if($page <=$num['COUNT(*)']/$offset){
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.($page +1).'"> 下一页</a>';
}else{
$page_banner .='<a> 下一页</a>';
}
$page_banner .='<a href="'.$_SERVER['PHP_SELF'].'?p='.$end.'"> 尾页</a>';
$page_banner .='<span> 总共'.$end.'页</span> 当前第<span>'.$page."页</span>";
echo $page_banner;
?>
页:
[1]