//包含连接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);?>
新闻管理列表页functionconfirmDel(id)
{//询问是否要删除
if(window.confirm("你确定要删除吗?"))
{//如果单击确定按钮,则跳转到del.php页面
location.href= "del.php?id="+id;
}
}
.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;}