On Fri, 10 Jan 2014 17:36:27 -0500, Jim Giner wrote:
On 1/10/2014 4:53 PM, Robert wrote:
I have a date field on an html form that users may leave blank. If
they do leave it blank I want to write the date 01/01/1901 into the
mysql table. How can I accomplish this and where in my .php script
file should I put the code?
Thank You,
Robert
flahurr@xxxxxxxxxxx
Why would you want to put any value in there? Leave it blank. Are
you
editing the input to prevent someone from actually entering that
date?
Where to put this in your php script? That's up to you certainly,
but
I would make sure it was done before I posted my record.
It looks like a new semester has started....
MySQL
You can set the value to NOW() or CURRENT_TIMESTAMP(), mysql functions and
format the date the way you want.
if(!empty$_POST['formdatefield'])) { // POST is just an example
$sql = "INSERT INTO yourtable SET datefield=DATE_FORMAT(NOW(),'%m\%d\%Y') ";
}
PHP
Validate the date has been set. If not set then set the value to system
current system date.
if(!empty($_POST['formdatefield'])) { // POST is just an example
$formdatefield = date("m/d/Y");
$sql = 'INSERT INTO yourtable SET datefield='.$formdatefield;
}
There are many way to validate POST or GET variables and declare a new
value.
Richard L. Buskirk
Oracle Certified MySQL 5.6 DBA (OCP)
