Let x is a column of the table t allowing NULL values.
Which value should $value variable take for the following PDO statement to insert NULL value?
$db->prepare("INSERT t SET x=:x")->execute(array(':x'=>$value));
Asked
Active
Viewed 2,864 times
1
-
Have you looked at http://stackoverflow.com/questions/371644/using-nulls-in-a-mysqli-prepared-statement ? – PM 77-1 Apr 02 '13 at 17:33
-
it is tagged with mysqli while question itself on PDO – Your Common Sense Apr 02 '13 at 17:34
2 Answers
3
You simply insert it as null:
$db->prepare("INSERT t SET x=:x")->execute(array(':x'=>null));
If you want, you can also add the data type of PDO::PARAM_NULL.
SeanWM
- 16,789
- 7
- 51
- 83
0
This was asked 9 years ago, so it may no longer be relevant, but SeanWM's existing answer, while it works, does not technically answer specifically what was asked because it does not assign any value to a variable.
Just for completeness:
Inserting the PHP null value into MySQL does result in NULL being inserted into the DB.
$value = null;
$sql = $db->prepare("INSERT t SET x=:x")->execute(array(':x'=>$value));
Output:
Note: be careful NOT to enclose the word null in quotes or it will insert the string "null" instead.
snoski
- 174
- 11