Ways to wrtie in Active Record

Depending on context, I sometimes find it cleaner, especially with long chains, to do something like this:

PHP Code:

$this->db->select('')
         ->from('')
         ->where('')
         ->where_in('')
         ->order_by('')
         ->limit('');

// Maybe there is more code here to modify the query

// Finally, assign the result to the $my_query variable

$my_query = $this->db->get(); 


Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide