Řešení časových zón od Ivana Doležala
Z VirtlabWiki
V MySQL mam cas jako typ datetime v UTC. Casovou zonu si uzivatel nastavi pomoci vhodne volby v menu (i kdyz, jak ted googluji, da se zrejme vycist ruznymi zpusoby i z prohlizece) a dale se udrzuje v cookie:
<form action="changezone.php"> <?php printf('<select title="%s" name="selecttimezone">',msg_get_str('SELECT_TIME_ZONE')); foreach( tz_get_zone_list() as $key => $value ) { printf(" <option %s value=\"%s\">%s</option>\n",(tz_get_tz()==$key)?'selected':'',$key,$value); } ?> </form>
a v changezone.php nasledne
tz_set_tz($_REQUEST['selecttimezone']);
kdyz si chci vypsat nejaky cas, provadim v SQL:
select UNIX_TIMESTAMP(liveshow.starttime) as zacatek
a ziskanou hodnotu pak vypisu napriklad pomoci:
tz_strftime("%H:%M",$dennidata['zacatek'])
Kdyz chci vlozit cas, provadim zhruba toto:
$sql=sprintf( "REPLACE INTO liveshow SET starttime=from_unixtime(%s)", tz_mktime($hour,$min,$month,$day,$year))
Je potreba do OS nainstalovat podporu vsech myslitelnych casovych zon, v Debianu jde o jedno
dpkg-reconfigure locales
Doporucuji si ale pak pro kontrolu vypsat seznam vygenerovanych locales
locale -a
global $tz_preffered_tz;
// Check out /usr/share/zoneinfo/
$tz_timezones_list = array(
'HST' => 'HST',
'PST8PDT' => 'PST',
'MST7MDT' => 'MST',
'CST6CDT' => 'CST',
'EST5EDT' => 'EST',
'Universal'=>'UTC',
'WET' => 'WET',
'CET' => 'CET',
'EET' => 'EET',
'W-SU' => 'MSK',
'Singapore'=>'SGT',
'ROK' => 'KST',
'NZ' => 'NZT',
'NZ-CHAT' => 'CHAT'
);
function tz_get_zone_list()
{
global $tz_timezones_list;
return $tz_timezones_list;
}
function tz_name_timezone( $code )
{
global $tz_timezones_list;
if( array_key_exists($code, $tz_timezones_list) )
return $tz_timezones_list[$code];
else
return $code;
}
function tz_set_tz( $zone ) {
if( in_array( $zone ,array_keys( tz_get_zone_list() )) )
{
putenv('TZ='.$zone);
$GLOBALS["tz_preffered_tz"] = $zone;
@setcookie('preffered_tz', $zone, 2100000000, '/', $_SERVER['HTTP_HOST'], 0 );
}
else
{
printf('%s - tz_set_tz(%s)',msg_get_str(TEMP_ERROR), $zone);
}
}
function tz_get_tz() {
if( isset($_COOKIE['preffered_tz']) ) {
$GLOBALS["tz_preffered_tz"] = $_COOKIE['preffered_tz'];
}
else
{
if( ! isset($GLOBALS["tz_preffered_tz"]))
$GLOBALS["tz_preffered_tz"] = 'CET';
}
return $GLOBALS["tz_preffered_tz"];
}
function tz_mktime( $hour, $minute, $second, $month, $day, $year )
{
putenv('TZ='.tz_get_tz());
return mktime( $hour, $minute, $second, $month, $day, $year );
}
function tz_strftime( $source, $now )
{
putenv('TZ='.tz_get_tz());
setlocale(LC_TIME,$_COOKIE['preffered_language'].'.UTF-8');
return strftime( $source, $now );
}
