PHP 分页(limit)

来源：互联网发布：战斗妖精雪风小说淘宝编辑：程序博客网时间：2024/06/08 16:58
SQL语句的 limit 功能实现。
<?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><?phpwhile($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>
阅读全文
0 0