分页函数

来源:互联网 发布:东芝复印机网络店 编辑:程序博客网 时间:2024/06/05 07:03
<?phpfunction getList($table,$offset,$per_page){// $sql = 'select * from news';$sql = "select * from $table order by id desc limit $offset,$per_page";// print_r($sql);// die;$query = mysql_query($sql);// $row = mysql_fetch_assoc($query); // print_r($row);while($row = mysql_fetch_assoc($query) ){$rout[] = $row; }return $rout;}function page($table,$url,$cur_page=1,$per_page=3,$page_num = 5){//中间五页// 控制页码的数目,因此更改页码的循环,而且当前页要在中间,得到前后的页码数 固定页数/2的向下取整$floor_page = floor($page_num/2);   // echo $floor_page;  //  值为2$sql = "select count(*) as totle from $table";$query = mysql_query($sql);$row = mysql_fetch_assoc($query);// print_r($row);$totle = $row['totle'];$total_page = ceil($totle/$per_page);  //向上取整   总的页数$start_page = $cur_page - $floor_page;$end_page = $cur_page + $floor_page;if($start_page<1){$start_page = 1;$end_page  = $page_num;}if($end_page>$total_page){$end_page = $total_page;$start_page = $total_page - $page_num + 1;}if($total_page < $page_num){$start_page = 1;$end_page = $total_page;}$page = "";$page .= '<a href="'.$url.'&p=1" title="First Page">首页</a>';if($cur_page !=1){  $prev_page = $cur_page - 1;  $page .= '<a href="'.$url.'&p='.$prev_page.'" title="'.$prev_page.'">上一页</a>';  }for($i=$start_page;$i<=$end_page;$i++){ if($i == $cur_page ) {$page .= ' <a href="'.$url.'&p='.$i.'" class="number current" title="'.$i.'">'.$i.'</a> '; }else{$page .= ' <a href="'.$url.'&p='.$i.'" class="number" title="'.$i.'">'.$i.'</a> ';}}if($cur_page !=$total_page){ $next_page = $cur_page + 1; $page .= ' <a href="'.$url.'&p='.$next_page.'" title="'.$next_page.'">下一页</a>'; }$page .= '  <a href="'.$url.'&p='.$total_page.'" title="'.$total_page.'">尾页</a> ';return $page;}

0 0