How to catch database exceptions?

Question

Inside a controller I want to make an insert into the database :

public function insertAction() {

        try {
            $this->load->model('action');
            $_POST['laDate'] = $this->input->post('ladate_') == '' ? '' : $this->dates->convertDateToFormatBase($this->input->post('ladate_'), '');
            $_POST['dateCreation'] = "now()";
            $action_id = $this->action->ajouter($_POST);
            if (isset($_POST['verificateurs'])) {
                $this->load->model('actionVerificateur');
                $this->actionVerificateur->inserer($action_id, $_POST['verificateurs']);
            }
            $this->load->view('ajax/insertAction', array('action_id' => $action_id));
        }
        catch (Exception $e) {
            $this->load->view('ajax/insertAction', array('action_id' => 0));
        }

    }

There is a unique constraint on some columns of the database table. So when this constraint is violated then I want to catch the exception. But it seems that my code does not catch it ! So how to catch the exception ?

what if you use Transactions. I never heard of using TRY CATCH in the framework. Cz Framework helps thing easy. But you doing old still — Abdulla Nilam
– Abdulla Nilam, Commented Aug 16, 2017 at 8:03
Check this out, this helped me earlier. Hope it will be helpful to you also. stackoverflow.com/questions/15858372/… — Nikhil G
– Nikhil G, Commented Aug 16, 2017 at 8:09

pheromix · Accepted Answer · 2017-08-16 08:55:32Z

0

I found a workaround : I tested if $this->db->insert_id() is numeric ! because in the case an exception is raised then the returned value is an html code beggining with <DOCTYPE>.

edited Aug 16, 2017 at 8:55

answered Aug 16, 2017 at 8:18

pheromix

19.6k33 gold badges96 silver badges182 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to catch database exceptions?

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