codeigniter print last sql query
print_r($this->db->last_query());codeigniter print last sql query
print_r($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....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 4 query builder get inserted id
$query = $this->db->table($this->table)->insert($data);
return $query->resultID;codeigniter echo last query
public function test_db(){ $query = $this->db->get("items"); $str = $this->db->last_query(); echo "<pre>"; print_r($str); exit;}Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
