Codeigniter - throw exception if database transaction fails

Question

I am trying catch database errors within a transaction and if one occurs then rollback and throw an exception.

However, the code is stopping and displaying the db error screen before it throws the exception.

Any ideas how I can make it detect db error without stopping running the subsequent code?

try {
    $this->my_function($data);
} catch (Exception $e) {
    var_dump($e);
}

private function my_function($data)
{

    $this->db->trans_start();
    foreach($data as $reg)
    {
        $sql = $this->db->insert_string('my_table', $reg);
        if($this->db->query($sql))
        {
            continue;
        } else {
            $this->db->trans_rollback();
            throw new Exception('Exception message here...');
        }
    }
    $this->db->trans_complete();

}

what is the error displaying on screen before it throws the exception.? — Madhawa Priyashantha
– Madhawa Priyashantha, Commented Oct 11, 2016 at 10:30
it is expected behavior. error display immediately when it occurs. if condition execute after that — Madhawa Priyashantha
– Madhawa Priyashantha, Commented Oct 11, 2016 at 10:34
you should handle exception in order to control error messages.but codeigniter provide better way to do this see trans_status() codeigniter.com/user_guide/database/transactions.html.but still error will display if you don't handle it — Madhawa Priyashantha
– Madhawa Priyashantha, Commented Oct 11, 2016 at 10:37

Community · Accepted Answer · 2017-05-23 10:27:48Z

This has been answered before on this question

As answered by cwallenpoole:

In application/config/database.php set

// suppress error output to the screen
$db['default']['db_debug'] = FALSE;

In your model or controller:

// try the select.
$dbRet = $this->db->select($table, $dataArray);
// select has had some problem.
if( !$dbRet )
{
   $errNo   = $this->db->_error_number()
   $errMess = $this->db->_error_message();
   // Do something with the error message or just show_404();
}

Or in you case:

private function my_function($data)
{
    $errors = array();
    $this->db->trans_start();
    foreach($data as $reg)
    {
        $sql = $this->db->insert_string('my_table', $reg);
        if($this->db->query($sql))
        {
            continue;
        } else {
            $errNo   = $this->db->_error_number()
            $errMess = $this->db->_error_message();
            array_push($errors, array($errNo, $errMess));
        }
    }
    $this->db->trans_complete();
    // use $errors...
}

Even better

I believe this question has all the answers you need because it takes multiple inserts into account and let's you finish the once that did not return an error.

Collectives™ on Stack Overflow

Codeigniter - throw exception if database transaction fails

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related