Get last query in codeigniter 4

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

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

Get last query in codeigniter 4

$cityModel->getLastQuery()->getQuery(); //$cityModel is name of your Models object

Similar codes

31 votes198 views4 answers
Mysql grant execute
SQL
2 votes204 views4 answers
Check timezone of mysql database
SQL
1 vote191 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote202 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote200 views1 answer
Oracle merge insert if not exists
SQL
0 vote201 views1 answer
QCompleter con sql
SQL
3 votes202 views2 answers
Sql select data from last week
SQL
0 vote197 views1 answer
Tsql cmd exec script from file
SQL
0 vote201 views1 answer
Drop procedure sql
SQL
1 vote205 views1 answer
Expression number 1 of select list is not in group by clause
SQL