[RESOLVED] Setting back to NULL

[zzz]

I have a db table field which is NULL by default. If user provides some input I populate the cell, however if the user removes the data, and re-submits the form I need it to be set to NULL again.

I've tried:

if (isset($_POST['userInput'] )) {
	$storeInDB = $_POST['userInpu'];
} else {
	$storeInDB  = NULL;
}

but it just leaves the field blank...

How do I reset it to NULL?

[laserlight]

You need to set it to NULL in the SQL statement, not set the variable in PHP. What you are probably doing now is just using $storeInDB in the SQL statement, but the SQL statement syntax has the field set to a string anyway.

[zzz]

No, I was actually using this var in query

UPDATE t1 SET userData = ".$storeInDB."
$storeInDB

But I think I understand now. It should be something like this:

if (isset($_POST['userInput'] )) {
    $storeInDB = "'".$_POST['userInpu']."'";
} else {
    $storeInDB  = 'NULL';
}

[laserlight]

More like:

if (isset($_POST['userInput'] )) {
    $storeInDB = "'".$_POST['userInpu']."'";
} else {
    $storeInDB  = 'NULL';
}

Of course, you still have to escape the incoming variable.

[zzz]

yep, I just correct my post. Learned the hard way... again.

😉