如果某些值为空，则将$ _POST值插入MySQL表中

Question

I have (in short) code like this:

...
mysql_query("INSERT INTO table1 (x,y,z) VALUES (".$_POST['a'].",".$_POST['b'].",\"".$_POST['c']."\")");
...

a is numeric value, b is numeric but empty in form and c is string value, which can be empty(there is no problem).

Tthen for MySQL it looks like this:

INSERT INTO table1 (x,y,z) VALUES (2,,"");

Problem is part of values, where is nothing like in b. Is there any solution to get it work? In database settings, or in PHP. I have big table and it is not possible to check every $_POST value.

thanks

Answer 1

Just test for $_POST['b'] value, replacing it by null if empty or not set (adapt the solution to the empty value of $_POST['b'] you're getting from your form):

mysql_query("INSERT INTO table1 (x,y,z)
    VALUES (".$_POST['a'].",".((isset($_POST['b']) || $_POST['b']=="") ? $_POST['b'] : "NULL").",\"".$_POST['c']."\")");

As an aside, don't use mysql_* extension as they’re deprecated. Use PDO or MSQLi instead.