How to get last executed query in PHP Codeigniter?

Today, We want to share with you print last query in codeigniter.In this post we will show you echo last query in php codeigniter, hear for codeigniter get last query we will give you demo and example for implement.In this post, we will learn about
How to print last query in codeigniter? with an example.

Get last executed query in MySQL with PHP/CodeIgniter

$this->db->last_query();

Returns the last excuted query that was run (the php query string, not the result).
Example:

$data_str = $this->db->last_query();

// Produces: SELECT * FROM members.... 

Example – To print executed query at last In Codeigniter

$query = $this->db->get("members");
echo $this->db->last_query();

Example : 2

public function test_db()
{
    $query = $this->db->get("products");
  
    $data_str = $this->db->last_query();
   
    echo "<pre>";
    print_r($data_str);
    exit;
}

Output

SELECT *

FROM `products`

I hope you get an idea about prints last query in codeigniter.
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.