index.php
<?php
session_start();
if($_SESSION['username']==""){
Header("Location: login.php");
}
//注销登陆
//session_unset();
//session_destroy();
?>
<?php include "inc.php"; ?>
<?php
$pageNo = 1; /**页码**/
$pageSize = 10; /**页大小**/
$pageCount = 0; /**共多少页**/
$totalNum = 0; /**总记录数**/
$pageNo = $_REQUEST["page"];
if(empty($pageNo)){
$pageNo = 1;
}
if(!is_numeric($pageNo)){
$pageNo = 1;
}
if($pageNo<1){
$pageNo = 1;
}
$pageNo = intval($pageNo);
$sql = "select count(*) as totalNum from Messages";
$rs = $conn->query($sql);
$row = $rs->fetch();
$totalNum = $row["totalNum"];
$pageCount = intval($totalNum/$pageSize);
if($totalNum%$pageSize>0){
$pageCount = $pageCount+1;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>留言板首页</title>
</head>
<body>
<h3><a href="index.php">留言板首页</a></h3>
<h3><a href="editMessage.php">给我留言</a> <a href="loginout.php">退出</a></h3>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="5%">留言编号</td>
<td width="10%">留言人</td>
<td width="15%">留言标题</td>
<td width="5%">留言时间</td>
<td width="20%">留言内容</td>
<?php
if($_SESSION['purview']=="83"){
echo "<td width='8%'>操作</td>";
}
?>
</tr>
<?php
if($pageNo==1){
$sql = "select top ".$pageSize." * from Messages order by MessageID desc";
}
else{
$sql = "select top ".$pageSize." * from Messages where MessageID not in(select top ".($pageNo-1)*$pageSize." MessageID from Messages order by MessageID desc) order by MessageID desc";
}
$rs = $conn->query($sql);
while($row=$rs->fetch()){
//foreach ($conn->query($sql) as $row){
?>
<tr>
<td><?php echo $row["MessageID"] ?></td>
<td><?php echo $row["MessageName"] ?></td>
<td><a href="<?php echo $row["HtmlUrl"] ?>" target="_blank"><?php echo $row["MessageTitle"] ?></a></td>
<td><?php echo date("Y-m-d",strtotime($row["MessageUpdateTime"])) ?></td>
<td><?php echo $row["MessageContent"] ?></td>
<?php
if($_SESSION['purview']=="83"){
echo "<td>";
echo "<a href='editMessage.php?Opt=1&MessageID=".$row["MessageID"]."'>编辑</a> | " ;
echo "<a href='deleteMessage.php?MessageID=".$row["MessageID"]."' onclick='return IsDel();'>删除</a> | ";
if(empty($row["HtmlUrl"])){
echo "<a href='maketohtml.php?MessageID=".$row["MessageID"]."&page=".$pageNo."'>生成HTML</a>";
}
else{
echo "<a href='maketohtml.php?MessageID=".$row["MessageID"]."&page=".$pageNo."'>重新生成</a>";
}
echo "</td>";
}
?>
</tr>
<?php
}
?>
</table>
<script type="text/javascript">
function IsDel(){
if(!confirm("确定删除吗?")){
return false;
}
}
</script>
<p>
<?php
function iif($arg_1,$arg_2,$arg_3){
if($arg_1){
return $arg_2;
}
else{
return $arg_3;
}
}
?>
<a href="index.php?page=1">首页</a>
<a href="index.php?page=<?php echo iif($pageNo<=1,1,$pageNo-1); ?>">上一页</a>
<a href="index.php?page=<?php echo iif($pageNo>=$pageCount,$pageCount,$pageNo+1); ?>">下一页</a>
<a href="index.php?page=<?php echo $pageCount ?>">尾页</a>
</p>
</body>
</html>