How to give duplication validation in PHP mysql?

Question

I have a field area_code in mysql table by php form. I need the validation & alert when typing the same area code which is already entered and stored in database.

Why dont you just use a unique_key for area code and then catch the mysql_error? — androidavid
– androidavid, Commented Jan 22, 2013 at 9:46

John Woo · Accepted Answer · 2013-01-22 09:48:18Z

2

The best way you do is to define a UNIQUE constraint on field area_code on the table.

ALTER TABLE tableName ADD CONSTRAINT tb_UQ UNIQUE (area_code)

if the code was executed and successful, the server will generate an error if you try to enter area_code that is already present on the table.

answered Jan 22, 2013 at 9:48

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Comment

SS Nath Over a year ago

It working. Thanks. But I need a alert pop-up box in the php form.

Ivo Pereira · Accepted Answer · 2013-01-22 09:53:03Z

0

You could make a SELECT count statement and check if the returned rows. If so, it means that the record already exists.

SELECT COUNT(id) AS count FROM area_codes WHERE area_code = 'ABC'

If returned row is greater than 1, than the record you are trying to insert already exists.

answered Jan 22, 2013 at 9:53

Ivo Pereira

3,5101 gold badge22 silver badges24 bronze badges

Collectives™ on Stack Overflow

How to give duplication validation in PHP mysql?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related