pass null if selected is null

[jrahma]

Hi,

I have a <select> drop down in my php. I want to set the first item as NULL then determine in my PHP if it's null or not.

If NULL then pass a NULL through the PDO, otherwise save the integer alue.

something like this:

<option value="<?php echo null; ?>">[Select..]</option>

if ($member_title != NULL) { $mysql_query->bindParam(':param_member_title', $member_title, PDO::PARAM_INT);}
else {$mysql_query->bindParam(':param_member_title', NULL, PDO::PARAM_NULL);}

can anyone help please... Thanks...

[dalecosp]

How about a null string?

<option value="">[Select..]</option>

if (!strlen($member_title)) {
   $mysql_query->bindParam(':param_member_title', NULL, PDO::PARAM_NULL); 
} else {
   $mysql_query->bindParam(':param_member_title', $member_title, PDO::PARAM_INT); 
}

[sneakyimp]

if you echo NULL, then PHP will automatically cast NULL as a string (the empty string to be precise) so echoing NULL accomplishes nothing.

Your comparison to NULL on your form handler my work but it is not very precise because the input received in it is going to be text (either an int or string or the empty string) rather than a NULL value.

[jrahma]

Thanks dalecosp. It worked but I had to add something in your code to look like this:

if (!strlen($member_title)) { $mysql_query->bindParam(':param_member_title', $member_title = NULL, PDO::PARAM_NULL); }
else { $mysql_query->bindParam(':param_member_title', $member_title, PDO::PARAM_INT); }

Thank You