Posted by Steve on 12/21/07 04:49

<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.

gee, you could just delete any record that may exist for that first/last
name and email address. or, you could query the table to see if the record
existed. this is not only such an RTFM question, it's also a brainless one.

and let me guess, you're the kind who's code is littered with meaningful
variables like $tmp...right?!!!

• Next in forum: Re: Will the code be much different if requirement on the number of maximum concurrent visitors is greatly different?
• Prev in forum: Re: Batch/local PHP
• Thread view: Re: Prevent duplicate record entry

[Reply to this message]