PHP validating and Insert to database in one file??

drumdogg · 17 Sep 2012 at 16:16

I have a piece of php code which validates my form which works but would now like it to insert the data to database if there are no errors.

Is it possible to do so in the one php file??

Here is my php validation.

Code:

if ($_POST['submitted']==1) {   
    $errormsg = ""; //Initialize errors   
   if ($_POST[TestTime]){   
        $TestTime = $_POST[TestTime]; //If title was entered   
    }   
   else{   
        $errormsg = "Please enter TestTime";   
    }   
    if ($_POST[PassFail]){   
       $PassFail = $_POST[PassFail]; //If comment was entered   
    }   
   else{   
        if ($errormsg){ //If there is already an error, add next error   
            $errormsg = $errormsg . " & content";   
       }else{   
           $errormsg = "Please enter content";   
        }  
			if ($errormsg){ //If any errors display them   
    			echo "<script type='text/javascript'>alert('$errormsg')</script>";

   
	} 	
    }  
		

 
}

Thanks

drumdogg · 18 Sep 2012 at 08:36

Edward01, thanks for the reply and thanks for explaining the code etc.

The only thing is that i wont insert to the database. It flags up the error message when it should but when fields are filled in it wont insert into the database. Just get a blank page with no connection error. Plus i have changed the username, password etc to my own details.

Will have another look through to see if i can find the issue. Thanks again

drumdogg · 18 Sep 2012 at 12:07

Ok got it working.

I set each variable as so:

Code:

$TestTime = mysql_real_escape_string($_POST['TestTime']);

And then just put the variable into the VALUES part.

Another quick question.

I would like the users input data to be saved if an error occurs and for it to be redirected back to the form page with their values in it. I had this working before i used the code above but cant get it working now.

All i did was add this into the input field in the form.

Code:

value="<?php echo htmlspecialchars(@$TestTime['TestTime']); ?>"

All i get is the error message and then a blank page. Would like the error to appear and then direct the user back to the form page with their values saved.

drumdogg · 19 Sep 2012 at 09:51

Can anyone help me on how i can keep the users data if validation error occurs!! Please

drumdogg · 21 Sep 2012 at 08:09

Tried your code there but still cant get it working. Thanks for the reply.

drumdogg · 21 Sep 2012 at 11:06

Ok i have another issue that i would like a few ideas on the best way to go about it.

So basically the user will be filling in a form with testing values and if they meet the spec then it will pop up saying that the product has passed or failed. There is a column in my sql table which is Pass/Fail, so i would like the users values be be inserted into the table and then Pass or Fail to be inserted into the table depending on the test results. Can this be done??

I was thinking about getting the user to input the results, leave the Pass/Fail field empty and hit submit and then will pop up Pass/Fail and then for the form to return the values they inserted and then let the user type in either pass/fail and then all that data to be inserted into the table.

Any suggestions??