codeigniter query builder see query code example

Example 1: how to print mysql query of codeigniter query builder

To display the query string:

print_r($this->db->last_query());    

To display the query result:

print_r($query);

Example 2: query builder codeigniter

$this->db->set('name', $name);
$this->db->set('title', $title);
$this->db->set('status', $status);
$this->db->insert('mytable');