Form variables

[Anon]

How do I stop empty form variables from being inserted into my database?

If I have a variable from a form tag like <input type=text name=address> and that field doesn't get filled on a form and my SQL insert statement looks like.

sql="INSERT into contact ('id','address' values ('$id','$address') where id=4"

I get the string $address inserted instead of a null value

[Anon]

You can check if the variable is empty before use it, with something like this

if($address){$campo="'$address'"} else {$campo="NULL"};
sql="INSERT into contact ('id','address' values ('$id',".$campo.") where id=4"

[Anon]

Why not use Javascript to validate the form before it is sent to store the contents into the d'base?
Try something like
<Script language="JavaScript">
function validateform() {
if (form.address.value == "") {
alert( "Please enter your Address." );
form.address.focus();
return false ;
}
}
</Script>

<form action="doit.php" method=post onSubmit="return validateForm(this);">

<input type=text name=address>
<input type=Submit> </form>

[Anon]

Actually I want some of the fields not to be required. I just want a null value instead of the string $address inserted into the db.

I think the best way is to check what variables exist, if they dont assign a value.

Sanjeev wrote:

Why not use Javascript to validate the form before it is sent to store the contents into the d'base?
Try something like
<Script language="JavaScript">
function validateform() {
if (form.address.value == "") {
alert( "Please enter your Address." );
form.address.focus();
return false ;
}
}
</Script>

<form action="doit.php" method=post onSubmit="return validateForm(this);">

<input type=text name=address>
<input type=Submit> </form>