check value exists in database using general function Codeigniter

Question

I am studying codeigniter by developing a website locally. My doubt is, I added some fields in table as unique.

When I try to add duplicate values, It shows internal server error

I overcome this by add function for check if it is a duplicate entry. But I need to add this function on each table insertion.

My question is, Is there any way to write a function at My_model.php for check a table and a unique field value and call it in the My_controller.php by passing the table name and unique field value

Deepak Rai · Accepted Answer · 2014-10-30 10:39:03Z

3

You can use Codeigniter's default form validation to check if the new value being added to the unique field already exists in DB or not.

Refer this:

is_unique | Returns FALSE | if the form element is not unique to the table and field name in the parameter. is_unique[table.field]

this->form_validation->set_rules('email', 'Email', 'required|is_unique[users.email]');

answered Oct 30, 2014 at 10:39

Deepak Rai

2,2113 gold badges24 silver badges39 bronze badges

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

1 Comment

Arun Over a year ago

Wow.. and it works..thank you for the answer. Will accept the answer once the waiting period over... :)

Collectives™ on Stack Overflow

check value exists in database using general function Codeigniter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related