How to prevent form data being re-submit when page is refreshed?

[ganesanji]

Hi,


I have written a simple php coding for getting the name , phone number and insert the values into data base. My problem is that when ever I just click the refresh button in the browser window, it will automatically previous inserted values are once again inserted into databse as a new entry.

Please anybody give the perfect coding which will avoid automatic insertion of previous values into database.....

I attched my coding below........

<form id="form1" name="form1" method="post" action="index.php">
Name:<input name="name" type="text" /><br />
Phone Number:<input name="pnumber" type="text" /><br />
<input type="submit" name="submit" value="submit" />
 
</form>
<?
$submit=addslashes($_POST['submit']);
if(isset($submit))
{
$name=addslashes($_POST['name']);
$pnumber=addslashes($_POST['pnumber']);
$sql="insert into details(phone,name) values ('$pnumber','$name')"; 
mysql_query($sql) or die('Could not Connect the database'.mysql_error());
echo"<script language=javascript>alert('Your details are stored successfully');</script>";
 
}
?>
 

Any body help me plz very urgent.........

thanks....

[shane3341436]

Yes it is the problem while refreshing the page.
Why don't you try to empty all the fields when the query is successful.
Or you can redirect the page to another page when the query is successful.
Or you can add a hidden field whose value u can set when clicking the submit button. Then you can check that hidden value while inserting the values.

[Atli]

Hi.

In this case, I would recommend submitting the form to a different page, which would then process the data.

If, however, you need to keep it all in the same form, consider something like this:

<?php
  # Check if the $_GET['sent'] element is set
  if(!isset($_GET['sent'])) {
    # Process the data
    #  Note, for the header function to work, nothing can be
    #  printed before it is called! 
    header("Location: ?sent=true");
  }
  else {
    echo "Your data has been added!";
  }
?>
<form action="?" method="POST">
  <!-- your fields here -->
</form>
 

[ganesanji]

Yes it is the problem while refreshing the page.
Why don't you try to empty all the fields when the query is successful.
Or you can redirect the page to another page when the query is successful.
Or you can add a hidden field whose value u can set when clicking the submit button. Then you can check that hidden value while inserting the values.

thanks..........
now its working fine.............

[ganesanji]

Hi.

In this case, I would recommend submitting the form to a different page, which would then process the data.

If, however, you need to keep it all in the same form, consider something like this:

<?php
  # Check if the $_GET['sent'] element is set
  if(!isset($_GET['sent'])) {
    # Process the data
    #  Note, for the header function to work, nothing can be
    #  printed before it is called! 
    header("Location: ?sent=true");
  }
  else {
    echo "Your data has been added!";
  }
?>
<form action="?" method="POST">
  <!-- your fields here -->
</form>
 

thanks for ur suggestions.....
it is working now fine