php - 在Codeigniter中使用自定义where子句

我的活跃记录是

$ql = $this->db->select('course_id')->from('tbl_course_choice')->where('course_id',$course_id)->get();

    if( $ql->num_rows() > 0 ) {
        $data = array(
        'teacher_name_1' => 'mehdi'
        );
        $this->db->where('teacher_name_1', NULL);
        $this->db->where('course_id', $course_id);
        $this->db->update('tbl_course_choice', $data);
    } else {
        $a = array(
            'course_id' => $course_id,
            'course_code' => $course_code,
            'course_title' => $course_title,
            'course_type' => $course_type,
            'credit_hours' => $credit_hours,
            'contact_hours' => $contact_hours,
            'section' => $section,
            'teacher' => $teacher,
            'pre_requisite' => $pre_requisite,
            'year' => $year,
            'semester' => $semester,
            'offering_year' => $offering_year,
            'offering_session' => $offering_session,
            'teacher_name_1' => $teacher_name_1


            );
        $this->db->insert('tbl_course_choice', $a);
    }

我需要检查字段是否为空，然后插入或更新，否则插入其他字段

    if {
    $this->db->where('teacher_name_1', NULL);
    $this->db->where('course_id', $course_id);
    $this->db->update('tbl_course_choice', $data);
}
elseif {
    $this->db->where('teacher_name_1', IS NOT NULL);
    $this->db->where('teacher_name_2', NULL);
    $this->db->where('course_id', $course_id);
    $this->db->update('tbl_course_choice', $data);
}

我该如何检查是否为null，然后插入或更新。任何人都可以帮助我吗？

最佳答案

使用自定义字符串

$this->db->where('teacher_name_1 IS NULL', NULL, FALSE);

关于php - 在Codeigniter中使用自定义where子句，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/22679423/