How to clear a form post ?

MichaelHe

I have a form with a submit buttom.
After thus a type

IF($_POST){ and then some INSERTs in a MySQL table }

This works fine, and it inserts the data from the form.
But if I click update in my browser, it inserts the data once more.

So the info about that the form has been submittet is still active.
How do I clear this, so you have to actually click the buttom again to insert data ?

Plasma

Refreshing means re-request what the previous request was (in this case, POSTing form data).

One way around this is to use header("Location: ?") to have the user reload the current page once the request was sent, but now they no longer have the POST data as the previous request, so a page reload wont do anything other than reload the page.

Houdini

Why don't you assign and new variable to the $POST variable like $newvar= $POST then insert that instead of $_POST?

anoopd

I am also facing the problem form resubmitting while refreshing the page .....
if im triying to load the same page again then ... "Cannot modify header informatio
error is shown what to do now?🙁

Rodney_H_

What I like to do is start a session at the top of a page.

<?php
session_start();
?>

If the form is submitted, user input sanitized, and inserted into DB, I create a session var:

<?php
// if result
if($result === true)
{
     // create a session var
     $_SESSION['inserted'] = 1;
}
?>

before you add data, you can check to see if the values were already inserted by testing for the presence of this session

<?php
// if post is set, BUT session var "inserted" isn't
if(isset($_POST) && !isset($_SESSION['inserted']))
{
     // insert data...
}
?>

SO, putting it all together, you could try this:

<?php
// start session
session_start();

// if form has NOTE been submitted
if(!isset($_POST['submit']))
{
     // display form
     include('form.php');
     echo $form;
}

// else the form was submitted, process form:
else {
     // if session var set
     if(isset($_SESSION['inserted']))
     {
          echo 'Your data has been saved in the db.';
     }

 // else insert data after cleansing & sanitizing it
 else {
      $result = mysql_query($query) or die(mysql_error());
      if($result)
      {
           // set session var
           $_SESSION['inserted'] = 1;

           // confirm to user
           echo 'you did it, you!';
      }
 }
}

?>

this is just the general idea... hope this helps...