Posted inphp / Codeigniter

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

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. 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.

Leave a Reply

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

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype