Form executing twice when press submit

[Anon]

Hi,

I am a newbie. My data input form is like this....

<?php

if ( $submit== 'go' )
{
$submit='false';
check duplicate...
if duplicate
{
$messsage="Already exists";
}
else
{
do insert...
$message="Record inserted...";
}
?>

form definitions...

When I press 'go' it is inserting the record as expected but it is running the entire program again and giving the error message "Already exists". Could anyone plese help me to find out why it is running twice???

TIA.
KC.

[Anon]

Prolly a double-click on the submit button.

I get around that by having a unique token (an integer I generate with a serial ID, something like "auto increment primary key" in MySQL) that I pass along with the form.

I generate the following output:

<form action=whatever.php>
<INPUT TYPE=TEXT NAME=TheGoods>
<INPUT TYPE=HIDDEN NAME=token value=35>
</FORM>

And, on the receiving page, I (sql) "delete from tokentable where token=$token";

If this statement works, I then dump the data. Otherwise, I display an "already submitted" message.

-Ben

[stevenye]

add such code after the deletion in php:

// your process of data delete.
// and then add:
header("Location: ". $HTTP_SERVER_VARS["PHP_SELF"]);
/* server need to relocation to the corrent page to refresh the submitted information.

*/
any question please let me know . 🙂
[e-mail]