Time Zone Question

JYM · 05-08-2006, 09:38 PM

Hi

I have a mysql database which has dates and times in it, which is displayed on my website.

Is there a way to grab the user's local machine, determine the time offset, then apply it so that all the dates on the site are according to the timezone?

This will probably require javascript or php, and I know for SURE that it works in Flash because in the actionscript i typed in a few lines and it displayed the local machine time. When I changed my computer's time, it would change in the flash file.

mikesherov · 05-09-2006, 11:07 AM

the reason why the flash displays the right time is because the value you are displaying IS the local time (which in flash and javascript use the machine local time because they are apps whihc run on your computer... javascript and flash are client side programs).

However, PHP has no access to your local machine because it's a preprocessor... all code is run before being sent to the local machine, i.e. server side.

You could use IP to location technology to determine the user's timezone, than transform the dates based on the timezone difference. Be careful to watch out for locations that don't observe Daylight Savings Time!

JYM · 05-09-2006, 03:26 PM

So is there a way to capture the time on the local machine, send it to the server, then have the server process it and change it accordingly so all the dates/times display correctly to that user?

Then..say..do this to each individual user (1000s...).

Jim_ · 05-09-2006, 04:56 PM

if the user doesn't have the cookie set {
use javascript to determine user's timezone, set it into cookie, then reload page
} else {
read cookie for user's timezone and display corrected time
}

05-08-2006, 09:38 PM	#1 (permalink)
JYM Senior Member Join Date: Sep 2005 Location: San Diego, California Posts: 1,078 87.41 NP$ (Donate)	Time Zone Question Hi I have a mysql database which has dates and times in it, which is displayed on my website. Is there a way to grab the user's local machine, determine the time offset, then apply it so that all the dates on the site are according to the timezone? This will probably require javascript or php, and I know for SURE that it works in Flash because in the actionscript i typed in a few lines and it displayed the local machine time. When I changed my computer's time, it would change in the flash file. __________________ Ipzy.com - Free Proxy to visit Myspace/Facebook, Tech News, and more! Onlineness.com - Free Proxy FOR SALE: support.im \| tradepile.com

05-09-2006, 03:26 PM	#3 (permalink)
JYM Senior Member Join Date: Sep 2005 Location: San Diego, California Posts: 1,078 87.41 NP$ (Donate)	So is there a way to capture the time on the local machine, send it to the server, then have the server process it and change it accordingly so all the dates/times display correctly to that user? Then..say..do this to each individual user (1000s...). __________________ Ipzy.com - Free Proxy to visit Myspace/Facebook, Tech News, and more! Onlineness.com - Free Proxy FOR SALE: support.im \| tradepile.com

05-09-2006, 04:56 PM	#4 (permalink)
Jim_ NamePros Regular Join Date: Aug 2005 Posts: 585 285.40 NP$ (Donate)	if the user doesn't have the cookie set { use javascript to determine user's timezone, set it into cookie, then reload page } else { read cookie for user's timezone and display corrected time } __________________ ask me about the internet

05-09-2006, 11:07 AM	#2 (permalink)
mikesherov NamePros Member Join Date: Apr 2005 Posts: 116 134.00 NP$ (Donate)	the reason why the flash displays the right time is because the value you are displaying IS the local time (which in flash and javascript use the machine local time because they are apps whihc run on your computer... javascript and flash are client side programs). However, PHP has no access to your local machine because it's a preprocessor... all code is run before being sent to the local machine, i.e. server side. You could use IP to location technology to determine the user's timezone, than transform the dates based on the timezone difference. Be careful to watch out for locations that don't observe Daylight Savings Time!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)