Home > Article > Backend Development > PHP paging (limit)
PHP paging (limit)
- 韦小宝Original
- 2017-12-02 13:14:0014884browse
PHP Pagination is very common in the project. This is a great benefit for students who are not familiar with pagination! This article explains PHP paging in detail, and also provides the source code of PHP paging!
Implementation of limit function of SQL statement.
<?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 style="padding:5px;"><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;
$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>The above is the source code and explanation of PHP paging. I hope it will be helpful to students in need!
Related recommendations:
implementation of php paging class
The implementation principle of php paging
A simple implementation of the simplest PHP paging code
The above is the detailed content of PHP paging (limit). For more information, please follow other related articles on the PHP Chinese website!