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 : codeigniter query builder order by
Answered by : oliver-weitman
$this->db->order_by('title', 'DESC');
// Produces: ORDER BY `title` DESCSource : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Mon, 28 Dec 20
Question : cideigniter orLike()
Answered by : sameh-shahin
$this->db->like('title', 'match'); $this->db->or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR `body` LIKE '%match%' ESCAPE '!'Source : https://codeigniter.com/userguide3/database/query_builder.html | Last Update : Tue, 27 Oct 20
Question : order by in codeigniter query builder
Answered by : ankur-prajapati
$this->db->order_by('RegisteredUserID','ASC')
// Produces: ORDER BY `RegisteredUserID` ASC
$this->db->order_by('RegisteredUserID','DESC')
// Produces: ORDER BY `RegisteredUserID` DESCSource : | Last Update : Sun, 11 Apr 21