How to see generated mysql string in codeigniter [duplicate]

Question

I am just wondering if there is a built in function to call if you want to get the generated mysql generated string in codeigniter. Consider the following example

$this->db->from('mytable');
$this->db->where('id', $id);
$query = $this->db->get();

I just wondering if there is return $this->db->return_string() that would result to

SELECT * FROM mytable blablablabla blablabla

I am scheming through out their site but seems cannot find what I am looking for.. any input guys?

sorry for the duplicate question guys but I had search on google about this question but I did not came up to that address, maybe I had the not mention the exact keywords on the search box.. it was okay now and thank you for the inputs ..:) — HTTP
– HTTP, Commented Oct 9, 2013 at 7:16

Charles0429 · Accepted Answer · 2013-10-09 06:29:54Z

2

you could try this:

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

answered Oct 9, 2013 at 6:29

Charles0429

1,4405 gold badges16 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to see generated mysql string in codeigniter [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related