CodeIgniter Active Record: Debugging without running SQL

Question

I'm fairly new to Code Igniter, and I'm using Active Record for all the queries in a new project.

Is there a way to output the SQL statement without actually running it.

The function i've created has quite a few statements in it, selects, deletes and updates, and I want to make sure they are correct before running them in a test environment as they have a lot of Ifs and cases around them to build up the queries.

So in short, I just want it to echo the statement, but not run it.

Thanks in advance! :)

Assuming you put the query into a variable, just: echo $myquery; — Brian, Aug 01 '12 at 08:27
read here: http://stackoverflow.com/questions/5113675/codeigniter-active-record-generate-but-do-not-execute-query — Yan Berk, Aug 01 '12 at 08:30
so if i use 'echo $this->db->last_query();' it will display the query but it wont run it? — David 'davethegeek' Dingvean, Aug 01 '12 at 08:39
Surely if the $this->db->updat('table' $data) has been already sent, it will run? — David 'davethegeek' Dingvean, Aug 01 '12 at 08:40
As an additional note: enabling the profiler will greatly help you debug your MySQL queries, configuration options, post, get and session data with every page. It can be enabled by adding `$this->output->enable_profiler(true);` in your Controller's `__construct` function. — Abdulaziz, Aug 02 '12 at 04:50

score 4 · Answer 1 · answered Aug 01 '12 at 08:39

4

Take a look at the insert_string() and update_string() methods listed in the Database Query Helper section of the user guide.

For select you'll need to run $this->db->last_query() after you've run the command, but SELECT is non-destructive so who cares.

answered Aug 01 '12 at 08:39

Phil Sturgeon

30,637
12
78
117

exactly, the select statements i'm fine with, its the update and delete queries i'm wary of, I want to be able to display them without running. will look at the help section. thanks – David 'davethegeek' Dingvean Aug 01 '12 at 08:41
The insert/update string is handy to output, but it doesnt work with a query built up in active record. – David 'davethegeek' Dingvean Aug 01 '12 at 08:48
It certainly should do. How are you using it? – Phil Sturgeon Aug 01 '12 at 09:58

score 1 · Answer 2 · edited May 23 '17 at 11:53

1

Take a look at this answer of mine.
How can I rewrite this SQL into CodeIgniter's Active Records?

In this if you use $this->db->_compile_select() and then echo it it will display the query without running.

edited May 23 '17 at 11:53

Community

1
1

answered Aug 02 '12 at 03:49

Muhammad Raheel

19,823
7
67
103

CodeIgniter Active Record: Debugging without running SQL

2 Answers2