Dealing with duplicate keys in codeigniter mysql insert

Question

What I want to do is something like this:

function registerUser($username, $password){

$this->db->insert('tblUsers', array('username'=>$username, 'password'=>md5($password)));
if($this->db->_error_number()==1062){
    return "DUPLICATE";
}
return true;

}

However, at the moment if there is a duplicate key then its not letting me get to the _error_number() bit. Its displaying an error like this:

enter image description here

How do I stop codeigniter from bailing with an error and passing the error number to me to deal with appropriately?

Thanks

citizenen · Accepted Answer · 2012-02-14 17:34:55Z

12

You can access MySQL error messages in Codeigniter using:

$this->db->_error_message();

Apparently DB_DEBUG needs to be set to false in the database config file:

Ensure DB_DEBUG is set to FALSE in the database config file, or execution will halt when a mysql error occurs (it does not get thrown, it justs exits from the php interpreter)

Link: http://codeigniter.com/forums/viewthread/79950/#413830

edited Feb 14, 2012 at 17:34

answered Feb 14, 2012 at 17:12

citizenen

7036 silver badges24 bronze badges

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

2 Comments

Thomas Clayson Over a year ago

Thanks, I know that, I'm using _error_number() to get the error number in the code above. However, its not geting to there, its ditching before hand, and printing an error.

citizenen Over a year ago

See my revised solution. Note that you will no longer be able to see the MySQL error messages without using _error_message()/_error_number()

Dan · Accepted Answer · 2013-07-01 00:01:54Z

8

Suggestion:

$orig_db_debug = $this->db->db_debug;

$this->db->db_debug = FALSE;

RUN QUERY HERE

$this->db->db_debug = $orig_db_debug;

edited Jul 1, 2013 at 0:01

Dan

63.5k18 gold badges113 silver badges122 bronze badges

answered Jun 30, 2013 at 23:42

RayJ

74911 silver badges14 bronze badges

Collectives™ on Stack Overflow

Dealing with duplicate keys in codeigniter mysql insert

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related