CodeIgniter: How to use WHERE clause and OR clause

mysql select codeigniter where-clause

$where = "name='Joe' AND status='boss' OR status='active'";$this->db->where($where);

mysql select codeigniter where-clause

You can use or_where() for that - example from the CI docs:

$this->db->where('name !=', $name);$this->db->or_where('id >', $id); // Produces: WHERE name != 'Joe' OR id > 50

mysql select codeigniter where-clause

You can use this :

$this->db->select('*');$this->db->from('mytable');$this->db->where(name,'Joe');$bind = array('boss', 'active');$this->db->where_in('status', $bind);

CodeHunter