Codeigniter 4 get last query

Print last executed db query codeigniter

$this->db->last_query();

Codeigniter print last sql query

print_r($this->db->last_query());

Source: stackoverflow.com

Print last query in codeigniter

We can get last executed query using last_query() function of db class in codeigniter. It is a very simple to use $this->db->last_query() function to see SQL statements of last executed query in php codeigniter app. You have to simple code that function after your main query that you wanted check 
$this->db->last_query()

Codeigniter get last query

$this->db->last_query();

Returns the last query that was run (the query string, not the result). Example:
$str = $this->db->last_query();

// Produces: SELECT * FROM sometable....

Source: stackoverflow.com

Codeigniter 4 get last query

$data['lastQuery'] = $db->getLastQuery(); //ci4

Codeigniter echo last query

public function test_db(){    $query = $this->db->get("items");      $str = $this->db->last_query();       echo "<pre>";    print_r($str);    exit;}

Source: itsolutionstuff.com

Similar codes

0 vote281 views1 answer
How to perform form inpot in laravel 8 and export database
PHP
0 vote272 views1 answer
Indirect modification of overloaded property has no effect laravel
PHP
16 votes264 views5 answers
Php compare two dates
PHP
10 votes262 views2 answers
Same password check in laravel
PHP
7 votes266 views2 answers
Wordpress loop
PHP
0 vote277 views1 answer
Laravel mail success or failure
PHP
2 votes256 views6 answers
PHP add 1 day to current date
PHP
4 votes375 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
3 votes283 views5 answers
Get current locale laravel
PHP Laravel
1 vote434 views2 answers
Laravel 8 livewire tutorial
PHP Laravel