date format problem

mattastic

Hi,

I get this error when I try and populate drop down boxes by exploding the dob.

Can anybody help?

Thankyou

Warning: date() [function.date]: Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in C:\Program Files\xampp\htdocs\edit-adult.php on line 21

$startdatevalues = explode("-", $myrow["adultDOB"]);
$startyear = $startdatevalues[0]; // year 
$startmonth = $startdatevalues[1]; // month
$startday = date("d", mktime(0, 0, 0, 0, $startdatevalues[2], 0)); // day

Blulagoon

date(); and mktime(); don't support dates before the unix epoch of Jan 1st 1970 on the Windows platform.

devinemke

Blulagoon wrote:
date(); and mktime(); don't support dates before the unix epoch of Jan 1st 1970 on the Windows platform.

yes they do...if you are using PHP 5.1 or higher

Blulagoon

devinemke wrote:
yes they do...if you are using PHP 5.1 or higher

Do they :o

Hastily upgrades from 5.0.5 to 5.1.2

Oh yes so they do, even using IIS as the web server ....

Well that solves Mattastic's problem 🙂

Blu

mattastic

Thanks for the replies. However this is weird, because i have a similar page that accepts those dates just fine.


//This is the code that flags up the error:

$query = "SELECT *
FROM  tbladult
WHERE adultid = '$adultid'";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
if (!$myrow = mysql_fetch_array($result))   echo "Sorry, no records were found!";	


$startdatevalues = explode("-", $myrow["adultDOB"]);
$startyear = $startdatevalues[0]; // year
$startmonth = $startdatevalues[1]; // month
$startday = date("d", mktime(0, 0, 0, 0, $startdatevalues[2], 0)); // day

// this code works fine

$query = "SELECT *
FROM  tblpupil
WHERE pupilid = '$pupilid'";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
if (!$myrow = mysql_fetch_array($result))   echo "Sorry, no records were found!";	

$startdatevalues = explode("-", $myrow["pupilDOB"]);
$startyear = $startdatevalues[0]; // year
$startmonth = $startdatevalues[1]; // month
$startday = date("d", mktime(0, 0, 0, 0, $startdatevalues[2], 0)); // day
?>

Blulagoon

I notice in the code that works, reference is made to pupilId.

The dates will be accepted fine, if they are between Jan 1st 1970 and today, you will only have problems with dates prior to Jan 1st 1970, so if you are talking about birthdays you'd have to have pupils older than 35 to have a problem. You only need one adult in the result set born before Jan 1st 1970 to upset the system

You can upgrade to PHP 5.1 and the problem disappears, and you can deal with dates between 1903 and 2037 (this limit is imposed by 32 bit architecture)

HTH - Blu