Php - Mysql在插入数据时默认为NULL

Question

I am trying to insert data into a MySql database with the query below.

$sqlQuery = "insert into abc set a='$var1', b=STR_TO_DATE('$b', '%d/%m/%Y')"

I get this error

Incorrect datetime value: '' for function str_to_date()

How can I default both a and b to NULL when the variable values are missing.

Answer 1

Don't Give mysql to change date format. Do it by your PHP code.

$a = !empty($_POST['var1']) ? $_POST['var1'] : null;
$b = !empty($_POST['var2']) ? date('d/m/Y', strtotime($_POST['var2'])) : null;
$sqlQuery = "Insert into abc(a,b) values('$a','$b')";