mysql - 我想将普通的 mysql 查询转换为 codeigniter

Question

我想将普通的 mysql select 查询转换为 codeigniter

从 teacher_attendance 中选择 count(*) leave_status、teacher_id，其中 Teacher_id='1' & leave_status= “1”按 teacher_id

分组

这是我尝试过的

$attendance = $this->db->get_where('teacher_attendance', array('year' => $running_year, 'timestamp' => $timestamp, 'teacher_id' => $row['teacher_id']))->result_array();

我想要做的是通过教师id获取leave_status的计数

Answer 1

$this->db->select("count(*) as leave_status, teacher_id");
    $this->db->from("teacher_attendance");
    $this->db->where("teacher_id = 1 AND leave_status='1'");
    $this->db->group_by("teacher_id");
    $query = $this->db->get();       
    if ($query->num_rows() > 0) {
        $result = $query->result_array();
    }