soredive soredive - 1 month ago 9
MySQL Question

Get last executed query in MySQL with PHP/CodeIgniter

How can I get last query I ran in MySQL in both Windows and Linux?

I am working with PHP and CodeIgniter. In

my_model.php
, I have:

$query1 = ( ...something... );
$query2 = ( ...something... );
$variables = ( .... something .... );
$this->db->query(" $query1 ... $variables .. $query2", array( $variables, ... ));


I need the last query executed right after the code snippet above.

Can anyone tell me how can I get my last query?

Answer

Use:

$this->db->last_query();

Returns the last query that was run (the query string, not the result). Example:
$str = $this->db->last_query();

// Produces: SELECT * FROM sometable.... 

example taken from the manual on query helper functions

Comments