MySQL query or condition to fetch "1970-01-01" date value in the table cell Options

[shankar from vizag]

Greetings

I have a mysql table with date column cell. At the time input from the php page, if a date type input left blank which is saving 1970-01-01 as the cell value.

When I use select query to display records, those particular fields displaying 1970-01-01.

Could anyone help me either in saving the empty date field as 1970-01-01 as blank

or

a condition to display a blank field in the php page by the select query when the cell value contains 1970-01-01.

Regards
shankar

[CharlesEF]

You've posted new code about reading a database but you haven't answered my questions. Lets fix the INSERT problem first.

What is the result of the 2 tests I asked you to run in MySQL Workbench or phpMyAdmin?
What is the result of the PHP code I posted a few days later? That code is based on the fact that PHP and MySQL NULL values are different. So instead of passing a PHP NULL value I want to try passing a MySQL NULL value. On the PHP side it is just a string. On the MySQL side it should be a MySQL NULL value. But I need you to run the test.