MySQL query or condition to fetch "1970-01-01" date value in the table cell |
MySQL query or condition to fetch "1970-01-01" date value in the table cell |
shankar from vizag |
Dec 9 2023, 08:33 PM
Post
#1
|
Advanced Member Group: Members Posts: 202 Joined: 18-June 13 Member No.: 19,316 |
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 |
Dec 23 2023, 04:29 AM
Post
#2
|
Programming Fanatic Group: Members Posts: 1,981 Joined: 27-April 13 From: Edinburg, Texas Member No.: 19,088 |
It's been many years since I've used mysqli so you might have to try this. Use this line for the $dob:
CODE $dob=empty($_POST['dob']) ? null : "'{$_POST['dob']}'"; Then change this line: CODE $query="INSERT INTO date(name,date) VALUES('$name', '$dob')"; To this: CODE $query="INSERT INTO date(name,date) VALUES('$name', $dob)"; Let me know which one works. |
Lo-Fi Version | Time is now: 14th June 2024 - 10:13 AM |