Get last executed query in MySQL with PHP/CodeIgniter

Question

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 1

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