OLM3CA Posted September 19, 2006 Share Posted September 19, 2006 hello.I have a form including name,surname,age etc... If the user miss one of them,the form alerts the user that he/she missed a part but when they fill all of them and submits the form,The form submitted.but the problem is when you refresh page everytime the page submitted with the same datas.I use [code]$_POST['name'] = "";$_POST['surname'] ="";$_POST['age'] = "";[/code]after if the form values entered.But nothing changes.if you refresh the page ,the form submitted everytime it refreshed. Quote Link to comment Share on other sites More sharing options...
willfitch Posted September 19, 2006 Share Posted September 19, 2006 A quick fix to this could be the following scenario:Let's assume your script name is called contact.php. 1. Make your POSTed form action contact.php?somethere_here2. Once validation is complete, and the user has passed, insert the data and header back to contact.php. Quote Link to comment Share on other sites More sharing options...
OLM3CA Posted September 19, 2006 Author Share Posted September 19, 2006 I am including this page in index.php and form action is :[code]action="index.php?page=newpost"[/code]How can I do ? and can you tell me how can header back to page header("Location: contact.php"); ??? Quote Link to comment Share on other sites More sharing options...
craygo Posted September 19, 2006 Share Posted September 19, 2006 Using php you have to submit the form and the server will check for errors according to your code. If you want just a simple check you can use javascript to check for blank field data. This will check before the form is submitted.This guys has some good tutorials for javascript as well as some basic php stuffhttp://www.tizag.com/javascriptT/javascriptform.phpRay Quote Link to comment Share on other sites More sharing options...
OLM3CA Posted September 19, 2006 Author Share Posted September 19, 2006 I think you dont exactly understand my question.My problem is not with the control of form values.My problem is when the form is correctly filled and submitted.Its ok but after you REFRESH the page ıt submits those values again and again with refreshing the page Quote Link to comment Share on other sites More sharing options...
craygo Posted September 19, 2006 Share Posted September 19, 2006 O I see. Well the first thing would be to put a check in your insert query to see if the value is there already. e-mail would be a good thing to use[code]<?phpif(isset($_POST['submit'])){ // checks to see if form has been submitted$email = $_POST['email'];$sql = "SELECT * FROM tablename WHERE email_field = '$email'"; $res = mysql_query($res) or die (mysql_error()); $num_rows = mysql_num_rows($res);if($num_rows > 0){echo "Name already exists in the database";} else {// do your insert query here}} else {// Show your form below or whatever}[/code]Ray Quote Link to comment Share on other sites More sharing options...
OLM3CA Posted September 19, 2006 Author Share Posted September 19, 2006 Thank you very much Its ok now. Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted September 19, 2006 Share Posted September 19, 2006 There are a few ways you could go about handling this situation depending on the nature of the form.My understanding is that there are limitations depending on the database fields and how they're defined, but usually requiring that some combination of data be unique within your table will solve this problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.