CODEWITHSUNDEEP
phpmysqlxhtmldouble-submit-prevention
Aaron
Aaron

Reputation: 4480

double submission when refresh php

I'm trying to correct the issue of double submit in my script. When I press submit it only updates mysql once(which is what I want). However, when I hit refresh it updates mysql again. It seems to ignore the if statement once the refresh button is hit. What would I do to stop this

here is my code

if (isset($_POST['submitButton'])) { 
//do something
 }


<form action = "table.php" method="post">
<label for="submitButton"></label>
<input type="submit" name="submitButton" id="submitButton"
value="Submit Form"/>
</form>

Upvotes: 3

Views: 11200

Answers (5)

Naftali
Naftali

Reputation: 146302

When you refresh the page - the POST IS SENT AGAIN

Some browsers actually warn you about that happening.

To prevent that I do:

if (isset($_POST['submitButton'])) { 
//do something

//..do all post stuff
header('Location: thisPage.php'); //clears POST
}


<form action = "table.php" method="post">
<label for="submitButton"></label>
<input type="submit" name="submitButton" id="submitButton"
value="Submit Form"/>
</form>

Upvotes: 7

Kevin Nelson
Kevin Nelson

Reputation: 7663

I usually don't worry about this and just rely on the user NOT re-posting unless they want to. However, if you want to forbid it, you can use a nonce.

http://en.wikipedia.org/wiki/Cryptographic_nonce

Upvotes: 1

Yipyo Ai
Yipyo Ai

Reputation: 101

I use a session to keep from reposting. 

session_start();

 if( isset($_SESSION['your_variable']) && 
     $_SESSION['your_variable'] == $_POST['your_variable'] ){
    // re-post, don't do anything. 
 }
 else{
    $_SESSION['your_variable'] = $_POST['your_variable'];
    // new post, go do something.
 }

Upvotes: 5

Benjamin Dubois
Benjamin Dubois

Reputation: 961

This is a standard behavior : when you reload the page, if it was posted, your browser replays the same request (with the POST).

To avoid this, you can use a redirection to the same page, with : 

 <?php
 header("location:".$mycurrentURl);

This will reload the page, via a get request. This will prevent double posts.

Upvotes: 2

Ujjwal Manandhar
Ujjwal Manandhar

Reputation: 2244

when you refresh the page. browser post all the data again. so the same thing happens again to overcome this after doing something redirect the browser to same page again once like this

    if (isset($_POST['submitButton'])) { 
         //do something

         header("location:table.php");
    }

Upvotes: 1

Related Questions