Implementation of PHP background comments

This article mainly introduces the implementation of PHP background comments. It has a certain reference value. Now I share it with everyone. Friends in need can refer to it.

/**
    * 添加评论
    * content 评论内容
    * addtime 评论时间
    * uid  评论作品
    */
   public  function padd(){
       $param=input('param.');
       $param['pid']=session('tid');
       if(empty($param['uid'])){
           return json(['code'=>2,'message'=>'uid不能为空']);
       }
$data=db('comments')->insertGetId(['uid'=>$param['uid'],'content'=>$param['content'],'addtime'=>$param['addtime'],'pid'=>$param['pid']]);
       if($data){
           return json(['code'=>1,'message'=>'评论成功']);
       }else{
           return json(['code'=>2,'message'=>'评论失败']);
       }
   }
/**
    * 评论展示
    * uid   comments表
    * page  页数
    * num   条数
    */
   public function comment(){
       $param=input('param.');
       $param['pid']=session('tid');//用户id
       if(empty($param['page'])){
           $param['page']=1;
       }
if(empty($param['num'])){
           $param['num']=5;
       }
       if(empty($param['uid'])){
           return json(['code'=>2,'message'=>'uid不能为空']);
       }
$data=db('comments')->where('uid',$param['uid'])->page($param['page'],$param['num'])->select();
$commentslike=db('commentslike');
       $people=db('people');
       foreach ($data as $k=>$value) {
           //查看评论点赞表的状态
           $state=$commentslike->where(['pid'=>$param['pid'],'uid'=>$param['uid'],'cid'=>$value['data']])->value('state');
           if(empty($state)){
               $state = '还未点赞';
           }
           $data[$k]['state']=$state;
//获取评论人的手机号
           $people=$people->where('id',$value['pid'])->value('tel');
           $data[$k]['tel']=$people;

           //把二级评论添加到数组数据中
           if($value['rpid'] !== 0){
               // $r_pid = $commentslike->where(['id'=>$value['rpid']])->value('pid');
               $r_tel = $people->where('id',$value['rpid'])->value('tel');
               $data[$k]['r_tel'] = $r_tel;
           }else{
               $data[$k]['r_tel'] = '';
           }
}
       return json(['code'=>1,'data'=>$data]);
   }
/**
    * 评论点赞
    * uid  作品id
    */
   public function commentslike(){
      $param=input('param.');
      $param['pid']=session::get('tid');
if(empty($param['uid'])){
           return json(['code'=>2,'message'=>'uid不能为空']);
       }
       //判断该作品有没有评论
      $comments=db('comments')->where('uid',$param['uid'])->select();
      if(!empty($comments)){
           //判断他有没有点赞
           $data=db('commentslike')->where(['uid'=>$param['uid'],'pid'=>$param['pid'],'cid'=>$comments['id']])->find();
           if(empty($data)){
               $like=db('commentslike')->insertGetId(['uid'=>$param['uid'],'pid'=>$param['pid'],'cid'=>$comments['id'],$param['state']=>'点赞']);
               if($like){
                   return json(['code'=>1,'message'=>'点赞成功']);
               }else{
                   return json(['code'=>1,'message'=>'点赞失败']);
               }
           }else{
               if($data['state']=='取消点赞'){
                   $like=db('commentslike')->where(['uid'=>$param['uid'],'pid'=>$param['pid'],'cid'=>$comments['id']])->update([$param['state']=>'点赞']);
               }elseif($data['state']=='点赞'){
                   $like=db('commentslike')->where(['uid'=>$param['uid'],'pid'=>$param['pid'],'cid'=>$comments['id']])->update([$param['state']=>'取消点赞']);
               }
           }
}else{
           return json(['code'=>2,'message'=>'此作品还未评论']);
      }
   }
/**
    * 回复评论
    * uid 作品id
    * content  回复内容
    * cid   这条评论的id
    * uid 作品id  pid 评论人id  
    */
   public function reply(){
       $param['pid'] = session('tid');
       $param = input('param.');
       //被评论的id     $param['cid']
       $data = db('comments')->where(['id'=>$param['rid']])->find();
       if($data['rid'] !== 0){
           $param['rid'] = $data['rid'];//被回复人的pid.
       }
       $param['rid'] = $data['id'];//被回复人的pid.
$param['rpid'] = $data['pid'];
//评论内容  $param['content'] 
       //作品id  $param['uid']
       $param['addtime'] = date('Y-m-d H:i:s');
       $id = db('comments')->insertGetId(['uid'=>$param['uid'],'content'=>$param['content'],'addtime'=>$param['addtime'],'pid'=>$param['pid'],'rid'=>$param['rid']]);
       if($id){
           return json(['code'=>1,'messgae'=>'回复成功']);
       }else{
           return json(['code'=>2,'message'=>'回复失败']);
       }
   }

   /**
    * 查看二级评论
    * uid 作品id
    * rid   这条评论的id
    */
   public function GetRCommtens($value='')
   {
       $data = db('comments')->where(['rid'=>$param['rid']])->select();
   }

The above is the entire content of this article. I hope it will be helpful to you. Everyone’s learning is helpful. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

PHP uses Azure Storage Blob to upload files

Introduction to PHP background image upload works

The above is the detailed content of Implementation of PHP background comments. For more information, please follow other related articles on the PHP Chinese website!