Setting Value Of Form Post To Null??

[twilitegxa]

Is there a way to insert 'Null' into a field if a form's posted values has been left empty? I want to allow a user to have the option of filling to a form field or not, but I would like to insert Null instead of a blank space into my form. Is this possible? I have a page that displays the optional field values, and if they are null, I have it set to not show.

[xcandiottix]

on the php page before you INSERT the form data into the db you would want something like:

 

$field1=$_POST['formfield1'];

 

if($field1 == ""){

$field1 = NULL;

}

 

Then when you have your insert:

 

INSERT (DBfield1) VALUES ($field1)

 

it should work for you. I'm not sure if you need to actually have $field1 equal to NULL or "NULL" since NULL is a php var. You may want to play with it.

 

Hope that helps

-K.candiotti

[twilitegxa]

I tried both with NULL and "NULL" and NULL leaves it blank, but does not set it to NULL and "NULL" makes it say NULL but doesn't set it to NULL. It just makes the value the word NULL. Any other suggestions?

[twilitegxa]

I think I can fix it by adding another if statement:

 

if ($variable != ""){

echo $variable;

}

 

Thanks for the help though. This appears to work.