对于分页管理简单易懂快速的方法看这里哦.... 直接上代码
public function PageSel($table,$size){
$count = $this->pdo->query("SELECT * FROM ".$table)->rowCount(); //总数
$page = isset($_REQUEST['page']) ? $_REQUEST['page']: 1;
$tot=ceil($count/$size);
$offset = ($page - 1)* $size;
if($page -1 <= 1 ){
$pre=1;
}else{
$pre=$page -1;
}
if($page +1 >=$tot ){
$next=$tot;
}else{
$next=$page +1;
}
$data['sql']= $this->pdo->query(" SELECT *FROM ".$table." ORDER BY id DESC LIMIT ".$offset.", ".$size." ; ");
$data['pre']=$pre;
$data['next']=$next;
$data['page']=$page;
$data['tot']=$tot;
$data['count']=$count;
$data['size']=$size;
return $data;
exit;
}
Katen Doe
John Doe
Jan 08, 2021 14:41 pm对于分页管理简单易懂快速的方法看这里哦.... 直接上代码
public function PageSel($table,$size){ $count = $this->pdo->query("SELECT * FROM ".$table)->rowCount(); //总数 $page = isset($_REQUEST['page']) ? $_REQUEST['page']: 1; $tot=ceil($count/$size); $offset = ($page - 1)* $size; if($page -1 <= 1 ){ $pre=1; }else{ $pre=$page -1; } if($page +1 >=$tot ){ $next=$tot; }else{ $next=$page +1; } $data['sql']= $this->pdo->query(" SELECT *FROM ".$table." ORDER BY id DESC LIMIT ".$offset.", ".$size." ; "); $data['pre']=$pre; $data['next']=$next; $data['page']=$page; $data['tot']=$tot; $data['count']=$count; $data['size']=$size; return $data; exit; }
给他点赞