Posted by teser3@hotmail.com on 12/21/07 00:57

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.

• Next in forum: Re: Batch/local PHP
• Prev in forum: Re: image src and relative path
• Thread view: Prevent duplicate record entry

[Reply to this message]