codeigniter 3 query builder code example
Example 1: codeigniter where order by
$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);
$this->db->_protect_identifiers = FALSE; // stop CI adding backticks
$order = sprintf('FIELD(ae_users.employee_id, %s)', implode(', ', $employee_ids));
$this->db->order_by($order);
$this->db->_protect_identifiers = TRUE;
$query =$this->db->get();
// echo ''; print_r($this->db->last_query());exit;
if ($query->num_rows()) {
return $query->result_array();
} else {
return 0;
}
Example 2: query builder codeigniter
$this->db->set('name', $name);
$this->db->set('title', $title);
$this->db->set('status', $status);
$this->db->insert('mytable');
Example 3: codeigniter 4 query builder select
$builder->select('title, content, date');
$query = $builder->get();
// Executes: SELECT title, content, date FROM mytable