Form submits on 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">

[The Little Guy]

could we see more?

 

 

otherwise, after the "Process" information is done, I would do this:

 

<?php
unset($_POST);
?>

[darkfreaks]

kaching! solved?

[matthewst]

It still submits on refresh.

 

heres more code

<?
include('include/user_check.php');
include('include/db_con.php');
$id = $_SESSION['track_id'];
            $dest_email='user@user.net';
//if (isset($_POST["submit"])) {
if($_POST["submit"]){
//if($submit) {
//insert queries that don't submit on refresh
//the following submits itself on load and refresh
$ad_now=(mktime()-21600);
$sql_daily = "INSERT INTO ad_total_daily (img, date_time) VALUES ('1', '$ad_now')"; 
        	$result_daily = mysql_query($sql_daily);
$sql_weekly = "INSERT INTO ad_total_weekly (img, date_time) VALUES ('1', '$ad_now')"; 
        	$result_weekly = mysql_query($sql_weekly); 
$sql_monthly = "INSERT INTO ad_total_monthly (img, date_time) VALUES ('1', '$ad_now')"; 
        	$result_monthly = mysql_query($sql_monthly); 
$sql_yearly = "INSERT INTO ad_total_yearly (img, date_time) VALUES ('1', '$ad_now')"; 
        	$result_yearly = mysql_query($sql_yearly); 
$sql_ytd = "INSERT INTO ad_total_ytd (img, date_time) VALUES ('1', '$ad_now')"; 
        	$result_ytd = mysql_query($sql_ytd);
//end self submit
            ?>

<?php
unset($_POST);
?>


//all my form junk

 

[Orio]

I cant see you closing the if()'s curly brace. Also, use $_POST['submit'] (with single quotes), I think it's a more correct way to code.

 

Orio.

[matthewst]

They're in the page just not in what I posted. The page does submit like it should when I hit the submit button, it then reloads itself without resubmitting. It just submits on first loading and refreshes.

[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

[The Little Guy]

well then, I think you have an HTML problem.

[matthewst]

thanks for the help

so far I've tried

 

unset($_POST);

 

and

 

unset($_POST['submit']);

 

giving up on this for now

[darkfreaks]

<?php

$submit= $_POST['submit'];

if (isset($submit)) {  $sql="insert into foobar values(hoo,ha)";
echo 'congrats your data was inserted'; unset($submit);}
?>