Question : codeigniter 3 limit
Answered by : indonesia-people
// Produces: LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax)
$this->db->limit(10, 20);
$this->db->limit(10); // Produces: LIMIT 10
Source : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Sat, 11 Sep 21
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