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


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

$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>";



FROM `products`

I hope you get an idea about prints last query in codeigniter.
I would like to have feedback on my 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.

Read Also:  PHP – Loop Between Two Dates Example

About Pakainfo

I am Jaydeep Gondaliya, a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.

View all posts by Pakainfo →

Leave a Reply

Your email address will not be published. Required fields are marked *