php分頁原理，php分頁
<?php
//包含連接MySQL的文件
include "conn.php";
//分頁的相關變量
$pagesize = 5; //每頁顯示條數
//獲取地址欄中傳遞的page參數
if(empty($_GET["page"]))
{
$page = 1;
$startrow = 0;
}else
{
$page = (int)$_GET["page"];
$startrow = ($page-1)*$pagesize;
}
//構建查詢的SQL語句
$sql = "SELECT * FROM 007_news";
//執行SQL語句
$result = mysql_query($sql);
//總記錄數和總頁數
$records = mysql_num_rows($result); //總記錄數
$pages = ceil($records/$pagesize); //總頁數
//構建分頁的SQL語句
$sql = "SELECT * FROM 007_news ORDER BY orderby ASC,id DESC LIMIT $startrow,$pagesize";
//執行SQL語句
$result = mysql_query($sql);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>新聞管理列表頁</title>
<script type="text/javascript">
function confirmDel(id)
{
//詢問是否要刪除
if(window.confirm("你確定要刪除嗎？"))
{
//如果單擊確定按鈕，則跳轉到del.php頁面
location.href = "del.php?id="+id;
}
}
</script>
<style type="text/css">
.pagelist{
height:40px;
line-height:40px;
}
.pagelist a{
border:1px solid #ccc;
background-color:#f0f0f0;
padding:3px 10px;
margin:0px 3px;
}
.pagelist span{padding:3px 10px;}
</style>
</head>
<body>
<div ><input type="button" value="添加新聞" onclick="javascript:location.href='add.php'"></div>
<table width="100%" border="1" bordercolor="#ccc" rules="all" cellpadding="5" align="center">
<tr bgColor="#e0e0e0">
<th>編號</th>
<th>新聞標題</th>
<th>作者</th>
<th>來源</th>
<th>排序</th>
<th>點擊率</th>
<th>發布日期</th>
<th>操作選項</th>
</tr>
<?php
while($arr = mysql_fetch_assoc($result)){
?>
<tr align="center">
<td><?php echo $arr['id']?></td>
<td align="left"><a target="_blank" href="content.php?id=<?php echo $arr['id']?>"><?php echo $arr['title']?></a></td>
<td><?php echo $arr['author']?></td>
<td><?php echo $arr['source']?></td>
<td><?php echo $arr['orderby']?></td>
<td><?php echo $arr['hits']?></td>
<td><?php echo date("Y-m-d H:i",$arr['addate'])?></td>
<td>
<a href="edit.php?id=<?php echo $arr['id']?>">修改</a> |
<a href="javascript:void(0)" onClick="confirmDel(<?php echo $arr['id']?>)">刪除</a>
</td>
</tr>
<?php }?>
<tr>
<td colspan="8" align="center" class="pagelist">
<?php
$prev = $page-3; //$prev當前頁-3
$next = $page+3;
if($prev<1){
$prev = 1;
}
if($next>$pages){
$next=$pages;
}
for($i=$prev;$i<=$next;$i++)
{
//如果是當前頁，則不加鏈接
if($i==$page){
echo "<span>$i</span>";
}else{
echo "<a href='manage.php?page=$i'>$i</a>";
}
}
?>
</td>
</tr>
</table>
</body>
</html>
