Values getting posted

[strings]

THis is a very serious problem i am facing.
When i enter any value in textbox1 and i clcik submit , the values are getting enetered into database.upto to here its ok.
The problem is when i refersh the page the values are getting entered
into database automatically.
ple anyone sort this prob.

thanks.
AMit.

if(isset($_POST['submit']))
{

if($_POST['textbox1']!="")
{
$qu = "insert into allmail (email) values('".$_POST['textbox1]."') ";
mysql_query($qu) ;
}

}

[Habtom]

This is more of a logic question than a problem with the code.

Once the values are submitted you can redirect, the page to a different page where you can thank them for posting the comments or similar.

Please also note that you need to learn ways to clean customer data before you directly add into an SQL statement as you did.

[PHP_Chimp]

When you refresh a page where a post has been made there is generally a warning that comes up in the browser to say that if you refresh you make another post. As the post request is sent with the http request for the page. So when a new request is sent for the same page then there is another post sent.

So an easy way around that would be to redirect the browser to another page after the information has been entered into the database. This will then clear the original post sent, unless people go back to that page again.

if(isset($_POST['submit'])) {
if($_POST['textbox1']!="") {
$qu = "insert into allmail (email) values('".$_POST['textbox1]."') ";
$result = mysql_query($qu) ;
if (!$result) {
echo 'It died...try again later';
}
else {
header('Location: some_other_page.php');
}
}
}

I dont know if you are checking the data with another function but I would suggest that you look at mysql_real_escape_string [uk.php.net] before you put that code live.

[Romeo]

... and furthermore, additionally to what has been already suggested, some logic could be added to first do a SELECT to see if the data is already there before INSERTing -- or not.

Kind regards,
R.