doubanduo7620 2019-03-01 01:38
浏览 22

试图在CodeIgniter中制作一个喜欢不喜欢的按钮

In my most recent work, i'm making a Like/Dislike button.

But... When "dislike" is actioned, they don't reload the Select Query.

Here is my code:

public function likePost($status = null){
    $data = json_decode($this->input->raw_input_stream, true);

    $this->load->database();
    $query = $this->db->query("SELECT *, COUNT(posts_like.idPost) AS total_likes FROM posts_like WHERE idPost = " . $data['idPost'] . " AND idUser = " . $data['idUser'] . " GROUP BY posts_like.idPost;")->result_array();

    if($query){
        if($status != 'new'){
            $this->load->database();
            // $this->db->where('idPosts_like', $query[0]['idPosts_like']);
            // $this->db->delete('posts_like', array('idPosts_like', $query[0]['idPosts_like']));
            $this->db->query("DELETE FROM posts_like WHERE idPosts_like = " . $query[0]['idPosts_like'] . ";");
            $response = ['status' => true, 'results' => $query, 'messege' => 'deleted'];
        }else{
            $response = ['status' => true, 'results' => $query, 'messege' => 'liked'];
        }
    }else{
        $this->db->insert('posts_like', $data);
        $this->likePost($status = 'new');
    }
    header('Content-type: application/json');
    die(json_encode($response));
}

Anyone can help me? thanks alot!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 Revit2020下载问题
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大
    • ¥15 单片机无法进入HAL_TIM_PWM_PulseFinishedCallback回调函数
    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch