验证插入codeigniter

Question

I'm trying to validating my insert data in codeigniter

The problem is the code returning me a duplicate entry's page error. And i want to throw that failure to home page with error message.

Here is my code:

$data = array(
            'heheId'   => $this->input->post('heheId'),
            'userId'  => $this->input->post('userId')
        );
    $this->db->insert('tentarasaya',$data);
    if ($this->db->affected_rows() > 0){
        $this->session->set_flashdata('info', "Hore sukses");
    } else {
        $this->session->set_flashdata('danger', "Fail insert");
    }
    redirect('my_home');

Any answer?

Update: Duplicate entry like this

Answer 1

Try this

$data = array(
    'heheId'   => $this->input->post('heheId'),
    'userId'  => $this->input->post('userId')
);  
if (!$this->db->insert('tentarasaya',$data)) { # add if here
    # Unsuccessful
    $this->session->set_flashdata('danger', "Fail insert");
}
else{
     # Success
    $this->session->set_flashdata('info', "Hore sukses");
}
redirect('my_home');