mysql 变量为空插入失败,将NULL变量插入数据库

I have variable set to NULL that im trying to insert into a database but for some reason they keep getting submitted as '0'. Im positive that column im trying to inset into allows NULL and that the default is set to to NULL. Heres my code:

$insert = NULL;

$query = mysql_query("INSERT INTO `table1` (column1) VALUES ('$insert')") or die(mysql_error());

解决方案Warning:

Please, don't use mysql_* functions for new code. They are no longer maintained and the community has begun the deprecation process. Instead you should learn about prepared statements and use either PDO or MySQLi.

IF you want it to be NULL (and you really really still want to use mysqli_*) in the database you can do the following:

$insert = NULL;

$query = mysql_query("INSERT INTO `table1` (column1) VALUES ("

.(($insert===NULL)?

"NULL":

"'".mysql_real_escape_string($insert)."'").

")") or die(mysql_error());

But this could lead to nefarious SQL injection and is not recommended.

So: all in all you should be using prepared statements.

You can use MySQLi like so:

$dbHandle = new mysqli(...);

$query = "INSERT INTO `table1` (column1) VALUES (?)";

$statement = $dbHandle->prepare($query);

if($statement){

$statement->bind_param('s', $insert);

if(!$statement->execute()){

echo "Statement insert error: {$statement->error}";

}

$statement->close();

}

else {

echo "Insert error: {$dbHandle->error}";

}