ci last query | last query ci | get last query codeigniter Example

Today, We want to share with you ci last query.In this post we will show you codeigniter last insert id, hear for Print last query we will give you demo and example for implement.In this post, we will learn about Insert Query In Codeigniter Example Tutorial with an example.

How to get last executed mysql query in Codeigniter ?

codeigniter last query
codeigniter last query

you can place it in the controller or model (even the view if you wish

$this->db->last_query();

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

// Produces: SELECT * FROM products....

Example 1:

echo '<pre>';
print_r($this->db->last_query());
echo '</pre>';

last query executed in MySQL by using Codeigniter 3

Example 2:
last_query() function is the inbuilt function of codeigniter 3.

public function check_query(){
    $query = $this->db->get("shops");
    $results = $this->db->last_query();
    echo $results;
}

Output:

select * from shops.

I hope you get an idea about echo last query in php.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.