get last executed query in PHP Codeigniter

390 views 10:07 am 0 Comments January 12, 2021
get last executed query in PHP Codeigniter

get last executed query in PHP Codeigniter

get last executed query in PHP Codeigniter
get last executed query in PHP Codeigniter

howdy guys !! In this post , I will explain how to get last executed query in PHP Codeigniter 3 . I will help you to get last query executed in MySQL by using function  last_query()  of db class of codeigniter 3, Returns the last query that was run  not result.

last query executed in MySQL by using Codeigniter 3

last_query()  function is the inbuilt function of codeigniter 3.

Very simple to use

Use:

$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 sometable.... 

For example lets start

 

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

Output:

select * from tbl_category.

 

We hope you can learn something from this post. if you like this article

Sharing is Caring !!!

Tags:

Leave a Reply