ci last query | last query ci | get last query codeigniter Example

Today, We want to share with you ci last query.In this post we will show you codeigniter last insert id, hear for Print last query we will give you demo and example for implement.In this post, we will learn about Insert Query In Codeigniter Example Tutorial with an example.

How to get last executed mysql query in Codeigniter ?

you can place it in the controller or model (even the view if you wish

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

Example 1:

echo '
';
print_r($this->db->last_query());
echo '
';
last query executed in MySQL by using Codeigniter 3
Example 2: 

last_query()  function is the inbuilt function of codeigniter 3.
public function check_query(){
    $query = $this->db->get("shops");
    $results = $this->db->last_query();
    echo $results;
}

Output: 
select * from shops.

I hope you get an idea about echo last query in php.

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.


 
Related posts:

last query ci – codeigniter last query Example
codeigniter print last query Examples
last query in ci | get last query codeigniter Example
print last query in codeigniter Example
codeigniter last query (last query ci) Examples
get last query codeigniter | last query in ci Example
How to Get Last Executed Query in Codeigniter?
how to get raw query in codeigniter
How to get last executed query in PHP Codeigniter?
How to get last executed query in PHP Codeigniter?