在前面的两篇随笔中我已经写完发布动态、评论动态、回复评论、以及删除评论等,那么在这节随笔中我们来看一下如何做出回复再回复,也就是循环回复的功能,在这节随笔中我会将完整的评论,回复评论,回复再回复功能展现一遍,
还是老样子,先说一下思路:
(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='width:1000px;margin-left:30px; font-size:17px;height:70px;padding-top:30px' >{$m[3]}</div><div style='width: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]}' οnclick=\"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='width:1000px;margin-left:70px;height:80px;padding-top:30px; font-size:17px' >{$n[4]}</div><div style='width: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]}' οnclick=\"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='width:1000px;margin-left:70px;height:80px;padding-top:30px; font-size:17px' >{$f[4]}</div><div style='width: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]}' οnclick=\"return confirm('确认删除么?')\" >删除</button></div>";}?>
效果图如下:
来验证一下是否能够循环回复:(用发布时间来看顺序,没有调顺序)
到这个地方我们就已经实现了循环回复的功能了,在这个地方我用的都是同一个账号回复,大家写完之后可以换不同的账号来实现~~~
就不附上完整的代码了,因为在上面两篇随笔中这一功能我没实现,就直接在项目里实现了,所以附上完整的会有点乱~~