+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Model-View-Controller (https://forum.codeigniter.com/forumdisplay.php?fid=10)
+--- Thread: CI4 - Generate sql query from query builder (/showthread.php?tid=76454)
CI4 - Generate sql query from query builder - JohnDoe - 05-14-2020
How to generate sql query from query builder if I have function like this?
PHP Code:
public function get_user_by_email($email)
{
$this->where('email', $email);
return $this->first();
}
Also on CI3 if I have error on my generated SQL, it will show the generated query while on CI4 it only show the mysqli_sql_exception without the SQL query. How can I show the sql query everytime I have error with query builder?
RE: CI4 - Generate sql query from query builder - InsiteFX - 05-15-2020
PHP Code:
$error = $db->error(); // Has keys 'code' and 'message'
$db->getLastQuery();