php-分页实例
1
<?
2
$query_string='cateid='.$cateid;
3
$sql="select id,title,author,nowtime,view_times from companynews where cate=$cateid and subcate=3 order by id desc";
4
$dblink->query($sql);
5
$num=$dblink->num_rows();
6
$rec_num=$num;
7
$rec_per_page=30;
8
if(isset($_GET["page"]) && floor($_GET["page"])>0)
9
{
10
$page=floor(trim($_GET["page"]));
11
}
12
else
13
{
14
$page=1;
15
}
16
if(ceil($num/$rec_per_page)>=$page)
17
{
18
$start=$rec_per_page*($page-1);
19
}
20
else
21
{
22
$page=1;
23
$start=0;
24
}
25
if($num>$page*$rec_per_page)
26
{
27
$this_page_count=$rec_per_page;
28
}
29
else
30
{
31
$this_page_count=$num-($page-1)*$rec_per_page;
32
}
33
if($num==0)
34
{
35
?>
36
<tr>
37
<td colspan="5" height="50"><b><font color="#FF0000">对不起,数据库中暂时没有公司动态信息!</font></b></td>
38
</tr>
39
40
<?}
41
else
42
{?>
43
<tr bgcolor="#DDDDDD">
44
<td height="30" align="center" width="40" nowrap>序号</td>
45
<td >主题</td>
46
<td width="60">来源</td>
47
<td width="80">发布时间</td>
48
<td align="center" width="0"> </td>
49
</tr>
50
<?
51
for($i=0;$i<$num;$i++)
52
{
53
$article_data=$dblink->next_record();
54
if($i<$start || $i>=$start+$this_page_count)
55
{
56
continue;
57
}
58![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
59
?>
60
<tr bgcolor="#EFEFEF">
61
<td align="center" height="20" bgcolor="#EFEFEF"><?echo $i+1;?></td>
62
<td nowrap ><a href="article.php?id=<?echo trim($article_data["id"]);?>" title="<?echo trim($article_data["title"]);?>"><?echo csubstr(trim($article_data["title"]),0,70);?></a></td>
63
<td ><?echo trim($article_data["author"]);?></td>
64
<td nowrap><?echo trim($article_data["nowtime"]);?></td>
65
<td align="center"> </td>
66
</tr>
67
<?
68
}
69
}?>
70
<tr>
71
<td colspan="5" height="80"><b>
72
<?
73
echo "总共记录数目:<font color='#FF0000'><b>".$rec_num."</b></font>。
74
每页有<font color='#FF0000'><b>$rec_per_page</b></font>条记录。
75
共有<font color='#FF0000'><b>".ceil($rec_num/$rec_per_page)."</b></font>页。
76
当前是第<font color='#FF0000'><b>$page</b></font>页。<br><br>";
77
if($page==1)
78
{
79
echo "<font color='#CCCCCC'>第一页 上一页 </font>";
80
}
81
else
82
{
83
echo "<a href=\"$File_Name?page=1&$query_string\">第一页</a> "."<a href=\"$File_Name?page=".($page-1)."&$query_string\">上一页</a> ";
84
}
85
if($this_page_count!=$rec_per_page || $rec_num==$page*$rec_per_page)
86
{
87
echo "<font color='#CCCCCC'>下一页 最后一页</font>";
88
}
89
else
90
{
91
echo "<a href=\"$File_Name?page=".($page+1)."&$query_string\">下一页</a> "."<a href=\"$File_Name?page=".ceil($rec_num/$rec_per_page)."&$query_string\">最后一页</a>";
92
}
93
if(ceil($rec_num/$rec_per_page)>1)
94
{
95
echo "转到<input type='input' name='input_page' class='input' style='width:30' onKeyDown=\"if(window.event.keyCode==13){location.href='$File_Name?page='+input_page.value+'&$query_string'}\">页 <input type='button' name='go' value='GO' class='input' onClick=\"Javascript:location.href='$File_Name?page='+input_page.value+'&$query_string'\">";
96
}
97
?> </b></td>
![](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)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
92
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
93
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
94
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
95
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
96
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
97
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)