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 vote204 views1 answer
Laravel collection higher order messages
PHP Laravel
1 vote177 views1 answer
Increase xampp phpmyadmin import limit
PHP
0 vote226 views1 answer
Xml header php
PHP
0 vote174 views3 answers
Permissions for laravel deployment
PHP
2 votes170 views2 answers
Fatal error: Maximum execution time of 120 seconds exceeded in
PHP
0 vote222 views1 answer
Laravel request input default value
PHP Laravel
0 vote220 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
16 votes181 views2 answers
Wordpress debug config
PHP
97 votes277 views6 answers
Php string contains substring
PHP
28 votes184 views6 answers
Laravel make model with migration
PHP