+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Handling DB Errors using Query Builder (/showthread.php?tid=68567)
Handling DB Errors using Query Builder - geabenitez - 07-28-2017
Hello, i need to know how to handle DB errors when using Query Builder.
I know the following can work as per how is described here
PHP Code:
if ( ! $this->db->simple_query('SELECT `example_field` FROM `example_table`'))
{
$error = $this->db->error(); // Has keys 'code' and 'message'
}
but how can I use it when doing something like this
PHP Code:
$data = array(
'title' => 'My title',
'name' => 'My Name',
'date' => 'My date'
);
$this->db->insert('mytable', $data);