Ask a Question related to PHP Development, Design and Development.
-
Martin Brunner #1
Countries and TimeZones
I want to make a list like [url]http://www.rs-data.at/martin/ausgabe.html[/url].
People can enter the data at [url]http://www.rs-data.at/martin/eingabe.html[/url]
(doesn't work yet).
This is a list when competitions for a certain game start. The green and
red light should start flashing 10 minutes before the cup starts.
But the problem I have: The guys who start the server for a competiton
might be in different countries. So how can I figure out when the light
should start flashing?
I thought of creating a drop-down box for entering the country in the
entry-formular and binding this drop-down with a info of the current
time zone. But summer and winter time might chance and also some
countries have different Time Zones.
Maybe I could get the local time from his computer, or maybe something
else?
Martin Brunner Guest
-
Why does 'SELECT * FROM countries' truncate characters and SELECT country FROM countries does not ?
Hi, Why does 'SELECT * FROM countries' truncate characters and SELECT country FROM countries does not ? mysql> SELECT * FROM countries;... -
How to make now() and different timezones get along
As my title and summary suggest, I just started using the now function, mainly for keeping track of when users last logged in. The question is, how... -
Countries Database - a little OT
Does anyone know of a freely downloadable list of all the countries in the world. Any format I can pull into SQL server. Regards. -
Converting Time between timezones?
Hi, ruby comes with the standard unix time conversion functions such as gmtime and localtime. Is there a simple method to convert time into... -
[PHP] Timezones and Daylight Savings Time
What if you set the server to use UTC and then used the clients local system setting to offset it for each client? So the server would have it's... -
Monika Beisel #2
Re: Countries and TimeZones
Hi Martin,
Martin Brunner schrieb:
You could get the local time of the client computer (via JavaScript).> But the problem I have: The guys who start the server for a competiton
> might be in different countries. So how can I figure out when the light
> should start flashing?
>
> I thought of creating a drop-down box for entering the country in the
> entry-formular and binding this drop-down with a info of the current
> time zone. But summer and winter time might chance and also some
> countries have different Time Zones.
>
> Maybe I could get the local time from his computer, or maybe something
> else?
But why would you want to do it in such a complicated manner? Why not
just use the local time on your own webserver? Should be accessible
through PHP enviroment variables, though ...
It seems to me that the time function should do the trick:
[url]http://de3.php.net/manual/en/function.time.php[/url]
--
________________________________
Monika E. L. Beisel
Universität Kaiserslautern
E-Mail: [email]beisel@rhrk.uni-kl.de[/email]
Monika Beisel Guest
-
Martin Brunner #3
Re: Countries and TimeZones
Monika Beisel schrieb:
I guess people enter their times and don't want to calculate much. Also>You could get the local time of the client computer (via JavaScript).
>But why would you want to do it in such a complicated manner? Why not
>just use the local time on your own webserver? Should be accessible
>through PHP enviroment variables, though ...
the Server is in the US and most competitors are from Finland, so it
might be confusing for them always to add 8 hours just to know when the
next competition starts.
Martin Brunner Guest
-
Monika Beisel #4
Re: Countries and TimeZones
Martin Brunner schrieb:
There are 2 possibilities:> Monika Beisel schrieb:
>
>>>>You could get the local time of the client computer (via JavaScript).
>>But why would you want to do it in such a complicated manner? Why not
>>just use the local time on your own webserver? Should be accessible
>>through PHP enviroment variables, though ...
>
> I guess people enter their times and don't want to calculate much. Also
> the Server is in the US and most competitors are from Finland, so it
> might be confusing for them always to add 8 hours just to know when the
> next competition starts.
- people "start the race" by clicking the button exactly ten minutes
before the race starts (then you can use your server time)
- or -
- people enter the starting time *WITH* the appropriate time zone of the
location where the race is going to take place. You should use a
dropdown list like "GMT + 1: Berlin", "GMT: London", etc. You can store
the values in your database in a special time format including the time
zone.
--
________________________________
Monika E. L. Beisel
Universität Kaiserslautern
E-Mail: [email]beisel@rhrk.uni-kl.de[/email]
Monika Beisel Guest
-
Don Crossman #5
Re: Countries and TimeZones
Martin Brunner <mbrunner@mcnon.com> wrote in news:bkmcdt$3dpi5$1@ID-
819.news.uni-berlin.de:
Here's what I would do (and have): Use javascript to determine the user's> [url]http://www.rs-data.at/martin/ausgabe.html[/url]
timezone (getTimezoneOffset) and store it as a session variable. Store all
event times as GMT. I'm sure you can take it from there.
-- Don
Don Crossman Guest



Reply With Quote

