Codeigniter - Model - Duplicate Entry Alert

Question

made a simple subscription form submit email and city only email id i set unique but if email id is already in database it shows error i need to add alert here if data already in database alert to user but dont show the complete details like this. A Database Error Occurred Error Number: 1062 Duplicate entry 'abc@abc' for key 2 INSERT INTO `users` (`email`, `city`) VALUES ('abdullah@gaya.com', 'jeddah') Filename: /home/content/f/a/h/fahadghafoor/html/fahad/models/users_model.php Line Number: 12 Model file user_model.php ``` $this->input->post('email'), 'city' => $this->input->post('city'), ); $insert = $this->db->insert('users', $new_member_insert_data); return $insert; }//create_member } ``` Controller file user.php ```

Accepted Answer

It's very simple....Just change

```
$this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email');
```

with is_unique rule

```
$this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email|is_unique[TABLENAME.COLUMNNAME]');
```

TABLENAME - Your table name COLUMNNAME - Your relevant column name which contains Email.Ex:-email

Codeigniter - Model - Duplicate Entry Alert

Solution

Problem