PHP Gurus,
I'm building a calendar which does some things like compare
dates. For example, if an event is in the past, then the link in the
calendar is made inactive. To do this I'm converting everything into
UNIX time stamps, so I can do simple "greater than" or "less than" type
equations to figure out which dates come in what order.
Here's how I've got it set up:
$currentMonth and $currentYear are the month and year that the
user has selected to look at. $dayCount is where I'm storing the date. I
build the calendar table by using a loop to put in the right date in
$dayCount and then echo it out in each table cell to draw a months worth
of dates.
So, to compare dates, I take these variables and make it into a
unix timestamp:
$dateFromPHP = mktime(' ',' ',' ',$currentMonth, $dayCount,
$currentYear);
Then, I get all the relevant event dates for that month from
MySQL, like so:
$query = "SELECT UNIX_TIMESTAMP(eventdate) FROM table WHERE
MONTH(eventdate) = " . $currentMonth;
I put the results into an array called $dateFromMySQL.
Okay, now here's where it gets wonky. If both PHP and MySQL are
set to default time zone settings, then this following command will
return some results:
if (in_array($dateFromPHP, $dateFromMySQL)
I use the results to determine if in any one table cell I need
to do some handling of events. If there are no matches in the array,
then I just echo out the date. As I say, this works fine when I don't
try to adjust time zones.
But, if at the top of my PHP script I declare the time zone as
being in Japan, like so:
putenv("TZ=Japan");
Then the in_array command never returns anything anymore.
I don't understand why this happens. Since I don't specify the
hours, minutes, or seconds, the time zone difference shouldn't apply.
I thought maybe MySQL needed to be set to have the same time
zone as the PHP script, but, according to my web hosting service, that
is impossible to set for just my site without affecting all the other
sites on the same server.
So I need to compensate for different time zones between my
script and my MySQL server. But I can't figure out how to do that since
I don't know why there is a difference in the first place.
Any help would be much appreciated.
--
Cheers!
Dave G
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
