本文实例讲述了PHP分页显示的方法。分享给大家供大家参考,具体如下:
<"content-type:text/html;charset=utf-8"); $currentpage = 1; if(isset($_GET['page'])) $currentpage = $_GET['page']; //连接数据库 $link = mysql_connect("localhost","root","") or die('连接失败'); mysql_select_db('myschool'); mysql_query('set names utf8'); $sql ="SELECT count(*) as 'count' from student";//查询记录的sql语句 $result = mysql_query($sql); $arr = mysql_fetch_array($result); $count = $arr['count']; $pagesize = 3; $pages = ceil($count/$pagesize);//共多少页 $prepage = $currentpage -1; if($prepage<=0) $prepage=1; $nextpage = $currentpage+1; if($nextpage >= $pages){ $nextpage = $pages; } $start =($currentpage-1) * $pagesize;//起始位置 $sql = "SELECT * from student limit $start,$pagesize"; echo $sql; // $sql = "select * from student"; $result = mysql_query($sql); "en"> <head> <meta charset="UTF-8"> <title>Document</title> </head> <body> <table border="1"> <tr> <td>学号</td> <td>姓名</td> <td>性别</td> <td>年龄</td> </tr> <"<" rel="external nofollow" >上一页</a> <a href="<" rel="external nofollow" >下一页</a> </body> </html>
注:当一个文件中有php和html两种时,php文件必须有结束标记
附:php通用分页类与用法:
Page.class.php文件:
<"'.$this->href.'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >首页</a>] </span>'; //如果当前页不是第一页就显示上页 if($this->currPage>1){ $_GET['page'] = $this->currPage-1; $pageStr.='<span>[<a href="'.$this->href.'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >上页</a>] </span>'; } foreach ($this->page_arr as $k => $v) { $_GET['page'] = $k; $pageStr.='<span>[<a href="'.$v.'" rel="external nofollow" >'.$k.'</a>] </span>'; } //如果当前页小于总页数就显示下一页 if($this->currPage<$this->countPages){ $_GET['page'] = $this->currPage+1; $pageStr.='<span>[<a href="'.$this->href.'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >下页</a>] </span>'; } $_GET['page'] = $this->countPages; $pageStr.='<span>[<a href="'.$this->href.'" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >尾页</a>] </span>'; return $pageStr; } /** * construct_Pages 生成页码数组 * 键为页码,值为链接 * $this->page_arr=Array( * [1] => index.php"htmlcode"><"content-type:text/html;charset=utf8"); include('Page.class.php'); //引入类 //$p=new Page(总条数,显示页数,当前页码,每页显示条数,[链接]); //连接不设置则为当前链接 $page=isset($_GET['page']) "<pre>"; print_r($p->getPages()); //样式 共45条记录,每页显示10条,当前第1/4页 [首页] [上页] [1] [2] [3] .. [下页] [尾页] echo $p->showPages(1);更多关于PHP相关内容感兴趣的读者可查看本站专题:《php+mysql数据库操作入门教程》、《php+mysqli数据库程序设计技巧总结》、《php面向对象程序设计入门教程》、《PHP数组(Array)操作技巧大全》、《php字符串(string)用法总结》、《PHP网络编程技巧总结》及《php常见数据库操作技巧汇总》
希望本文所述对大家PHP程序设计有所帮助。
标签:
PHP,分页,分页类
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件!
如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
桃源资源网 Design By www.nqtax.com
暂无“PHP分页显示的方法分析【附PHP通用分页类】”评论...