Inserting date in null

Question

I am inserting date. It works when date is set, otherwise, it doesn't work.

DateBirth type is date and its default value is NULL.

Here is my php

$date_birth = isset($_POST['date_birth']) ? $_POST['date_birth'] : NULL;

Here is mysql

$adding_birth = "INSERT INTO person (DateBirth) VALUES ('$date_birth')";

How can I get date field in null?

`'$date_birth'` would mean the string `'NULL'`, by the way which your `DATETIME` field would not accept — Anurag Srivastava, Jul 06 '20 at 16:34
i think you have set your `DateBirth` column as `NOT NULL` in your database. — Hirumina, Jul 06 '20 at 16:34
use prepared statements this helps against and also with NULL values see https://stackoverflow.com/questions/1391777/how-do-i-insert-null-values-using-pdo — nbk, Jul 06 '20 at 16:44

score 0 · Answer 1 · answered Jul 06 '20 at 16:35

0

You need to have NULL as string:

$date_birth = isset($_POST['date_birth']) ? $_POST['date_birth'] : 'NULL';

when PHP replaces variable in a query string - $date_birth is replaced by empty string, while you need a string NULL

answered Jul 06 '20 at 16:35

Distdev

2,312
16
23

Have you tried this code yourself? – Anurag Srivastava Jul 06 '20 at 16:40
@AnuragSrivastava I have tried this code but I get incorrect date value message. – ewef Jul 06 '20 at 16:44
@ewef Yes the question was for Distdev – Anurag Srivastava Jul 06 '20 at 16:49
@AnuragSrivastava cuz you close this question – ewef Jul 06 '20 at 16:51

score 0 · Accepted Answer · answered Jul 06 '20 at 16:37

You are currently adding NULL as an STRING to your database. You have to rewrite your SQL command to:

$date_birth = isset($_POST['date_birth']) ? "'" . $_POST['date_birth'] . "'" : 'NULL';
$adding_birth = "INSERT INTO person (DateBirth) VALUES ($date_birth)";

When you do an echo in front of the SQL you will get, with the NULL in your case:

$adding_birth = "INSERT INTO person (DateBirth) VALUES ('NULL')";

And correct is:

$adding_birth = "INSERT INTO person (DateBirth) VALUES (NULL)";

Inserting date in null

2 Answers2