PHP分页实现
实现结果看图:
代码不详细解说了,注释里有
![](https://www.cnblogs.com/images/cnblogs_com/shaoyun/php_fengye.gif)
代码不详细解说了,注释里有
1
<?php
2
//page当前页,num每页的页数
3
$page=isset($_GET['page'])?intval($_GET['page']):1;
4
$num=5;
5![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
$conn = mysql_connect('127.0.0.1','root','');
7
if (!$conn) {
8
die('Could not connect:'.mysql_error());
9
}
10
mysql_select_db('shop');
11
//获取记录总数
12
$total=mysql_num_rows(mysql_query("select * from user"));
13
//计算页数
14
$pagenum=ceil($total/$num);
15
//限制页数不能超出范围
16
If($page>$pagenum || $page == 0){
17
Echo 'Error : Can Not Found The page.';
18
Exit;
19
}
20
//语句“Select * from table limit 0,10”从table表提取十条信息,0为起点,10为提取的数目
21
//$offset为起点值,如当前页为第一页,每页5条,起点即为0,同理当前为第二页,起点将为5
22
$offset=($page-1)*$num;
23
$result=mysql_query("select * from user limit $offset,$num");
24
While($it=mysql_fetch_array($result)){
25
Echo 'id:'.$it['id'].' name:'.$it['name'].'<br />';
26
}
27
//显示链接页面切换链接,当前页无链接
28
For($i=1;$i<=$pagenum;$i++){
29
$show=($i!=$page)?"<a href='index.php?page=".$i."'>$i</a>":"<b>$i</b>";
30
Echo $show." ";
31
}
32
echo $total.'条记录,每页5条,共'.$pagenum.'页';
33
mysql_free_result($result);
34
mysql_close($conn);
35
?>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)