yii2 使用mysql ,实现点赞功能

来源：互联网发布：热化学数据库建库情况编辑：程序博客网时间：2024/06/07 23:47
    /**     *进行点赞     */    public function actionLike(){        Yii::$app->response->format=Response::FORMAT_JSON;        $data = @json_decode(file_get_contents("php://input","r"),true);        $topic_id=$data['topic_id'];        $like = new LikeLog();        if(Yii::$app->request->isGet){            return [                'msg'=>'Request Error!',                'state'=>(int)-1,            ];        }        $result=$like->apiLike($topic_id);        if ($result && Yii::$app->cache->exists($topic_id)){            return [                'msg'=>'ok',                'state'=>(int)0,                'likes'=>(int)Yii::$app->cache->get($topic_id),            ];        }else{            $data=self::likes($topic_id);            if (!empty($like->error)){                $data['msg']=$like->error;            }            return $data;        }    }    /**     *获取点赞条数     */    public function actionGetlikes(){        Yii::$app->response->format=Response::FORMAT_JSON;        if (Yii::$app->request->isPost){            return [                'msg'=>'Request Error!',                'state'=>(int)-1,            ];        }        $topic_id=Yii::$app->request->get('topic_id');        if (Yii::$app->cache->exists($topic_id)){            $likes=Yii::$app->cache->get($topic_id);            return [                'msg'=>'ok',                'state'=>(int)0,                'likes'=>$likes,//                'from'=>'cache',            ];        }else{            return self::likes($topic_id);        }    }    private static function likes($topic_id){        $content=MediaCloudContent::find()->where(['topic_id'=>$topic_id])->select(['topic_id','likes'])->asArray()->one();        if (!$content){            return [                'msg'=>'话题不存在',                'state'=>'-1',            ];        }        Yii::$app->cache->set($topic_id,(int)$content['likes']);        return [            'msg'=>'ok',            'state'=>(int)0,            'likes'=>$content['likes'],//                'from'=>'sql',        ];    } public function apiLike($topic_id){        $content=MediaCloudContent::find()->where(['topic_id'=>$topic_id])->select(['topic_id','likes'])->asArray()->one();        if (empty($content)){            $this->error='话题不存在！';            return false;        }        $r = $this->findOne(['topic_id'=>$topic_id,'ip'=>Yii::$app->request->getUserIP()],'created desc');        if ($r && time()-($r->created) < 10){            $this->error='两次点赞间隔不能低于10秒';            return false;        }else{            $transaction=Yii::$app->db->beginTransaction();            try{                $this->topic_id = $topic_id;                $this->save();                //锁定行                $sql="select likes from {{%mediacloud_content}} where topic_id='$topic_id' for update";                $data=Yii::$app->db->createCommand($sql)->query()->read();                $sql="update {{%mediacloud_content}} set likes=likes+1 where topic_id='$topic_id'";                Yii::$app->db->createCommand($sql)->execute();                $transaction->commit();                Yii::$app->cache->set($topic_id,$data['likes']+1);            }catch (Exception $e){                Yii::error($e->getMessage());                $this->error=json_encode($e->getMessage());                $transaction->rollBack();                return false;            }        }        return true;    }
阅读全文
0 0