code to deal with null values ?

sheepsheep

I have a problem where I need to upload fields from a csv file that are empty, and they need to remain empty.

the fields are in the datetime format, and so when they are inserted into mysql they show a string of 0's in the datetime format, rather than a blank field which is what I want.

In VB there is a function that can be used to handle Nulls

Nz( Variant,Value)
If Variant is anything other than Null then Nz simply retruns Variant untouched
If Variant is Null then Nz returns Value
So you can use
If Nz(Removed,0) = 0 Then when means Null and Zero get treated exactly the same.

Does PHP have an equivalent ?

NogDog

I think you'll have to convert empty strings to the SQL keyword NULL in your query. You could use str_replace(), something like:

$query = str_replace("''", 'NULL', $query);

MarkR

I imagine that in a PDO prepared statement, passing the PHP value NULL into a placeholder will result in a NULL being entered in the database. I'm not sure if I've tried it though. Try it yourself, e.g.

 // Assuming $db is an already established PDO object
 $st = $db->prepare('INSERT INTO blah (x,y) VALUES (?,?)');
 $st->execute(array(42, NULL));

Mark