php分页的实现
Jun 14, 2016 am 12:01 AM
phpcodePaginationaccomplishOpen sourceprogrammingprogramming languagesoftware development
php常见分页有3种,一种是文字分页,比如说上一页,下一页之类的,还有一种数字分页,像1,2,3...之类的,这个比较简单,前者稍微复杂些.最后一种是他们2者结合.
下面是代码:
1 //获取当前页数
2 if(isset($_GET['page'])){
3 $page = intval($_GET['page']);
4 }
5 else {
6 $page=1;
7 }
8 $PageSize = 1; //每页的记录数量
9 // 获取总数量
10 $sql = "select count(*) from blog";
11 $result = mysql_query($sql);
12 $row = mysql_fetch_row($result);
13 $amount = $row[0];
14 /*计算总页数
15 if($amount){
16 if($amount 17 $PageCount = 1;
18 }
19 if($amount%$PageSize) { //总数量除以每页的记录数量取于
20 $PageCount =& amp;nbsp;(int)($amount/$PageSize)+1;//如果有于,则页数等于总数量除每页的记录数加1
21 }
22 else{
23 $PageCount =& amp;nbsp;$amount/$PageSize;//没有,则结果是页数
24 }
25 }
26 else{
27 $PageCount = 0;
28 }*/
29 $PageCount = ceil($amount/$PageSize);//总页数=总数量除以每页数量 如果有小树,则进位
30 if($Page>$PageCount|$page==0){// 如果当前页数大于总页数
31 echo "不能发现此页!";
32 exit();
33 }
34
35 //翻页链接
36 $PageOut = '';
37 if($page==1){//如果页数只有一页
38 $PageOut .= '第一页|上一页';
39 }
40 else{
41 $PageOut .= '第一页& lt;/a>|'.($page-1).'">上一页|';
42 }
43 if($page==$PageCount||$PageCount==0){//如果当前页等于总也数
44 $PageOut .= '下一页|尾页';
45 }
46 else{
47 $PageOut .= ''.($page+1).'">下一 页|'.$PageCount.'">尾页';
48 }
49 //获取数据
50 if($amount){
51 $sql="select * from blog limit ".($page-1)*($PageSize).",$PageSize";
52 $result=mysql_query($sql);
53 while($row=mysql_fetch_array($result)){//此段代码只是示例
54 $blogs[] = array('bid'=>$row['bid'],'title'=>$row['title']);
55 foreach ($blogs as $blog){
56 $title=$blog['title'];
57 }
58 $output = "$blog[bid]>删除".
59 "$blog[bid]>编辑".
60 "$blog[bid]>查看";
61 include("template/default/blog.tpl.php");
62 echo $PageOut;
63 }
64 for($i=1;$i$PageCount;$i++){//数字分页
65 $Pageshow = ($i!=$page)?"".$i."'>$i":"$i";
66 echo $PageShow;
67 }
68 echo $amount.'条记录,每页'.$PageSize.'条,共'.$PageCount.'页';
69 }
2 if(isset($_GET['page'])){
3 $page = intval($_GET['page']);
4 }
5 else {
6 $page=1;
7 }
8 $PageSize = 1; //每页的记录数量
9 // 获取总数量
10 $sql = "select count(*) from blog";
11 $result = mysql_query($sql);
12 $row = mysql_fetch_row($result);
13 $amount = $row[0];
14 /*计算总页数
15 if($amount){
16 if($amount 17 $PageCount = 1;
18 }
19 if($amount%$PageSize) { //总数量除以每页的记录数量取于
20 $PageCount =& amp;nbsp;(int)($amount/$PageSize)+1;//如果有于,则页数等于总数量除每页的记录数加1
21 }
22 else{
23 $PageCount =& amp;nbsp;$amount/$PageSize;//没有,则结果是页数
24 }
25 }
26 else{
27 $PageCount = 0;
28 }*/
29 $PageCount = ceil($amount/$PageSize);//总页数=总数量除以每页数量 如果有小树,则进位
30 if($Page>$PageCount|$page==0){// 如果当前页数大于总页数
31 echo "不能发现此页!";
32 exit();
33 }
34
35 //翻页链接
36 $PageOut = '';
37 if($page==1){//如果页数只有一页
38 $PageOut .= '第一页|上一页';
39 }
40 else{
41 $PageOut .= '第一页& lt;/a>|'.($page-1).'">上一页|';
42 }
43 if($page==$PageCount||$PageCount==0){//如果当前页等于总也数
44 $PageOut .= '下一页|尾页';
45 }
46 else{
47 $PageOut .= ''.($page+1).'">下一 页|'.$PageCount.'">尾页';
48 }
49 //获取数据
50 if($amount){
51 $sql="select * from blog limit ".($page-1)*($PageSize).",$PageSize";
52 $result=mysql_query($sql);
53 while($row=mysql_fetch_array($result)){//此段代码只是示例
54 $blogs[] = array('bid'=>$row['bid'],'title'=>$row['title']);
55 foreach ($blogs as $blog){
56 $title=$blog['title'];
57 }
58 $output = "$blog[bid]>删除".
59 "$blog[bid]>编辑".
60 "$blog[bid]>查看";
61 include("template/default/blog.tpl.php");
62 echo $PageOut;
63 }
64 for($i=1;$i$PageCount;$i++){//数字分页
65 $Pageshow = ($i!=$page)?"".$i."'>$i":"$i";
66 echo $PageShow;
67 }
68 echo $amount.'条记录,每页'.$PageSize.'条,共'.$PageCount.'页';
69 }
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article
What's New in Windows 11 KB5054979 & How to Fix Update Issues
3 weeks agoByDDD
How to fix KB5055523 fails to install in Windows 11?
2 weeks agoByDDD
InZoi: How To Apply To School And University
4 weeks agoByDDD
How to fix KB5055518 fails to install in Windows 10?
2 weeks agoByDDD
Roblox: Dead Rails – How To Summon And Defeat Nikola Tesla
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Atom editor mac version download
The most popular open source editor

WebStorm Mac version
Useful JavaScript development tools
