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 '<pre>'; print_r($this->db->last_query());exit;
if ($query->num_rows()) {
return $query->result_array();
} else {
return 0;
}$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;
}
Also in PHP:
- Multi-idiomas com PHP
- artisan config cache clear
- phpunit/phpunit[9.3.3, ..., 9.5.x-dev] require ext-dom * -> it is missing from your system. Install or enable PHP's dom extension. - Root composer.json requires phpunit/phpunit ^9.3.3 -> satisfiable by phpunit/phpunit[9.3.3, ..., 9.5.x-dev].
- database seeder laravel 8
- Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
- check array for duplicate values php
- catch exception php
- cache set in laravel
- enable errors in php
- blade Keep input values after failed validation
- conole.log in php
- How do you clear cache in Laravel?
- catch an exception within a catch block php
- database seeding laravel
- cache clear in laravel live server
- create new laravel project composer
- capitalized string in php
- contains the symbol php
- console .log in php
- echo php console
- create laravel 5.8 project using composer
- catch error php
- check if string has character php
- cache clear in laravel command