Codeigniter: How to handle database error?

Question

I'm creating a web application using codeigniter and postgresql. I have this inside my database:

user
id name
unique(name)

When someone try to register with the same name, i get an error. How can i handle them, without displaying the codeigniter's error and showing instead my custom error? If i set $db['default']['db_debug'] = FALSE; i don't get any error of course, but is there a way to handle the db error or should i check myself if the table already contains an entry with that same name?

Hkachhia · Accepted Answer · 2015-12-28 05:02:30Z

2

Use Codeigniters form validation class. is_unique[table.columnName]. This will do the work for you. Below is an example

$this->form_validation->set_rules('name', 'Name', 'is_unique[table_name.Name]');

Then just set a custom message referencing the is_unique validation like below

$this->form_validation->set_message('is_unique', 'Name already exists');

edited Dec 28, 2015 at 5:02

Hkachhia

4,5458 gold badges44 silver badges79 bronze badges

answered May 5, 2015 at 16:12

Kyle Reierson

1251 gold badge1 silver badge9 bronze badges

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

Comments

Martijn · Accepted Answer · 2014-10-10 11:21:53Z

0

I dont know anything by codeigniter, but im going to assume the principle works the same:

You first make a query like SELECT id FROM tablename WHERE name='SomeName' LIMIT 1, then you check the number of rows. This kind of checking is fairly normal. Control as much as you (sensebly) can to avoid errors down the road.

Zero rows? Safe to insert. Not zero rows? Display something like 'username allready taken'.

Example with some code:

$check = mysqli_query("SELECT id FROM tablename WHERE name='SomeName' LIMIT 1");
if( $check->num_rows!==0 ){
    echo 'Username allready taken'; // echo is bad, you should process this better, but this is easy demo
}
else{
    // Your normal inserting code goes here.
}

edited Oct 10, 2014 at 11:21

answered Oct 10, 2014 at 9:50

Martijn

16.2k4 gold badges39 silver badges73 bronze badges

1 Comment

Federico Ponzi Over a year ago

Thanks for the answer Martijn, but i was asking if there were another way to accomplish this maybe something built-in inside codeigniter!

Community · Accepted Answer · 2017-05-23 10:31:06Z

0

Like Martijn said, it is a solution.

CI doesn't throw exception, so when you perform a query, it will return NULL if the statement fails.

You may want to see CodeIgniter - how to catch DB errors?

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Oct 10, 2014 at 10:46

Kaymaz

4968 silver badges25 bronze badges

Collectives™ on Stack Overflow

Codeigniter: How to handle database error?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related