Prevent duplicate entry

chicago1985

I have a unique constraint in my Oracle table for 3 fields. If I enter duplicate info on the table using Oracle client I will get an Ora message error ORA-00001 that tells me it is a duplicate entry attempt.

How do I capture that in my PHP page if someone tries to enter duplicate record info?

My PHP Oracle insert statement in the action page:

Expand|Select|Wrap|Line Numbers

 
$s = OCIParse($c, "insert into tableOne values ('$varOne', '$varTwo', '$varThree')");

OCIExecute($s, OCI_DEFAULT);

How would I capture the ORA-00001 unique constraint message to prevent a duplicate entry into the Oracle table?

Ranjan kumar Barik

Quote:

Originally Posted by chicago1985

I have a unique constraint in my Oracle table for 3 fields. If I enter duplicate info on the table using Oracle client I will get an Ora message error ORA-00001 that tells me it is a duplicate entry attempt.

How do I capture that in my PHP page if someone tries to enter duplicate record info?

My PHP Oracle insert statement in the action page:

Expand|Select|Wrap|Line Numbers

 
$s = OCIParse($c, "insert into tableOne values ('$varOne', '$varTwo', '$varThree')");

OCIExecute($s, OCI_DEFAULT);

How would I capture the ORA-00001 unique constraint message to prevent a duplicate entry into the Oracle table?

Hi,
You can do one thing.
First get the all the values you have in the respective column.
Then compare it with the inserted value and if there is no matching then execute the insert statement.
else Display an error message to the user.

Happy Programming!
:)

Prevent duplicate entry

re: Prevent duplicate entry

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about