bindParam and NULL int values

Question

I am using bindParam to set values for a MySQL insert. The column in question is an INT (11). It has a default of NULL and null is allowed. However, using bindParam it always receives a 0. I have confirmed that my $_POST['value'] is indeed null.

if(isset($_POST['value'])){
  $stmt = $db->prepare("INSERT INTO table (column) VALUES (:column)");
  $stmt->bindParam(':column',$_POST['value'], PDO::PARAM_INT);
  $stmt->execute();
}

It keeps inserting a '0' instead of NULL if the POST value was ''.

`column` is a reserved word in mysql -> http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html — Black Sheep, Jul 21 '14 at 00:25
@Darren good call.. it was not coming as NULL but as '', so I said if is '' set to NULL and it works. Thanks. — user3822370, Jul 21 '14 at 00:26

score 2 · Accepted Answer · edited May 23 '17 at 11:50

2

You should be matching the complete case (Answer and type) with === (^{Read More})

Which most likely means that your value is not null like you presume it is.

Ensure it is by checking (pseudo code below):

if(VALUE !=== NULL) {
   value = null
}

But you get the idea there? If not just comment :-)

And as aldanux mentioned in his comment, you have to wrap the column in backticks as it is a reserved word:

INSERT INTO table (`column`) VALUES (:column)

edited May 23 '17 at 11:50

Community

1
1

answered Jul 21 '14 at 00:30

Darren

12,924
4
37
76

1

Yes sorry was just for the example. – user3822370 Jul 21 '14 at 01:05

bindParam and NULL int values

1 Answers1