阻止刷新按钮存储旧数据

Question

I'm trying to create a register page and I am having problem when storing the data.
When I successfully register, it stores to database.
But when I reload it again, it automatically stores the same old data I typed to database.
How to solve this problem?

My simple php code looks like this

if (empty($fname)) {
    echo '';
} else {
    $success = ("
        INSERT INTO customer
            (FName, LName, Email, Password, MobileNum, PostalCode)
        VALUES
            ('$fname','$lname', '$email', '$password', '$mobilenumber','$postalcode')
    ");
    mysql_query($success);
    echo 'success';
}
?>

Answer 1

Presuming that you're using an HTTP POST request when you "store" the data, the easiest way to ensure that re-loading the page doesn't do a re-POST of the same data is to do a redirect at the end of your script.

Instead of doing echo 'success' do Header("Location: ?")

That way, the browser does a GET immediately after the POST. If the user refreshes the resulting page, they simply re-request the GET. (or do nothing at all if caching is in play).