PHP PDO ACCESS 留言板-首页index.php

最新推荐文章于 2022-04-07 00:44:12 发布

Tango糖果π

最新推荐文章于 2022-04-07 00:44:12 发布

阅读量1.3k

点赞数

分类专栏： php 文章标签： php pdo access

本文链接：https://blog.csdn.net/mahaokun/article/details/51119812

版权

php 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

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>