Codeigniter does this- db- last query execute a query

Question

Does query execution happen at the get where   clause of the following codeigniter active record statement    this- gt db- gt select            q    this- gt db- gt get where  Contacts   array  id    gt   contact id          sql    this- gt db- gt last query      Or does it happens once you call the result array     And is  this- gt db- gt last query    a reliable way in getting the query string

User · Accepted Answer

The query execution happens on all get methods like

$this->db->get('table_name');
$this->db->get_where('table_name',$array);

While last_query contains the last query which was run

$this->db->last_query();

If you want to get query string without execution you will have to do this. Go to system/database/DB_active_rec.php Remove public or protected keyword from these functions

public function _compile_select($select_override = FALSE)
public function _reset_select()

Now you can write query and get it in a variable

$this->db->select('trans_id');
$this->db->from('myTable');
$this->db->where('code','B');
$subQuery = $this->db->_compile_select();

Now reset query so if you want to write another query the object will be cleared.

$this->db->_reset_select();

And the thing is done. Cheers!!! Note : While using this way you must use

$this->db->from('myTable')

instead of

$this->db->get('myTable')

which runs the query.

Take a look at this example

User · Answer

For me save queries option was turned off so    this- gt db- gt save queries   TRUE    Turn ON save queries for temporary use   str    this- gt db- gt last query    echo  str    Ref  Can  39 t get result from  this- gt db- gt last query    codeigniter

[codeigniter] Codeigniter: does $this->db->last_query(); execute a query?

Examples related to codeigniter

Examples related to activerecord

Examples related to codeigniter-2