PHP Codeigniter get last executed query example

By Hardik Savani | January 8, 2019 | Category : PHP MySql Codeigniter

In this post, i would like to show you how to get last executed query in php codeigniter 3 website using last_query() function. you can print last executed sql query like select query, create query, update query, delete query etc.

Whenever you are working on big amount of project and you write long query code using sub query, order by, group by etc. but we write sql query using codeigniter query builder so it might be easy for us. But if you need to print last executed query then you can do it using last_query() function.

Here, i will show you very simple example, so you can get it quickly. We will get all items from database table using select query as bellow example.

Controller Code:


* Get All Data from this method.


* @return Response


public function index()


$data['data'] = $this->db->get("items")->result();

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





SELECT * FROM `items`

I hope it can help you...

Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: