时间:2021-05-26
自己写的一个评论系统源码分享给大家,包括有表情,还有评论机制。用户名是随机的
针对某一篇文章进行评论
function subcomment() { $data['uid'] = getUserid(); $data['mtype'] = I("post.mtype", 0, 'int'); if ($data['uid'] == '') { echo json_encode(array("code" => -1)); } else { $content = addslashes(str_replace("\n", "<br />", $_POST['content'])); $data['tid'] = I("post.id", 0, 'int'); //文章id if (strlen(preg_replace('/\[ [^\)]+? \]/x', '', $content)) < 10) { echo json_encode(array("code" => "short than 10", "error" => "评论的内容不能少于10个字符。")); exit; } if (C("DB_PWD") != '') { if (time() - session("comment_time") < 60 && session("comment_time") > 0) {//2分钟以后发布 echo json_encode(array("code" => "fast", "error" => "您提交评论的速度太快了,请稍后再发表评论。")); exit; } } $data['pid'] = I("post.pid", 0, 'int'); $data['pid_sub'] = I("post.pid_sub", 0, 'int'); $lyid = $data['pid_sub'] > 0 ? $data['pid_sub'] : $data['pid']; if ($lyid > 0) { $lyinfo = M("comment")->field("uid")->where("id='" . $lyid . "'")->find(); $data['touid'] = $lyinfo['uid']; } else { $data['touid'] = 2; } $data['addtime'] = time(); $emots = getTableFile("emot"); foreach ($emots as $v) { $content = str_replace("[" . $v['name'] . "]", "<img alt='" . $v['name'] . "' src='" . __APP__ . "/Public/emot/" . ($v['id'] - 1) . ".gif'>", $content); } $data['content'] = addslashes($content); $info = M("comment")->field("id")->where("content='" . $data['content'] . "'")->find(); if ($info['id']) { echo json_encode(array("code" => "comment_repeat", "error" => "检测到重复评论,您似乎提交过这条评论了")); exit; } $lastid = M("comment")->add($data); $points_comment = 20; if ($lastid > 0) { $day_start = strtotime(date("Y-m-d")); $day_end = $day_start + 3600 * 24; $comment_num_day = M("comment")->where("uid = " . $data['uid'] . " AND addtime between " . $day_start . " AND " . $day_end . "")->count(); if ($comment_num_day <= 5) { //少于5条每天,则添加积分 // addPoints("comment", $points_comment, $data['uid'], "评论获得" . $points_comment . "积分", 5, 1); } // addMessage('comment', $data['tid'], $data['pid'], $data['mtype'], $data['touid'], $content); } session("comment_time", time()); echo json_encode(array("code" => 200, "comment" => $content, "points" => $points_comment)); } }根据分页参数获取对应评论列表
function comments() { $id = I("get.id", 0, 'int'); $mtype = I("get.mtype", 1, 'int'); $page = I("get.page", 1, "int"); $totalnum = I("get.totalnum", 1, "int"); $start = 10 * ($page - 1); $sql = "tid = " . $id . " AND pid = 0"; $comments = M("comment")->field("id,uid,content,addtime")->where($sql)->order("id DESC")->limit($start . ",10")->select(); // echo M("comment")->getlastsql(); foreach ($comments as $k => $v) { $comments[$k]['sub'] = M("comment")->field("id,uid,content,pid_sub")->where("tid = " . $id . " AND pid = " . $v['id'] . "")->order("id ASC")->select(); } $this->assign("id", $id); $this->assign("mtype", $mtype); $this->assign("comments", $comments); $this->assign("comments_num", $totalnum - ($page - 1) * 10); $this->display(); }切换评论分页
if ($("#detail-page").length > 0) { var id = $("#detail-page").attr("data-id"); var mtype = $("#detail-page").attr("data-mtype"); var totalnum = $("#detail-page").attr("data-totalnum"); $("#detail-page").children("a").click(function() { var page = parseInt($(this).attr("data-page")); $("#detail-page").children("a").removeClass("current"); $("#detail-page").children("a").eq(page - 1).addClass("current"); $("#comment_list").html("<div style='padding:20px 0;text-align:center;'><img src='" + site_url + "Public/images/loading.gif'></div>"); $.get(getUrl("Box/comments"), { page: page, id: id, totalnum: totalnum, mtype: mtype }, function(data) { $("#comment_list").html(data) }) }) }评论表和表情表已放在压缩包里
CREATE TABLE IF NOT EXISTS `sucai_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `touid` int(11) DEFAULT '0', `pid_sub` int(11) DEFAULT '0', `tid` int(11) NOT NULL, `pid` int(11) DEFAULT '0', `mtype` tinyint(1) NOT NULL, `content` text NOT NULL, `addtime` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5560 ;功能实现和demo原址:/js/816.html
声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。
前言:在PHP+MySQL架构的站点中,本文重点从MySQL的角度去分析如何使Discuz!论坛(或者类似的PHP+MySQL架构的程序)应对大访问量。同时给出
系统运行环境EmpireCMS系统是一套采用PHP+MySQL数据库方式运行的开放源代码软件程序,所需要的环境是:PHP,MySQL数据库,环境所需要的程序均为
虚拟主机管理系统对比DirectAdminWebsitepanelCpanel安装环境LINUXWindows2008R2Linux空间类型PHP+MYSQL全
本文介绍了一款无刷新的新闻留言系统,最简明易懂的一个ajax无刷新留言系统,源码中省略了接受数据验证的过程,大家可根据自己的需求进行扩展,下面进入主题。核心源码
本文实例总结了PHP+MySQL存储数据常见中文乱码问题。分享给大家供大家参考,具体如下:PHP+MySQL出现中文乱码的常见原因:1.MYSQL数据库的编码是