codeigniter active record, generate, but do not execute query

Question

I am working a library that needs to be fed sql queries as strings todo its job.

I am using CodeIgniter and the active record implementation of their database class.

I know that I can echo the SQL statement like so... But I only want to generate this query, not execute it.

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

Any help accomplishing this would be great!

I'm trying to get the SQL statement without executing the querie... — Peter, Feb 25 '11 at 19:42

Muhammad Raheel · Answer 1 · 2014-05-10T06:37:21.917

with a little hack you can do it go to system/DB_active_rec.php and remove protected keyword form _compile_select method and now

return $this->db->_compile_select();

Also use $this->db->from('table');

Instead of get() because get will execute query Here is an example

function index(){
    $this->db->select('blah blah');
    $this->db->from('table');
    $string = $this->db->_compile_select();
    return $string;
}

score 5 · Answer 2 · answered Feb 27 '11 at 11:01

5

Depends which type of query it is. insert and update have methods to allow you to do this.

$this->db->set('foo', $bar);
$this->db->update_string('table'); // UPDATE table SET foo = "bar"

answered Feb 27 '11 at 11:01

Phil Sturgeon

30,637
12
78
117

I am looking to generate select queries only. – Peter Feb 27 '11 at 20:52
This should be the accepted answer!! Well done, never knew about this! – NaturalBornCamper May 18 '14 at 04:33

score 3 · Accepted Answer · answered Feb 26 '11 at 02:36

3

The last_query() function you are using returns the query string, it doesn't execute the it. Try assigning the function return to a variable for use in your library.

$str = $this->db->last_query();

answered Feb 26 '11 at 02:36

kevtrout

4,934
6
33
33

1

this will execute query first then get the string sql, user get_compiled_select/update/insert instead ... – kreamik Nov 28 '14 at 05:52
4

this is returner after query execution ... so the answer is not right – Florin Nov 30 '15 at 01:44

score 2 · Answer 4 · answered Feb 25 '11 at 05:38

2

I don't know if this is a safe practice but the db object stores its queries in the queries attribute so you can get it via:

$this->db->queries

which returns an array of queries.

answered Feb 25 '11 at 05:38

Rystraum

1,985
1
20
32

Properties should not be accessed like this as that is exactly the sort of thing likely to get turned into a private property when we get around to PHP5ifying the scopes. But yes, it will probably work. – Phil Sturgeon Feb 26 '11 at 09:59
@Phil, is there a way for me to get the sql statement without executing the query? – Peter Feb 26 '11 at 23:48
Answered instead of commented, oops. – Phil Sturgeon Feb 27 '11 at 11:02

score 0 · Answer 5 · edited May 22 '17 at 19:02

0

As of Codeigniter 3 you can use get_compiled_select()

To use it before CI3, see Is there a function like _compile_select or get_compiled_select()?

edited May 22 '17 at 19:02

Petter Friberg

21,252
9
60
109

answered May 22 '17 at 14:50

Sachem

481
1
4
13

codeigniter active record, generate, but do not execute query

5 Answers5

Linked