2023 January 15 Archive - EXEIdeas – Let's Your Mind Rock

If you’ve ever had to deal with time and PHP before, chances are you’ve had to deal with time zones. Dealing with time is difficult enough, but once the time becomes variable based on the preferences of the user of your application, it becomes even more confusing.Why so confusing? I mean, it seems simple enough doesn’t it?Well, there’s a lot to consider:How do you store the dates?How do you store the time zones?How do you do the math for adjustments?etc.Included in this page are the HTML select/dropdown code snippets to generate a list of time zones. It’s very hard to come up with a list of time zones that make sense because of considerations for countries and daylight savings adjustment. The list I use is based on a MySQL time zone list. If you want to use something else for the “value” attribute, feel free to replace it with something more meaningful to your needs, I often use the database identifier insteadThrough enough research and googling, you can answer most of these questions. However, there came a time to decide how the time zone was going to be displayed to the user. In PHP you have some built-in options that are fairly handy. However, we wanted to show the user the time zone abbreviation. In addition, we had to match up what PHP does with the time zone options that we give our users. The time zone options are stored in our database like so:Features:Light Weight.Pure PHP.Cross Browser.No JQuery Files.Fully Customizable.PHP Functions, Arrays, Lists.HTML Dropdown List Of Timezones With Hours As Value: [UTC - 12] Baker Island Time [UTC - 11] Niue Time, Samoa Standard Time [UTC - 10] Hawaii-Aleutian Standard Time, Cook Island Time [UTC - 9:30] Marquesas Islands Time [UTC - 9] Alaska Standard Time, Gambier Island Time [UTC - 8] Pacific Standard Time [UTC - 7] Mountain Standard Time [UTC - 6] Central Standard Time [UTC - 5] Eastern Standard Time [UTC - 4:30] Venezuelan Standard Time [UTC - 4] Atlantic Standard Time [UTC - 3:30] Newfoundland Standard Time [UTC - 3] Amazon Standard Time, Central Greenland Time [UTC - 2] Fernando de Noronha Time, South Georgia &amp; the South Sandwich Islands Time [UTC - 1] Azores Standard Time, Cape Verde Time, Eastern Greenland Time [UTC] Western European Time, Greenwich Mean Time [UTC + 1] Central European Time, West African Time [UTC + 2] Eastern European Time, Central African Time [UTC + 3] Moscow Standard Time, Eastern African Time [UTC + 3:30] Iran Standard Time [UTC + 4] Gulf Standard Time, Samara Standard Time [UTC + 4:30] Afghanistan Time [UTC + 5] Pakistan Standard Time, Yekaterinburg Standard Time [UTC + 5:30] Indian Standard Time, Sri Lanka Time [UTC + 5:45] Nepal Time [UTC + 6] Bangladesh Time, Bhutan Time, Novosibirsk Standard Time [UTC + 6:30] Cocos Islands Time, Myanmar Time [UTC + 7] Indochina Time, Krasnoyarsk Standard Time [UTC + 8] Chinese Standard Time, Australian Western Standard Time, Irkutsk Standard Time [UTC + 8:45] Southeastern Western Australia Standard Time [UTC + 9] Japan Standard Time, Korea Standard Time, Chita Standard Time [UTC + 9:30] Australian Central Standard Time [UTC + 10] Australian Eastern Standard Time, Vladivostok Standard Time [UTC + 10:30] Lord Howe Standard Time [UTC + 11] Solomon Island Time, Magadan Standard Time [UTC + 11:30] Norfolk Island Time [UTC + 12] New Zealand Time, Fiji Time, Kamchatka Standard Time [UTC + 12:45] Chatham Islands Time [UTC + 13] Tonga Time, Phoenix Islands Time [UTC + 14] Line Island Time HTML Dropdown List Of Timezones With Name As Value: (GMT-11:00) Midway Island, Samoa (GMT-10:00) Hawaii-Aleutian (GMT-10:00) Hawaii (GMT-09:30) Marquesas Islands (GMT-09:00) Gambier Islands (GMT-09:00) Alaska (GMT-08:00) Tijuana, Baja California (GMT-08:00) Pitcairn Islands (GMT-08:00) Pacific Time (US & Canada) (GMT-07:00) Mountain Time (US & Canada) (GMT-07:00) Chihuahua, La Paz, Mazatlan (GMT-07:00) Arizona (GMT-06:00) Saskatchewan, Central America (GMT-06:00) Guadalajara, Mexico City, Monterrey (GMT-06:00) Easter Island (GMT-06:00) Central Time (US & Canada) (GMT-05:00) Eastern Time (US & Canada) (GMT-05:00) Cuba (GMT-05:00) Bogota, Lima, Quito, Rio Branco (GMT-04:30) Caracas (GMT-04:00) Santiago (GMT-04:00) La Paz (GMT-04:00) Faukland Islands (GMT-04:00) Brazil (GMT-04:00) Atlantic Time (Goose Bay) (GMT-04:00) Atlantic Time (Canada) (GMT-03:30) Newfoundland (GMT-03:00) UTC-3 (GMT-03:00) Montevideo (GMT-03:00) Miquelon, St. Pierre (GMT-03:00) Greenland (GMT-03:00) Buenos Aires (GMT-03:00) Brasilia (GMT-02:00) Mid-Atlantic (GMT-01:00) Cape Verde Is. (GMT-01:00) Azores (GMT) Greenwich Mean Time : Belfast (GMT) Greenwich Mean Time : Dublin (GMT) Greenwich Mean Time : Lisbon (GMT) Greenwich Mean Time : London (GMT) Monrovia, Reykjavik (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague (GMT+01:00) Brussels, Copenhagen, Madrid, Paris (GMT+01:00) West Central Africa (GMT+01:00) Windhoek (GMT+02:00) Beirut (GMT+02:00) Cairo (GMT+02:00) Gaza (GMT+02:00) Harare, Pretoria (GMT+02:00) Jerusalem (GMT+02:00) Minsk (GMT+02:00) Syria (GMT+03:00) Moscow, St. Petersburg, Volgograd (GMT+03:00) Nairobi (GMT+03:30) Tehran (GMT+04:00) Abu Dhabi, Muscat (GMT+04:00) Yerevan (GMT+04:30) Kabul (GMT+05:00) Ekaterinburg (GMT+05:00) Tashkent (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi (GMT+05:45) Kathmandu (GMT+06:00) Astana, Dhaka (GMT+06:00) Novosibirsk (GMT+06:30) Yangon (Rangoon) (GMT+07:00) Bangkok, Hanoi, Jakarta (GMT+07:00) Krasnoyarsk (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi (GMT+08:00) Irkutsk, Ulaan Bataar (GMT+08:00) Perth (GMT+08:45) Eucla (GMT+09:00) Osaka, Sapporo, Tokyo (GMT+09:00) Seoul (GMT+09:00) Yakutsk (GMT+09:30) Adelaide (GMT+09:30) Darwin (GMT+10:00) Brisbane (GMT+10:00) Hobart (GMT+10:00) Vladivostok (GMT+10:30) Lord Howe Island (GMT+11:00) Solomon Is., New Caledonia (GMT+11:00) Magadan (GMT+11:30) Norfolk Island (GMT+12:00) Anadyr, Kamchatka (GMT+12:00) Auckland, Wellington (GMT+12:00) Fiji, Kamchatka, Marshall Is. (GMT+12:45) Chatham Islands (GMT+13:00) Nuku'alofa (GMT+14:00) Kiritimati HTML Dropdown List Of Timezones With Timezone As Value Using PHP:function formatOffset($offset) { $hours = $offset / 3600; $remainder = $offset % 3600; $sign = $hours > 0 ? '+' : '-'; $hour = (int) abs($hours); $minutes = (int) abs($remainder / 60); if ($hour == 0 AND $minutes == 0) { $sign = ' '; } return $sign . str_pad($hour, 2, '0', STR_PAD_LEFT) .':'. str_pad($minutes,2, '0');}$utc = new DateTimeZone('UTC');$dt = new DateTime('now', $utc);echo ' ';foreach(DateTimeZone::listIdentifiers() as $tz) { $current_tz = new DateTimeZone($tz); $offset = $current_tz->getOffset($dt); $transition = $current_tz->getTransitions($dt->getTimestamp(), $dt->getTimestamp()); $abbr = $transition[0]['abbr']; echo ' ' .$tz. ' [' .$abbr. ' '. formatOffset($offset). '] ';}echo ' ';HTML Dropdown List Of Timezones With Timezone As Value Using PHP Datetime:$timezones = DateTimeZone::listAbbreviations();$cities = array();foreach( $timezones as $key => $zones ){ foreach( $zones as $id => $zone ) { /** * Only get timezones explicitely not part of "Others". * @see http://www.php.net/manual/en/timezones.others.php */ if ( preg_match( '/^(America|Antartica|Arctic|Asia|Atlantic|Europe|Indian|Pacific)\//', $zone['timezone_id'] ) && $zone['timezone_id']) { $cities[$zone['timezone_id']][] = $key; } }}// For each city, have a comma separated list of all possible timezones for that city.foreach( $cities as $key => $value ) $cities[$key] = join( ', ', $value);// Only keep one city (the first and also most important) for each set of possibilities. $cities = array_unique( $cities );// Sort by area/city name.ksort( $cities );List Of Timezones Using PHP Array:$timezones = array ('(GMT-11:00) Midway Island' => 'Pacific/Midway','(GMT-11:00) Samoa' => 'Pacific/Samoa','(GMT-10:00) Hawaii' => 'Pacific/Honolulu','(GMT-09:00) Alaska' => 'US/Alaska','(GMT-08:00) Pacific Time (US &amp; Canada)' => 'America/Los_Angeles','(GMT-08:00) Tijuana' => 'America/Tijuana','(GMT-07:00) Arizona' => 'US/Arizona','(GMT-07:00) Chihuahua' => 'America/Chihuahua','(GMT-07:00) La Paz' => 'America/Chihuahua','(GMT-07:00) Mazatlan' => 'America/Mazatlan','(GMT-07:00) Mountain Time (US &amp; Canada)' => 'US/Mountain','(GMT-06:00) Central America' => 'America/Managua','(GMT-06:00) Central Time (US &amp; Canada)' => 'US/Central','(GMT-06:00) Guadalajara' => 'America/Mexico_City','(GMT-06:00) Mexico City' => 'America/Mexico_City','(GMT-06:00) Monterrey' => 'America/Monterrey','(GMT-06:00) Saskatchewan' => 'Canada/Saskatchewan','(GMT-05:00) Bogota' => 'America/Bogota','(GMT-05:00) Eastern Time (US &amp; Canada)' => 'US/Eastern','(GMT-05:00) Indiana (East)' => 'US/East-Indiana','(GMT-05:00) Lima' => 'America/Lima','(GMT-05:00) Quito' => 'America/Bogota','(GMT-04:00) Atlantic Time (Canada)' => 'Canada/Atlantic','(GMT-04:30) Caracas' => 'America/Caracas','(GMT-04:00) La Paz' => 'America/La_Paz','(GMT-04:00) Santiago' => 'America/Santiago','(GMT-03:30) Newfoundland' => 'Canada/Newfoundland','(GMT-03:00) Brasilia' => 'America/Sao_Paulo','(GMT-03:00) Buenos Aires' => 'America/Argentina/Buenos_Aires','(GMT-03:00) Georgetown' => 'America/Argentina/Buenos_Aires','(GMT-03:00) Greenland' => 'America/Godthab','(GMT-02:00) Mid-Atlantic' => 'America/Noronha','(GMT-01:00) Azores' => 'Atlantic/Azores','(GMT-01:00) Cape Verde Is.' => 'Atlantic/Cape_Verde','(GMT+00:00) Casablanca' => 'Africa/Casablanca','(GMT+00:00) Edinburgh' => 'Europe/London','(GMT+00:00) Greenwich Mean Time : Dublin' => 'Etc/Greenwich','(GMT+00:00) Lisbon' => 'Europe/Lisbon','(GMT+00:00) London' => 'Europe/London','(GMT+00:00) Monrovia' => 'Africa/Monrovia','(GMT+00:00) UTC' => 'UTC','(GMT+01:00) Amsterdam' => 'Europe/Amsterdam','(GMT+01:00) Belgrade' => 'Europe/Belgrade','(GMT+01:00) Berlin' => 'Europe/Berlin','(GMT+01:00) Bern' => 'Europe/Berlin','(GMT+01:00) Bratislava' => 'Europe/Bratislava','(GMT+01:00) Brussels' => 'Europe/Brussels','(GMT+01:00) Budapest' => 'Europe/Budapest','(GMT+01:00) Copenhagen' => 'Europe/Copenhagen','(GMT+01:00) Ljubljana' => 'Europe/Ljubljana','(GMT+01:00) Madrid' => 'Europe/Madrid','(GMT+01:00) Paris' => 'Europe/Paris','(GMT+01:00) Prague' => 'Europe/Prague','(GMT+01:00) Rome' => 'Europe/Rome','(GMT+01:00) Sarajevo' => 'Europe/Sarajevo','(GMT+01:00) Skopje' => 'Europe/Skopje','(GMT+01:00) Stockholm' => 'Europe/Stockholm','(GMT+01:00) Vienna' => 'Europe/Vienna','(GMT+01:00) Warsaw' => 'Europe/Warsaw','(GMT+01:00) West Central Africa' => 'Africa/Lagos','(GMT+01:00) Zagreb' => 'Europe/Zagreb','(GMT+02:00) Athens' => 'Europe/Athens','(GMT+02:00) Bucharest' => 'Europe/Bucharest','(GMT+02:00) Cairo' => 'Africa/Cairo','(GMT+02:00) Harare' => 'Africa/Harare','(GMT+02:00) Helsinki' => 'Europe/Helsinki','(GMT+02:00) Istanbul' => 'Europe/Istanbul','(GMT+02:00) Jerusalem' => 'Asia/Jerusalem','(GMT+02:00) Kyiv' => 'Europe/Helsinki','(GMT+02:00) Pretoria' => 'Africa/Johannesburg','(GMT+02:00) Riga' => 'Europe/Riga','(GMT+02:00) Sofia' => 'Europe/Sofia','(GMT+02:00) Tallinn' => 'Europe/Tallinn','(GMT+02:00) Vilnius' => 'Europe/Vilnius','(GMT+03:00) Baghdad' => 'Asia/Baghdad','(GMT+03:00) Kuwait' => 'Asia/Kuwait','(GMT+03:00) Minsk' => 'Europe/Minsk','(GMT+03:00) Nairobi' => 'Africa/Nairobi','(GMT+03:00) Riyadh' => 'Asia/Riyadh','(GMT+03:00) Volgograd' => 'Europe/Volgograd','(GMT+03:30) Tehran' => 'Asia/Tehran','(GMT+04:00) Abu Dhabi' => 'Asia/Muscat','(GMT+04:00) Baku' => 'Asia/Baku','(GMT+04:00) Moscow' => 'Europe/Moscow','(GMT+04:00) Muscat' => 'Asia/Muscat','(GMT+04:00) St. Petersburg' => 'Europe/Moscow','(GMT+04:00) Tbilisi' => 'Asia/Tbilisi','(GMT+04:00) Yerevan' => 'Asia/Yerevan','(GMT+04:30) Kabul' => 'Asia/Kabul','(GMT+05:00) Islamabad' => 'Asia/Karachi','(GMT+05:00) Karachi' => 'Asia/Karachi','(GMT+05:00) Tashkent' => 'Asia/Tashkent','(GMT+05:30) Chennai' => 'Asia/Calcutta','(GMT+05:30) Kolkata' => 'Asia/Kolkata','(GMT+05:30) Mumbai' => 'Asia/Calcutta','(GMT+05:30) New Delhi' => 'Asia/Calcutta','(GMT+05:30) Sri Jayawardenepura' => 'Asia/Calcutta','(GMT+05:45) Kathmandu' => 'Asia/Katmandu','(GMT+06:00) Almaty' => 'Asia/Almaty','(GMT+06:00) Astana' => 'Asia/Dhaka','(GMT+06:00) Dhaka' => 'Asia/Dhaka','(GMT+06:00) Ekaterinburg' => 'Asia/Yekaterinburg','(GMT+06:30) Rangoon' => 'Asia/Rangoon','(GMT+07:00) Bangkok' => 'Asia/Bangkok','(GMT+07:00) Hanoi' => 'Asia/Bangkok','(GMT+07:00) Jakarta' => 'Asia/Jakarta','(GMT+07:00) Novosibirsk' => 'Asia/Novosibirsk','(GMT+08:00) Beijing' => 'Asia/Hong_Kong','(GMT+08:00) Chongqing' => 'Asia/Chongqing','(GMT+08:00) Hong Kong' => 'Asia/Hong_Kong','(GMT+08:00) Krasnoyarsk' => 'Asia/Krasnoyarsk','(GMT+08:00) Kuala Lumpur' => 'Asia/Kuala_Lumpur','(GMT+08:00) Perth' => 'Australia/Perth','(GMT+08:00) Singapore' => 'Asia/Singapore','(GMT+08:00) Taipei' => 'Asia/Taipei','(GMT+08:00) Ulaan Bataar' => 'Asia/Ulan_Bator','(GMT+08:00) Urumqi' => 'Asia/Urumqi','(GMT+09:00) Irkutsk' => 'Asia/Irkutsk','(GMT+09:00) Osaka' => 'Asia/Tokyo','(GMT+09:00) Sapporo' => 'Asia/Tokyo','(GMT+09:00) Seoul' => 'Asia/Seoul','(GMT+09:00) Tokyo' => 'Asia/Tokyo','(GMT+09:30) Adelaide' => 'Australia/Adelaide','(GMT+09:30) Darwin' => 'Australia/Darwin','(GMT+10:00) Brisbane' => 'Australia/Brisbane','(GMT+10:00) Canberra' => 'Australia/Canberra','(GMT+10:00) Guam' => 'Pacific/Guam','(GMT+10:00) Hobart' => 'Australia/Hobart','(GMT+10:00) Melbourne' => 'Australia/Melbourne','(GMT+10:00) Port Moresby' => 'Pacific/Port_Moresby','(GMT+10:00) Sydney' => 'Australia/Sydney','(GMT+10:00) Yakutsk' => 'Asia/Yakutsk','(GMT+11:00) Vladivostok' => 'Asia/Vladivostok','(GMT+12:00) Auckland' => 'Pacific/Auckland','(GMT+12:00) Fiji' => 'Pacific/Fiji','(GMT+12:00) International Date Line West' => 'Pacific/Kwajalein','(GMT+12:00) Kamchatka' => 'Asia/Kamchatka','(GMT+12:00) Magadan' => 'Asia/Magadan','(GMT+12:00) Marshall Is.' => 'Pacific/Fiji','(GMT+12:00) New Caledonia' => 'Asia/Magadan','(GMT+12:00) Solomon Is.' => 'Asia/Magadan','(GMT+12:00) Wellington' => 'Pacific/Auckland','(GMT+13:00) Nuku\'alofa' => 'Pacific/Tongatapu');List Of Timezones Array Using Shortest PHP Function:$tzlist = DateTimeZone::listIdentifiers(DateTimeZone::ALL);Generally, We want to make a list of available of all times zones to prompt your user to easily find and select his/her time zone. here steps by step implements to create a list of the Time Zones, PHP offers timezone_identifiers_list methods used above (PHP 5 >= 5.2.0). We can make your list easily, and simply using methods like this(Generate a list of timezones with PHP)Customization:No need to customize it. Just copy-paste. Rest edit the code as per comments and need.Troubleshooting the Errors:Do it with concentration and patience. Check your all steps again and all codes or scripts. If you find any error you can contact us anytime via comment or better via email, We are always here to help you.Final Words:That’s all we have. We hope that you liked this article. If you have any problem with this code in your template then feel free to contact us with a full explanation of your problem. We will reply to you as time allows us If you have any doubts or problems please comment below. We are happy to help you! If you liked this article, Don’t forget to share this with your friends so they can also take benefit from it and leave.