CodeIgniter - continue on SQL error?
Yeah, took me a while too and annoyed the hell out of me:
$db['default']['db_debug'] = FALSE;... in config/database.php - disables the error page.
After a query ran, use this to check for an error:
if (!empty($this->db->_error_message())) { echo "FAIL";}
I know you already have a solution, but thought this might be useful for others viewing this question as well.
Let the database do the work for you:
$this->db->query("INSERT IGNORE INTO `table` (`col1`, `col2`, `col3`) VALUES (`val1`, `val2`, `val3`)");When you use INSERT IGNORE, things like duplicate key errors become warnings instead of errors, which let your queries run without interrupting the flow of your script.
You could then do a
SHOW WARNINGS;after all the queries have run to see what warnings occurred.