Codeigniter: when I insert data I'm getting duplicate key error, how can I handle this error?

Question

When I insert data I'm getting duplicate key error, how can I handle this error?

if($this->db->insert('user', $this)) {
  return TRUE;
}

how can I handle db errors?

EDIT

This is the error presented:

A Database Error Occurred

Error Number: 1062

Duplicate entry 's123' for key 'login'

INSERT INTO `user` (`id`, `login`, `hash`, `fname`, `sname`, `lname`, `phone`, `email`, `administrator`, `moderator`, `author`, `add_time`, `is_active`) VALUES (NULL, 's123', '$2y$10$EIrEBovWdrSPnMKNOvBuyebUnQKaKNePQSOmhyihf124tompkSnQK', 's123', 's123', 's123', '123', 's123', '0', '0', '0', 1507543679, '0')

Filename: models/User_model.php

Line Number: 74

But, I don't want to show it to user. Instead, I want present the user another error message, like:

"Such User exists. Please try again!"

don't pass `primary key` while inserting. if you don't have `primary key` in table then make `table id` as `auto incremented primary key` — Alive to die - Anant, Oct 09 '17 at 09:51
@BilalAhmed: id is primary key and auto_increment, but I want to handle `mysql` error — Salim Ibrohimi, Oct 09 '17 at 09:51
@AlivetoDie: I also did not result. Codeigniter auto generate `#1062` error/ — Salim Ibrohimi, Oct 09 '17 at 09:55
https://stackoverflow.com/questions/7843406/codeigniter-how-to-catch-db-errors — Alive to die - Anant, Oct 09 '17 at 09:56
I also tried these code, but didn't help `$this->db->_error_message(); (mysql_error equivalent) $this->db->_error_number(); (mysql_errno equivalent)` — Salim Ibrohimi, Oct 09 '17 at 09:56
https://stackoverflow.com/a/6600235/4248328 or try:- `if($this->db->insert('user', $this)) { return TRUE; }else{echo $this->db->_error_message(); echo $this->db->_error_number(); }` — Alive to die - Anant, Oct 09 '17 at 09:58

score 3 · Accepted Answer · answered Oct 09 '17 at 13:15

3

Either you check before, whether such user id exists already

$query = $this->db->get_where('user', array(
            'id' => $user_id
        ));

$count = $query->num_rows(); 

if($count){
     $this->session->set_flashdata('error', 'Such User exists. Please try again!');
     redirect('controller_name/method_name');
}

// if above one does not evaluate true then insert
$this->db->insert('user', $some_array_with_data);

OR

try{

    $this->db->insert('user', $some_array_with_data);

}catch(Exception $e){

       // this is what you show to user,
       $this->session->set_flashdata('error', 'Such User exists. Please try again!');

      // if you want to log error then
      log_message('error',$e->getMessage());

      // redirect somewhere
      redirect('controller_name/method_name');
}

answered Oct 09 '17 at 13:15

Akshay Hegde

16,536
2
22
36

Dear friend, thanks for response, suddenly it's didn't help (( – Salim Ibrohimi Oct 09 '17 at 13:21
@SalimIbrogimov: set `db_debug` to `FALSE` in `application/config/database.php` and then try, – Akshay Hegde Oct 09 '17 at 13:37
I have this: `$db['default']['db_debug'] = (ENVIRONMENT !== 'production')` – Salim Ibrohimi Oct 09 '17 at 13:38
@SalimIbrogimov: what's your current `ENVIRONMENT` then ? – Akshay Hegde Oct 09 '17 at 13:39
1

if you set, either ENVIRONMENT to production, or `$db['default']['db_debug'] = false`, then `try{}catch(){}` should work, otherwise, use first solution, which will work even if `$db['default']['db_debug'] = true;` – Akshay Hegde Oct 09 '17 at 13:42
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/156307/discussion-between-salim-ibrogimov-and-akshay-hegde). – Salim Ibrohimi Oct 10 '17 at 04:08
1

Thanks a lot, I did this: `$db['default']['db_debug'] = FALSE;`. – Salim Ibrohimi Oct 10 '17 at 04:18

Codeigniter: when I insert data I'm getting duplicate key error, how can I handle this error?

1 Answers1