Codeigniter get_where在条件数组中带有'或'

Question

Im trying to get values of 'yrlvl' with 11 or 1112 values but i cant get it whit this line of code:

$this->db->order_by('id', 'DESC');
        $query = $this->db->get_where('subjects', array('strand' => 'GAS', 'yrlvl' => '11'or '1112'));
        return $query->result_array();

I'm only getting the 1112 value someone help please.

Answer 1

Here are some possible solutions:

Solution 1:

$this->db->select('*');
$this->db->from('subjects');
$this->db->where('strand', 'GAS');
$where = '(yrlvl = "11" or yrlvl = "1112")'; // make a OR statement by passing values here
$this->db->where($where);
$this->db->order_by('id', 'DESC');
$query = $this->db->get();
return $query->result_array();

Solution 2:

$this->db->select('*');
$this->db->from('subjects');
$this->db->where('strand', 'GAS');
$where = array('11', '1112'); // make an array of values for OR condition
$this->db->where_in('yrlvl', $where);
$this->db->order_by('id', 'DESC');
$query = $this->db->get();
return $query->result_array();