国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 語言 > PHP > 正文

PHP+Mysql無刷新問答評論系統(源碼)

2024-05-04 23:53:50
字體:
來源:轉載
供稿:網友

自己寫的一個評論系統源碼分享給大家,包括有表情,還有評論機制。用戶名是隨機的

針對某一篇文章進行評論

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    }     $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原址:www.erdangjiade.com/js/816.html


注:相關教程知識閱讀請移步到PHP教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表

圖片精選

主站蜘蛛池模板: 海口市| 神木县| 罗城| 哈尔滨市| 张掖市| 寻乌县| 丰镇市| 华坪县| 秀山| 石首市| 阳山县| 镇平县| 寿光市| 象山县| 连南| 淅川县| 建水县| 义乌市| 三台县| 沅江市| 龙江县| 潮州市| 雷州市| 都安| 峨山| 乌兰浩特市| 郑州市| 徐水县| 九台市| 佛冈县| 吴江市| 灯塔市| 维西| 安泽县| 东方市| 泰州市| 无棣县| 萨迦县| 宝兴县| 平顶山市| 当阳市|