php简单分页原理与分页代码示例
时间：2021-07-01 10:21:17
帮助过：22人阅读
/*******分页原理*********/ - //每页显示记录条数
- $page_size = 3;
- $sql = "select * from message";
- $result = mysql_query($sql);
//总记录条数 - $num = mysql_num_rows($result);
- //总页面数量的计算
- if($num<=$page_size) { $page_count =1; }
- if($num%$page_size) { $page_count = intval($num/$page_size)+1 ;}
- if($num%$page_size==0) { $page_count = $num/$page_size ;}
-
- if( isset($_GET['page']) ){
- $page = intval($_GET['page']);
- }
- else{
- $page = 1;
- }
-
- $sql_page= "select * from message limit ".($page-1)*$page_size.",$page_size";
- $do = mysql_query($sql_page);
- while( $re = mysql_fetch_object($do)){
- echo '随便写点什么都行';
- }
-
- if($page<>1){
- echo '首页';
- echo '上一页';
- }
-
- if($page<>$page_count){
- echo '';
- echo '下一页';
- echo '最后一夜';
- echo '';
- }
|
