Search code examples
phpsqlcodeigniteractiverecord

Getting raw SQL query built from ActiveRecord in CodeIgniter 1.7

I'm trying to debug some code in my first serious CodeIgniter app and I can't seem to find where I can simply get the raw SQL that my ActiveRecord code just generated.

$where  = 'DAY(`datetime_start`) = '. date('d',$day) .' AND ';
$where .= 'MONTH(`datetime_start`) = '. date('m',$day) .'';

$this->db->from('events')->where($where);
$result = $this->db->get();
Solution

  • Before the query runs:

    $this->db->_compile_select();

    And after it has run:

    $this->db->last_query();