how to prevent page to save values in database after page refresh?

Question

I am using an html form , php , mysqli to save information . My form is working good but after clicking on submit button if i m refreshing the page then my mysql is saving values again and agian . what to do to stop this?

my code part

 public function registration($name,$email,$en_pass)
    {
    $sql="INSERT INTO register_user (register_name, register_mail, register_password) VALUES ('$name', '$email' ,'$en_pass')";
    if( mysqli_query($this->con, $sql))
    {
     echo "Registration successfull. Wait for approvel.";
    }

Add tokens to each request (post/get values and session) and unset session value after success and if the value isn't in session/get/post don't execute register — Class, Apr 23 '14 at 06:11

score 2 · Answer 1 · answered Apr 23 '14 at 06:13

2

You can redirect to some page after processing the form :

header('Location:nextpage.php');

That would redirect you back to the form page, and if you refresh, the browser wont resend the form data.

answered Apr 23 '14 at 06:13

Rakesh Shetty

4,548
7
40
79

What about back button and accept to resubmit data? – Class Apr 23 '14 at 06:19
@Class in this situation he can set some flag when the form is in first time processing and he have to check flag is set or not – Rakesh Shetty Apr 23 '14 at 06:23

how to prevent page to save values in database after page refresh?

1 Answers1