master

分支 (1)

管理

管理

master

PHP-Web
/
leavemsg.php

<?php
header("Content-Type: text/html;charset=utf-8");
include "php/link.php";
session_start();
if (isset ( $_SESSION ["username"]) && isset ( $_SESSION ["userid"])){
    $userid = $_SESSION["userid"];
    $username = $_SESSION["username"];
    $usrid = $_GET['usrid'];
    if($userid==$usrid){
        echo "<script>parent.location.href='message.php'; </script>";
    }
} else {
    echo "<script>alert('您还未登录,不能查看用户信息');parent.location.href='login.php'; </script>";
}
?>
<!doctype html>
<html>
<head>
    <meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
    <title>
    </title>
    <meta name="keywords" content="" />
    <meta name="description" content="" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="css/base.css" rel="stylesheet">
    <link href="css/index.css" rel="stylesheet">
    <link href="css/info.css" rel="stylesheet">
    <link href="css/m.css" rel="stylesheet">
    <script src="js/jquery.min.js" type="text/javascript"></script>
    <script type="text/javascript" src="js/hc-sticky.js"></script>
    <script type="text/javascript" src="js/comm.js"></script>
    <!--[if lt IE 9]><script src="js/modernizr.js"></script><![endif]-->
</head>
<body>
<header class="header-navigation" id="header">
    <nav><div class="logo"><a href="index.php">KaiX</a></div>
        <h2 id="mnavh"><span class="navicon"></span></h2>
        <ul id="starlist">
            <li><a href="index.php">首页</a></li>
            <li><a href="search.php">搜索</a></li>
            <li><a href="publish.php">发表</a></li>
            <!--li><a href="follow.php">Fellow</a></li-->
            <!--li><a href="profile.php">个人主页</a></li-->
            <li><a href="message.php">消息</a></li>
        </ul>
    </nav>
</header>
<article>
    <aside>
        <div class="l_box" id="stickMe">
            <div class="about_me">
                <?php
                $sql_usr = "select UsrId,UsrName,UsrImage,UsrSignature,UsrSex,UsrAge,UsrPrvn,UsrCity,UsrQQ,UsrTel,UsrMail from Usr where UsrId = '$usrid'";
                $result = $link->query($sql_usr);
                list($usrId,$usrName,$usrImage,$usrSign,$usrSex,$usrAge,$usrPrvn,$usrCity,$usrQQ,$usrTel,$usrMail) = $result->fetch_row();
                $sql_usr_usr = "select UsrId,FollowId from UsrUsr where UsrId = '$userid' and FollowId = '$usrid'";
                //echo "$sql_usr_usr";
                $result = $link->query($sql_usr_usr);
                echo "<h2>个人信息";
                if($result->fetch_row()){
                    echo "<a href='php/follow_off.php?usrid=$usrid' style='float: right;'>已关注&nbsp;&nbsp;&nbsp;&nbsp;</a>";
                } else {
                    echo "<a href='php/follow_on.php?usrid=$usrid' style='float: right;'>关注&nbsp;&nbsp;&nbsp;&nbsp;</a>";
                }
                echo "</h2><ul><b>
                         昵&nbsp;&nbsp;称：$usrName<br>
                         性&nbsp;&nbsp;别：男<br>
                         年&nbsp;&nbsp;龄：$usrAge<br>
                         签&nbsp;&nbsp;名：$usrSign<br><br>
                         城&nbsp;&nbsp;市：新乡<br>
                         Q&nbsp;Q&nbsp;&nbsp;：$usrQQ<br>
                         电&nbsp;&nbsp;话：$usrTel<br>
                         邮&nbsp;&nbsp;箱：$usrMail<br>
                         </b></ul>";
                ?>
            </div>
            <div class="tuijian">
                    <?php
                    echo "<h2> $usrName 的文章</h2><ul>";
                    $sql_blog = "select BlogId,BlogTitle from Blog where UsrId = '$userid' order by BlogDate desc ";
                    $result = $link ->query($sql_blog);
                    while(list ($id,$Title) = $result->fetch_row()){
                        echo "<li><a href=blog.php?blog=$id>$Title</a></li>";
                    }
                    ?>
                </ul>
            </div>
        </div>
    </aside>
    <div class="r_box">
        <?php
        echo "<li><form method=\"post\" action=\"php/add_msg.php?usrid=$usrid\">";
        ?>
                <input type="text" name="leavemsg" >
                <input type="submit" value="留言">
            </form>
        </li>
        <?php
        $sql_msg = <<<GOD
select LvMsgId,LvMsgCont,UsrId,UsrName,LvMsgDate,LvMsgTime
from Usr,LeaveMsg
where UsrId = LvMsgFrom and LvMsgFrom and LvMsgTo = '$usrid'
order by LvMsgDate desc ,LvMsgTime desc ;
GOD;
        $result = $link->query($sql_msg);
        while(list ($msgid,$content,$usrid,$usrname,$cmtdate,$cmttime) = $result->fetch_row()){
            echo "<li><h1><a href='leavemsg.php?usrid=$usrid'>$usrname</a></h1>";
            echo "&nbsp;&nbsp;$content<br>$cmtdate&nbsp;&nbsp;$cmttime";
            if($username==$usrname){
                echo "<a href='php/delect_leavemsg.php?id=$msgid' style='float: right;'>删除</a></li>";
            }
        }
        ?>
    </div>
</article>
<footer>
    <p>Copyright &copy;2018 &nbsp;<a href="http://zhangkaixuan.cn">KaiXuan</a></p>
</footer>
<a href="#" class="cd-top">Top</a>
</body>
</html>