Posted by Gordon on 12/23/07 10:49

On Dec 21, 12:57 am, "tes...@hotmail.com" <tes...@hotmail.com> wrote:
> I have my PHP inserting into Oracle 9i.
> But how do I prevent duplicate record entries?
>
> I only have 3 fields in the insert in the action page:
>
> CODE
> <?php
> $c=OCILogon("scott", "tiger", "orcl");
> if ( ! $c ) {
> echo "Unable to connect: " . var_dump( OCIError() );
> die();
> }
>
> $s = OCIParse($c, "INSERT INTO personTable
> (firstname,lastname,emailaddress) VALUES
> ($_POST[firstname],'$_POST[lastname]','$_POST[emailaddress]'");
> OCIExecute($s, OCI_DEFAULT);
> echo "Record successfully entered";
> ?>
>
> How do I prevent duplicate record info and show the user they entered
> duplicate info.

Just put a unique first name/last name constraint on your table. Go to
an SQL related group to find out how, or better yet read the manual.

[Back to original message]