Form submits on load and refresh.

matthewst

I have a form that keeps submitting itself when I load the page or hit refresh. I don't know how to make it stop.

if (isset($_POST["submit"])) {
//if($_POST["submit"]){
//if($submit) {

$ad_now=(mktime()-21600);
$sql_daily = "INSERT INTO ad_total_daily (img, date_time) VALUES ('1', '$ad_now')"; 
$result_daily = mysql_query($sql_daily);

<form action="<?=$PHP_SELF;?>" method="post" enctype="multipart/form-data" name="FormName">

<input type="submit" class="formTextbox" name="submit" value="Submit">

dalecosp

This is the browser's problem, not PHP's. Stop reloading the page, it will stop submitting. Or, access the page without submitting a form. 😉

dalecosp

Whoops, I might have been premature there. "Load and refresh", you mean, it submits when you load the page directly (type the URI directly into the browser?)

matthewst

fixed the submit on load problem
now the only problem is it still submit on refresh
funny thing is only does that in opera
it works fine in firefox and ie

matthewst

thanks for the help
so far I've tried

unset($_POST);

and

unset($_POST['submit']);

giving up on this for now

Rodney_H_

If you are INSERTING a value into the db upon form submission, why not:

a) upon success of the insert, create a SESSION var

b) next time the page reloads, if the SESSION var isset, Do NOT do the insert, but do whatever else you would like.

halojoy

Rodney H. wrote:
If you are INSERTING a value into the db upon form submission, why not:

a) upon success of the insert, create a SESSION var

b) next time the page reloads, if the SESSION var isset, Do NOT do the insert, but do whatever else you would like.

I guess there are other ways, No Caching or like that.

But I have used the Rodney H. method.

<?php

// in the form processing page
session_start();

if( !isset( $_SESSION['done']) ){

// process form
// and if insert okay
$_SESSION['done'] = true;

}

if( !isset( $_SESSION['done']) ){

// display form

}

?>

This way is maybe even better

<?php

// in the form processing page
session_start();

if( isset($_SESSION['done']) ){
    exit( 'you have already submitted form' );
}

// process form
// and if insert okay
$_SESSION['done'] = true;

// otherwise
// display form

?>