Are you wanted to get the last executed SQL query in the CodeIgniter project? then, I will help to get the latest query in CodeIgniter
We can get the last executed query using the last_query() function of the inbuilt db class of the CodeIgniter. This function can be used with simple syntax like $this->db->last_query() to see SQL statements of last executed query in PHP CodeIgniter app. You have to simple code that functions after the main query that you wanted to check.
Here is a simple function code which can be added in any controller of the CodeIgniter project and also output for the last query:
Example:
public function check_query_function() {
$sql = $this->db->get("products");
$query = $this->db->last_query();
echo "<pre>";
print_r($query);
exit;
}
Output:
SELECT * FROM `products`