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,711 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
1 Answers
2
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,319
- 7
- 49
- 83