- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- <!--引入bootstrap的CSS文件-->
- <link type="text/css" rel="stylesheet" href="../bootstrap-3.3.7-dist/css/bootstrap.min.css" />
- <!--引入js包-->
- <script src="../jquery-3.2.0.js"></script>
- <!--引入bootstrap的js文件-->
- <script src="../bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
- <style>
- #body{
- height: auto;
- width: 1000px;
- margin: 0px auto;
- }
- #xdt{
- height: 200px;
- width:1000px;
- border: 1px solid cadetblue;
- }
- /*动态和评论div*/
- .fdt{
- position: relative;
- width: 1000px;
- }
- /*读取内容div*/
- #nr{
- width: 1000px;
- }
- /*谁发表动态样式*/
- .a{
- float: left;
- min-height:40px;
- width: 1000px;
- background-color: goldenrod;
- }
- /*姓名*/
- .xm{
- font-size: 18px;
- color: brown;
- font-weight: bold;
- }
- /*发表动态样式内容*/
- .b{
- float: left;
- text-align: left;
- height:100px;
- line-height: 50px;
- width: 100%;
- background-color: greenyellow;
- }
- /*发表时间与回复删除样式*/
- .c{
- height:30px;
- width: 800px;
- float: left;
- font-size: 12px;
- text-align:right;
- background-color: gainsboro;
- }
- /*弹出模态框评论框*/
- .d{
- height:30px;
- width: 200px;
- float: left;
- font-size: 15px;
- text-align:center;
- background-color: gainsboro;
- }
- /*读取评论div*/
- #dqpl{
- width: 1000px;
- }
- #dqhf
- {
- width: 1000px;
- }
- </style>
- </head>
- <body>
- <div id="body">
- <?php
- session_start();
- $uid = "";
- if(empty($_SESSION["uid"]))
- {
- header("location:login.php");
- exit;
- }
- $uid = $_SESSION["uid"];
- require "../DB.class.php";
- $db = new DB();
- $sql = "select name from qqusers where uid='{$uid}'";
- $name = $db->strquery($sql);
- //这种方法可以取到uid。
- echo "欢迎:"."<span class='qid' yh='{$uid}'>{$name}</span>";
- ?>
- <!--写动态-->
- <div id="xdt">
- <p>发表动态:</p>
- <textarea cols="100px" rows="5px" name="xdt" class="xdt"></textarea>
- <input type="submit" value="发表" id="fb" />
- </div>
- <!--动态内容结束-->
- <!--容纳动态内容-->
- <div class="fdt">
- <p style="color: brown; font-family: '微软雅黑';font-weight: bold;font-size: 20px; margin-bottom: 20px; margin-top: 20px;">朋友动态:<p>
- <!--读取动态内容-->
- <div id="nr">
- <?php
- $date = date ("Y-m-d H:i:s");
- $sql = "select * from qqdongtai where uid='{$uid}' or uid in (select uid from qqfriends where fname =(select name from qqusers where uid='{$uid}')) order by time desc";
- //echo $sql;
- $arr = $db->query($sql);
- // var_dump($arr);
- foreach($arr as $v)
- {
- $sql = "select name from qqusers where uid='{$v[1]}'";
- $name = $db->strquery($sql);
- if($v[1]==$uid)
- {
- $name = "我";
- }
- echo "<div class='a'><span class='xm'>{$name}</span>发表动态:</div>
- <div class='b'>{$v[2]}</div>
- <div class='c'>发表动态时间:{$v[3]}</div>
- <div class='d'><button class='btn btn-primary pl' data-toggle='modal' data-target='#myModal' code ='$v[0]'>评论</button>
- <span><a href='scdt-cl.php?code={$v[0]}'>删除动态</a></span></div>";
- }
- ?>
- </div>
- <!--读取评论内容-->
- <div id="dqpl">
- <?php
- $sql = "select * from qqpinglun";
- $arr = $db->query($sql);
- foreach($arr as $v)
- {
- $sql = "select * from qqdongtai where dtid='{$v[1]}'";
- $arr2 = $db->query($sql);
- foreach($arr2 as $m)
- {
- //取发动态的姓名
- $sql = "select name from qqusers where uid='{$v[2]}'";
- $name = $db->strquery($sql);
- //若果是登录者评论则显示"我"
- if($v[2]==$uid)
- {
- $name ="我";
- }
- //获取被评论者的姓名
- $sql = "select name from qqusers where uid=(select uid from qqdongtai where dtid='{$v[1]}')";
- $bpl = $db->strquery($sql);
- echo "<div class='a'><span class='xm'>{$name}</span>评论<span class='xm'>{$bpl}</span>的动态:{$m[2]}<div>
- <div class='b'>{$v[3]}</div>
- <div class='c'>发表评论时间:{$v[4]}</div>
- <div class='d'><button class='btn btn-primary hf' ids ='{$v[0]}'>回复
- </button><span><a href='scpl-cl.php?code={$v[0]}'>删除评论</a></span></div>";
- }
- }
- ?>
- </div>
- <!--读取回复的内容-->
- <div id="dqhf">
- <?php
- $sql = "select * from qqhuifu where cid in (select cid from qqpinglun)";
- $arr = $db->query($sql);
- // var_dump($arr);
- foreach($arr as $a)
- {
- $sql = "select * from qqpinglun where cid='{$a[1]}'";
- $arr2 = $db->query($sql);
- // var_dump($arr2);
- foreach($arr2 as $n)
- {
- //取评论动态的姓名
- $sql = "select name from qqusers where uid='{$a[2]}'";
- $name = $db->strquery($sql);
- //若果是登录者评论则显示"我"
- if($a[2]==$uid)
- {
- $name ="我";
- }
- //获取被回复评论的姓名
- $sql = "select name from qqusers where uid=(select uid from qqpinglun where cid='{$a[1]}')";
- $bpl = $db->strquery($sql);
- echo "<div class='a'><span class='xm'>{$name}</span>回复<span class='xm'>{$bpl}</span>的评论:{$n[3]}<div>
- <div class='b'>{$a[3]}</div>
- <div class='c'>回复时间:{$a[4]}</div>
- <div class='d'><button class='btn btn-primary hf' ids ='{$a[0]}'>回复
- </button><span><a href='schf-cl.php?code={$a[0]}'>删除回复</a></span></div>";
- }
- }
- ?>
- </div>
- </div>
- <!-- 评论模态框(Modal) -->
- <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
- <h4 class="modal-title" id="myModalLabel">评论</h4>
- </div>
- <textarea class="modal-body pldt" cols="80px"></textarea>
- <div class="modal-footer">
- <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
- <button type="button" class="btn btn-primary" id="tjpl">提交评论</button>
- </div>
- </div>
- </div>
- </div>
- <!--模态框结束-->
- <!-- 回复模态框(Modal) -->
- <div class="modal fade" id="mM" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
- <h4 class="modal-title" id="myModalLabel">回复</h4>
- </div>
- <textarea class="modal-body hfpl" cols="80px"></textarea>
- <div class="modal-footer">
- <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
- <button type="button" class="btn btn-primary" id="tjhf">提交回复</button>
- </div>
- </div>
- </div>
- </div>
- <!--模态框结束-->
- </div>
- </body>
- </html>
- <script>
- //ajax方法:刷新页面时将内容读取出来,并按发表时间读出来
- // $.ajax({
- // url:"sx-cl.php",
- // dataType:"TEXT",
- // success:function(data){
- // var hang = data.trim().split("|");
- // var str="";
- // for(var i=0;i<hang.length;i++)
- // {
- // var lie = hang[i].split("^");
- // str = str + "<div class='a'><span class='xm'>"+lie[1]+"</span>发表动态:</div><div class='b'><p>"+lie[2]+"</p><div class='c'>发表动态时间:"+lie[3]+"</div>";
- // str =str+"<div id='d'><button class='btn btn-primary pl' data-toggle='modal' data-target='#myModal' code ='"+lie[0]+"'>评论</button><span><a href='del.php?code="+lie[0]+"'>删除动态</a></span></div>";
- // }
- // $("#nr").html(str);
- // //点击"评论按钮"实现将code值传到模态框的"提交按钮"
- // //为什么放在此处:因为ajax是异步的,如果不放在此处会加不上点击事件
- // $(".pl").click(function(){
- // code = $(this).attr("code"); //将评论的id重新赋值
- // })
- // }
- // });
- //
- //php方法: 当发表动态时,将动态内容写进数据库,并刷新页面
- $("#fb").click(function(){
- var dt= $(".xdt").val();
- var uid = $(".qid").attr("yh");
- $.ajax({
- url:"main-cl.php",
- data:{dt:dt},
- type:"POST",
- dataType:"TEXT",
- success:function(data){
- alert("发表动态成功!");
- window.location.href="main.php";
- }
- });
- })
- //定义空字符串,容纳评论的id
- var code="";
- $(".pl").click(function(){
- code = $(this).attr("code"); //将评论的id重新赋值
- })
- //将评论写进数据库
- $("#tjpl").click(function(){
- var plnr = $(".pldt").val();
- var plid = code; //取发动态的id
- // alert(plnr);
- // alert(plid);
- $.ajax({
- url:"pl-cl.php",
- data:{plnr:plnr,plid:plid},
- type:"POST",
- dataType:"TEXT",
- success:function(data){
- alert("评论成功!");
- window.location.href="main.php";
- }
- });
- })
- //定义空字符串,容纳回复评论的id
- var ids="";
- $(".hf").click(function(){
- ids = $(this).attr("ids"); //将评论的id重新赋值
- // alert((ids));
- $('#mM').modal('show');
- })
- //将回复评论写进数据库
- $("#tjhf").click(function(){
- var hfnr = $(".hfpl").val();
- // alert(hfnr);
- // alert(ids);
- $.ajax({
- url:"hf-cl.php",
- data:{hfnr:hfnr,ids:ids},
- type:"POST",
- dataType:"TEXT",
- success:function(data){
- alert("回复成功!");
- window.location.href="main.php";
- }
- });
- })
- </script>
来源: http://www.cnblogs.com/chenguanai/p/6911284.html