View query before being executed? |
[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); thanks in advance
[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.
[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. |
Welcome Guest, Not a member yet? Register Sign In |