|
|
Posted by pritaeas on 12/21/07 10:43
<teser3@hotmail.com> wrote in message
news:37529850-5b2a-4f25-90e7-8db269679baa@i3g2000hsf.googlegroups.com...
>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.
In my opinion you should correctly use unique indexes on your table. That
way the query will return an error which you can then catch and return to
the user.
Navigation:
[Reply to this message]
|