date()?

lukeurtnowski

I have a form w/a date field where the user is suposed to enter a date like (06/07/06) but how do I ensure that date is written to the database in its regular format while it is to be displayed in the regular format (at least in the USS)
I looked at date() but was totally confused on how to implement it.
When the field on the form is filled out, It is emailed to me using mail()

$message .= "Date: <input type=text name=Review_Date value="."$Review_Date"."><br />";

The variable, $Review_Date is the one im trying to force into the format (m/d/Y), then converted so it could be written to the database in the correct format, and finally when I display the date it would jump back to the US format for dates, any help would be super, thanks

Houdini

This might help you out if you have a newer version of PHP 5.

<?php
/*Note:  The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer.) Additionally, not all platforms support negative timestamps, therefore your date range may be limited to no earlier than the Unix epoch. This means that e.g. dates prior to Jan 1, 1970 will not work on Windows, some Linux distributions, and a few other operating systems. PHP 5.1.0 and newer versions overcome this limitation though.*/
//to convert a time for MySQL 
$myinput='12/15/2005';
$sqldate=date('Y-m-d',strtotime($myinput));
echo "MySQL date for 12/15/2005 is <b>".$sqldate."</b><br />";
//Monday April 10,2006 your example date
$testdate="2006/4/10"; 
$mydate = date('l F j, Y',strtotime($testdate));
echo "My testdate for 2006/4/10 is <b>".$mydate."</b><br />";
$mssqldate='23 May 2006';
$mydate=date('d/m/Y',strtotime($mssqldate));
echo "\$mydate now equals <b>".$mydate."</b><br />";
$mysqldate ='1963-11-10';
$mydate = date("m-d-Y",strtotime($mysqldate));
echo "My date is now <b>$mydate</b>! for my entry of 1963-11-10 (MySQL)<br />";//PHP 5.1.0 + only all OS's
 ?>