PHP+Mysql无刷新问答评论系统(源码)

自己写的一个评论系统源码分享给大家，包括有表情，还有评论机制。用户名是随机的

针对某一篇文章进行评论

functionsubcomment(){

$data['uid']=getUserid();

$data['mtype']=I("post.mtype",0,'int');

if($data['uid']==''){

echojson_encode(array("code"=>-1));

}else{

$content=addslashes(str_replace("","<br/>",$_POST['content']));

$data['tid']=I("post.id",0,'int');//文章id

if(strlen(preg_replace('/[[^)]+?]/x','',$content))<10){

echojson_encode(array("code"=>"shortthan10","error"=>"评论的内容不能少于10个字符。"));

exit;

}

if(C("DB_PWD")!=''){

if(time()-session("comment_time")<60&&session("comment_time")>0){//2分钟以后发布

echojson_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($emotsas$v){

$content=str_replace("[".$v['name']."]","<imgalt='".$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']){

echojson_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']."ANDaddtimebetween".$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());

echojson_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();

}

切换评论分页