Welcome Guest, Not a member yet? Register   Sign In
View query before being executed?
#1

[eluser]jrlooney[/eluser]
Hello,

How can I dump the query that $this->db is going to execute so that I can review it?

So, for example, for this query, I'd like to see the SQL (even if I just var_dump it):

Code:
$this->db->limit(0,$this->per_page);
$this->db->select('contact_id,first_name,last_name');
$data['query'] = $this->db->get('cm_contact');

thanks in advance
#2

[eluser]jrlooney[/eluser]
nevermind. found it.
$this->db->last_query();
#3

[eluser]phpoet[/eluser]
According to the documentation, last_query() returns the sql for the last query that has already been executed. It pops the last query off the queries[] array from the CI_DB_Driver class and it looks like the query doesn't get added to the array until it's run.
#4

[eluser]xwero[/eluser]
There is a method _select_compile that lets you show the query before executing but as you can gather from the name it only works for the select statements.




Theme © iAndrew 2016 - Forum software by © MyBB