在前面的两篇随笔中我已经写完发布动态、评论动态、回复评论、以及删除评论等,那么在这节随笔中我们来看一下如何做出回复再回复,也就是循环回复的功能,在这节随笔中我会将完整的评论,回复评论,回复再回复功能展现一遍,
还是老样子,先说一下思路:
(1)对动态进行评论
(2)对评论给予回复
(3)回复该回复,然后就是循环回复
到上一篇随笔为止,qqpinglun和qqhuifu的数据库内容是这样的:
但是这样会出现问题:qqhuifu表中的cid,ids,和qqpinglun表中的cid会有重复的时候,这样就造成了不知道是回复的评论还是该回复!!
解决方法如下:
将qqpinglun的cid(最初是int型,自动递增,主键)换成不同的(varchar,主键);修改后效果图如下:
之前的代码都一样,唯一不同的代码是:
pl-cl.php之前的页面:
<?php require "../DB.class.php"; $db = new DB(); session_start(); $uid = $_SESSION["uid"]; $plnr = $_POST["plnr"]; $dtid = $_POST["plid"]; $time = date("Y-m-d H:i:s", time()); $sql = "insert into qqpinglun values ('','{$dtid}','{$uid}','{$plnr}','{$time}')"; $db->query($sql,0); ?>
pl-cl.php现在的页面:
<?php require "../DB.class.php"; $db = new DB(); session_start(); $uid = $_SESSION["uid"]; $plnr = $_POST["plnr"]; $dtid = $_POST["plid"]; $time = date("Y-m-d H:i:s", time());
//多出的部分 $yCode = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J'); $cc = $yCode[intval(date('Y')) - 2011] . strtoupper(dechex(date('m'))) . date('d') . substr(time(), -5); $sql = "insert into qqpinglun values ('{$cc}','{$dtid}','{$uid}','{$plnr}','{$time}')"; $db->query($sql,0); ?>
改完这一步之后,让我们继续往下走:(我会将评论,回复,再回复的代码重新付上,看过前两篇的可以之间看再回复的代码(我会特别标注)~~)
第一步:评论
(1)评论模态框代码
<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 nr" cols="70px"></textarea> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="button" class="btn btn-primary plnr" code="<?php echo $v[0]; ?>"> 发表评论 </button> </div> </div> </div> </div>
(2)将评论内容写进数据库代码:
$(".pl").click(function(){ var code = $(".pl").attr("code"); $('#myModal').modal('show'); }) $(".plnr").click(function(){ var nr = $(".nr").val(); var c = $(this).attr("code"); var code = $(".pl").attr("code"); $.ajax({ url:"qt-pl-cl.php", data:{bkid:c,nr:nr}, type:"POST", dataType:"TEXT", success: function(data){ alert("评论成功!"); window.location.href="qt-gwc.php?bkid="+code; } }) })
如果数据成功写进数据库,则返回评论成功!效果图如下:
(3)从数据库读取内容:
<?php $bkid = $_GET["bkid"]; $sql2 = "select * from pinglun where bkid='{$bkid}'"; $arr2 = $db->query($sql2); foreach($arr2 as $m) { $yh = $m[1]; $sql3 = "select * from users where uid='{$yh}'"; $arr3 = $db->query($sql3); echo "<div style='height:50px; border-bottom:1px solid gray;margin-left:20px' > <div class='touxiang'> <img src='{$arr3[0][6]}' height='50px' width='50px'></div> <span style='line-height:70px'>{$arr3[0][2]}发表评论:</span></div> <div style='1000px;margin-left:30px; font-size:17px;height:70px;padding-top:30px' >{$m[3]}</div> <div style='1000px;margin-left:600px; font-size:13px ;height:30px;' >评论时间:{$m[4]} <button type='button' class='btn btn-primary huifu' ids='{$m[0]}'>回复</button> <button type='button' class='btn btn-danger scpl' code='{$m[0]}' fplz='{$m[1]}' onclick="return confirm('确认删除么?')" >删除</button></div> "; } ?>
显示效果:
第二步:回复
(1)回复模态框代码:
<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="70px"></textarea> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="button" class="btn btn-primary hfnr" >提交回复</button> </div> </div> </div> </div>
(2)将回复内容写进数据库
var ids=""; $(".huifu").click(function(){ ids = $(this).attr("ids"); $('#mM').modal('show'); }) $(".hfnr").click(function(){ var hfnr = $(".hfpl").val(); var code = $(".pl").attr("code"); $.ajax({ url:"qt-hf-cl.php", data:{ids:ids,nr:hfnr,bkid:code}, type:"POST", dataType:"TEXT", success: function(data){ alert("回复成功!"); window.location.href="qt-gwc.php?bkid="+code; } }) })
如果成功写入,则返回回复成功!
(3)从数据库读取内容:
<?php $bkid = $_GET["bkid"]; $sql4 = "select * from huifu where bkid='{$bkid}' and plid in (select plid from pinglun)"; $arr4= $db->query($sql4); foreach($arr4 as $n) { $yh = $n[3]; $sql5 = "select * from users where uid='{$yh}'"; $arr5 = $db->query($sql5); $plid=$n[2]; $sql6 = "select * from pinglun where plid='{$plid}'"; $arr6 = $db->query($sql6); //取被回复的xingming $sql7 = "select name from users where uid='{$arr6[0][1]}'"; $name = $db->strquery($sql7); echo "<div style='font-size:15px;height:50px;border-bottom:1px solid grey;margin-left:50px''> <div class='touxiang'> <img src='{$arr5[0][6]}' height='50px' width='50px'></div> <span style='line-height:70px'>{$arr5[0][2]}回复{$name}的评论:{$arr6[0][3]}</span></div> <div style='1000px;margin-left:70px;height:80px;padding-top:30px; font-size:17px' >{$n[4]}</div> <div style='1000px;margin-left:600px; font-size:13px'>回复时间:{$n[5]} <button type='button' class='btn btn-primary zhf' zhfid='{$n[0]}'>回复</button> <button type='button' class='btn btn-danger schf' bbb='{$n[0]}' aaa='{$n[3]}' onclick="return confirm('确认删除么?')" >删除</button></div> "; } ?>
效果如下:
第三步:再回复
(1)再回复模态框
<div class="modal fade" id="zmM" 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 zhfpl" cols="70px"></textarea> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="button" class="btn btn-primary zhftj" >回复</button> </div> </div> </div> </div>
(2)将再回复内容写进数据库:
var ids=""; $(".huifu").click(function(){ ids = $(this).attr("ids"); // alert(ids); $('#mM').modal('show'); }) $(".hfnr").click(function(){ var hfnr = $(".hfpl").val(); var code = $(".pl").attr("code"); // alert(hfnr); // alert(code); $.ajax({ url:"qt-hf-cl.php", data:{ids:ids,nr:hfnr,bkid:code}, type:"POST", dataType:"TEXT", success: function(data){ // alert(data); alert("回复成功!"); window.location.href="qt-gwc.php?bkid="+code; } }) })
如果写进数据库成功,那么返回回复成功1
(3)从数据库读取代码
<?php $bkid = $_GET["bkid"]; // echo $bkid; $sql8 = "select * from huifu where bkid='{$bkid}' and plid in (select hfid from huifu)"; $arr8= $db->query($sql8); // var_dump($arr8); foreach($arr8 as $f) { $yh = $f[3]; $sql9 = "select * from users where uid='{$yh}'"; $arr9 = $db->query($sql9); // var_dump($arr3); $plid=$f[2]; // echo $plid; $sql10 = "select * from huifu where hfid='{$plid}'"; $arr10 = $db->query($sql10); // var_dump($arr10[0][4]); //取被回复的xingming $sql7 = "select name from users where uid='{$arr10[0][3]}'"; $name = $db->strquery($sql7); // echo $name; echo "<div style='font-size:15px;height:50px;border-bottom:1px solid grey;margin-left:50px''> <div class='touxiang'> <img src='{$arr9[0][6]}' height='50px' width='50px'></div> <span style='line-height:70px'>{$arr9[0][2]}回复{$name}的回复:{$arr10[0][4]}</span></div> <div style='1000px;margin-left:70px;height:80px;padding-top:30px; font-size:17px' >{$f[4]}</div> <div style='1000px;margin-left:600px; font-size:13px'>回复时间:{$f[5]} <button type='button' class='btn btn-primary zhf' zhfid='{$f[0]}'>回复</button> <button type='button' class='btn btn-danger sczhf' ccc='{$f[0]}' ddd='{$f[3]}' onclick="return confirm('确认删除么?')" >删除</button></div> "; } ?>
效果图如下:
来验证一下是否能够循环回复:(用发布时间来看顺序,没有调顺序)
到这个地方我们就已经实现了循环回复的功能了,在这个地方我用的都是同一个账号回复,大家写完之后可以换不同的账号来实现~~~
就不附上完整的代码了,因为在上面两篇随笔中这一功能我没实现,就直接在项目里实现了,所以附上完整的会有点乱~~