[blessedrub]

I have a form going to a database but I need to validate the form first Can anyone please help me with a php script that will validate the form before passing it to the database.

[Wuiqed]

Originally Posted by blessedrub

I have a form going to a database but I need to validate the form first Can anyone please help me with a php script that will validate the form before passing it to the database.

Here's the basic idea of how I do it:

Put this above the form in your form.php (or whatever the form page is called)

PHP Code:

//Check to see if notfilled=1 was passed along the URL

$notfilled = $_GET["error"];

if ($notfilled = 1) {

    Echo "You did not fill out all the fields of this forum";

} 

And this in the register.php (or whatever it is called)

PHP Code:

//Check to see wich fields was not filled.

//In this case, we'll just check if first name

//or last name was not filled.

//If it wasn't filled we'll send them back to the form

//and tell them it wasn't completely filled out.



if(empty($_POST['f_name']) || empty($_POST['l_name'])) {

    header("Location: form.php?error=1");

} 

[4n7hr4x]

i would just make it all in one php script, like so:

PHP Code:

<?php



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

$m = NULL;



if (empty($_POST['name'])) {

$n = FALSE;

$m .= '<p>Please enter a name.</p>';

} else {

$n = $_POST['submit']

}



if ($n) {

$query = "QUERY";

$result = @mysql_query ($query);



if ($result) {

echo '<p>Message</p>';

} else {

echo ' could not do w/e due to system error.</p><p>' . mysql_error() . '</p>';

}

if (isset($m)) {

echo '<font color="red">', $m, '</font>';

}

}

}

?>

almost the entire code, just added some so you know how it all works, post anyquestions, and of course you would make the form after, action being:

PHP Code:

<?php echo $_SERVER['PHP_SELF']; ?>

or just the file name itsself.

[blessedrub]

I've tried several things but I can't figure out why I'm recieving the following error: document.webform. FirstName.value is null or not an object

This is the following code.
<SCRIPT LANGUAGE="JavaScript">
<!-- The JavaScript Source!! http://javascript.internet.com -->
<!-- Begin
function checkFields() {
missinginfo = "";
if (document.webform.FirstName.value == "") {
missinginfo += "\n - FirstName";
}
if ((document.webform.LastName.value == "") ||
(document.form.from.value.indexOf('@') == -1) ||
(document.form.from.value.indexOf('.') == -1)) {
missinginfo += "\n - Last Name";
}
if ((document.webform.Address.value == "") ||
(document.form.website.value.indexOf("http://") == -1) ||
(document.form.website.value.indexOf(".") == -1)) {
missinginfo += "\n - Address";
}
if(document.webform.Email.value == "") {
missinginfo += "\n - Email";
}

if (missinginfo != "") {
missinginfo ="_____________________________\n" +
"You failed to correctly fill in your:\n" +
missinginfo + "\n_____________________________" +
"\nPlease re-enter and submit again!";
alert(missinginfo);
return false;
}
else return true;
}
// End -->
</script>
</HEAD>

And the form code is
<form name ="webform" action = "tryHELP.php" method = post onSubmit="return checkFields();">
<p>
<input type="checkbox" name="join" value="checkbox">
Yes I would like to become a Total Victory Partner.<br>
<br>
I would like to contribute the following on a monthly basis<br>
(Please enter the amount in 20, 50, 100 format without the decimal)</p>

<p align="center">
<input type= Text Name= "Array[Amount]" size="10">
</p>
<p align="center"> First Name
<Input Type = Text Name = "Array[FirstName]" Size = 20>
<br>
Last Name
<Input Type = Text Name = "Array[LastName]" Size = 40>

[webx2000i]

Try to add form id = "webform"
***********************
I think the best way to validate a form is to start on the client side using javascript then on the server side using php since javascript can be disabled by the user.