Transaction and error handling

[eluser]InsiteFX[/eluser]
Managing Errors

If you have error reporting enabled in your config/database.php file you'll see a standard error message if the commit was unsuccessful. If debugging is turned off, you can manage your own errors like this:

Code:

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER QUERY...');
$this->db->trans_complete();

if ($this->db->trans_status() === FALSE)
{
     // generate an error... or use the log_message() function to log your error
}

If it returns FALSE then you know that this is the database query that caused the Error!

InsiteFX