include("conn/conn.php"); //包含conn.php文件 if (isset($_GET['page'])){ $page=$_GET['page']; }else{ $page=1; }?> if($page){ $page_size=4; //每页显示4条记录 $query="select * from tb_news"; //定义查询语句 $result=mysql_query($query); //执行查询操作 $message_count=mysql_num_rows($result); //获取查询总数 $page_count=ceil($message_count/$page_size); //获取总的页数 $offset=($page-1)*$page_size; $query="select * from tb_user where id order by id desc limit $offset, $page_size"; $result=mysql_query($query); } ?>
