Codeigniter echo 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

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

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 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

6 votes148 views4 answers
Unique check with multiple columns laravel validation
PHP
0 vote193 views2 answers
DB::raw update query in laravel
PHP Laravel
0 vote159 views4 answers
Image Upload in Laravel
PHP
47 votes192 views6 answers
Php length of array
PHP
-3 votes140 views8 answers
@foreac laravel
PHP
0 vote157 views1 answer
Open php tag
PHP
1 vote107 views1 answer
Php curl log
PHP
0 vote136 views1 answer
Laravel datatable render html
PHP
10 votes192 views2 answers
Array to string conversion in laravel controller
PHP Laravel
11 votes136 views6 answers
How to print on python
PHP