Question : codeigniter where_not_in
Answered by : portapipe
$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
// Produces: WHERE username NOT IN ('Frank', 'Todd', 'James')
Source : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Wed, 04 Nov 20
Question : where_in codeigniter
Answered by : rafeek
$this->db->select('ae_users.employee_id, ae_users.emp_name, ae_users.emp_name2, ae_users.emp_name3'); $this->db->from('ae_users'); $this->db->where_in('ae_users.employee_id',$employee_ids); $query =$this->db->get(); if ($query->num_rows()) { return $query->result_array(); } else { return 0; }
Source : | Last Update : Wed, 23 Sep 20
Question : or where in codeigniter
Answered by : amreen-khan
->where('(library.available_until >=', date("Y-m-d H:i:s"), FALSE)
->or_where("library.available_until = '00-00-00 00:00:00')", NULL, FALSE)
Source : https://stackoverflow.com/questions/16498693/codeigniters-where-and-or-where | Last Update : Tue, 05 Apr 22