PHP Classes
elePHPant
Icontem

PHP TimeZone City: Get timezone information from a MySQL database

Recommend this page to a friend!
  Info   View files Documentation   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2019-10-11 (5 hours ago) RSS 2.0 feedNot enough user ratingsTotal: 142 All time: 8,815 This week: 334Up
Version License PHP version Categories
timezonecity 1.0.11Custom (specified...5PHP 5, Time and Date, Geography
Description Author

This class can get timezone information from a MySQL database.

It can query a MySQL database table to retrieve details about different timezone details.

Currently it can the list of all time zones sorted by given criteria, check if a given timezone is valid, get the details of a timezone, get the nearest timezone of a place given the geographic coordinates and the country and get the time offset of a timezone relative to GMT.

Innovation Award
PHP Programming Innovation award nominee
August 2017
Number 9
The time of a given place on Earth is derived from the location timezone.

This class can retrieve timezone information from a database, so it can determine the timezone of a location and then computes the timezone region time.

Manuel Lemos
  Performance   Level  
Name: Peter Kahl <contact>
Classes: 37 packages by
Country: United Kingdom United Kingdom
Innovation award
Innovation award
Nominee: 23x

Winner: 2x

 

Details

Time Zone City

Downloads License If this project has business value for you then don't hesitate to support me with a small donation.

Detects nearest timezone (and country etc.) for given coordinates and more!

This PHP timezone library -- * detects nearest timezone for given coordinates * detects nearest country for given coordinates * generates HTML code for timezone select with customizable configuration * validates a timezone db name (e.g. 'Asia/Dubai') * returns time offset in seconds for given timezone * returns information for given timezone (see below ?) * returns Google Maps API place_id for given timezone * returns 3-5 character abbreviation for given timezone (CEST, BST, GMT, EST). This works where the native PHP DateTimeZone fails!

Each zone includes these details: * timezone db name (e.g. 'Asia/Dubai') * 3-5 character abbreviation (both standard and daylight time, e.g. 'PST' and 'PDT') ? * full name of time zone (both standard and daylight time, e.g. 'Pacific Standard Time' and 'Pacific Daylight Time') ? * offset in hours (both standard and daylight time; useful for sorting) ? * place name (city) * Google Maps API place_id (useful for translation of place name) * region code * region name * country code * country name * latitude * longitude

Upgrading from versions older than 2019-02-05

The version released on 2019-02-05 is a major revamp with code improvements and database expansion. Make sure you import the database dump if your existing Time Zone City is older than 2019-02-05.

Usage

Get name of timezone from country code, latitude and longitude:

use peterkahl\TimeZoneCity\TimeZoneCity;

$link = mysqli_connect($DB_HOSTNAME, $DB_USERNAME, $DB_PASSWORD, $DB_DBNAME);

mysqli_set_charset($link, "utf8mb4");

$zoneObj = new TimeZoneCity;
$zoneObj->dbresource = $link;

$country   = 'ru';
$latitude  = 55.61;
$longitude = 38.76;

print_r($zoneObj->GetNearestZone($country, $latitude, $longitude), true);

/*
Array
(
    [time_zone] => Europe/Moscow
    [std_abbr] => MSK
    [dst_abbr] =>
    [std_offset] => 3
    [dst_offset] => 3
    [std_full] => Moscow Time
    [dst_full] =>
    [place_name] => Moscow
    [place_id] => ChIJybDUc_xKtUYRTM9XV8zWRD0
    [region_code] =>
    [region_name] => Moskva Oblast
    [country_code] => RU
    [country_name] => Russia
    [latitude] => 55.755826
    [longitude] => 37.6173
)
*/

#-----------------------------------------------------------------------
# GEOCODING
# If we don't know the country code (or the code is erorrneous),
# latitude and longitude will be used to determine the nearest timezone, country etc.

$country   = '';
$latitude  = 52.486;  # This is Birmingham, UK
$longitude = -1.89;

print_r($zoneObj->GetNearestZone($country, $latitude, $longitude), true);

/*
Array
(
    [time_zone] => Europe/Jersey
    [std_abbr] => GMT
    [dst_abbr] => BST
    [std_offset] => 0
    [dst_offset] => 1
    [std_full] => Greenwich Mean Time
    [dst_full] => British Summer Time
    [place_name] => Jersey
    [place_id] => ChIJM3WSjKRSDEgRw2waCqMjnFE
    [region_code] =>
    [region_name] =>
    [country_code] => JE
    [country_name] => Jersey
    [latitude] => 49.214439
    [longitude] => -2.13125
)

Well, it's not perfect, but close enough! At least the timezone is right.
*/

#-----------------------------------------------------------------------
# Example when country code is erorrneous.

$country   = 'DE';
$latitude  = 22.27; # Coordinates are near Macau; can't be Germany!
$longitude = 113.79;

print_r($zoneObj->GetNearestZone($country, $latitude, $longitude), true);

/*
Array
(
    [time_zone] => Asia/Macau
    [std_abbr] => CST
    [dst_abbr] =>
    [std_offset] => 8
    [dst_offset] => 8
    [std_full] => China Standard Time
    [dst_full] =>
    [place_name] => Macau
    [place_id] => ChIJ88g14uB6ATQR9qyFtCzje8Y
    [region_code] =>
    [region_name] =>
    [country_code] => MO
    [country_name] => Macau
    [latitude] => 22.198745
    [longitude] => 113.543873
)
*/

Generate HTML code for SELECT tag:

use peterkahl\TimeZoneCity\TimeZoneCity;

$link = mysqli_connect($DB_HOSTNAME, $DB_USERNAME, $DB_PASSWORD, $DB_DBNAME);

mysqli_set_charset($link, "utf8mb4");

$zoneObj = new TimeZoneCity;
$zoneObj->dbresource = $link;

#-----------------------------------------------------------------------
# All world timezones

$zones = $zoneObj->GetAllZones(); # Advanced sorting is possible!

$currentZone = 'America/Los_Angeles';

echo '<select>'."\n";

foreach ($zones as $key => $val) {
  $place = array();
  $place[] = $val['place_name'];
  $place[] = $val['region_code'];
  $place[] = $val['country_name'];
  $place = array_filter($place);
  $place = array_unique($place);
  $place = implode(', ', $place);
  echo '  <option value="'. $val['time_zone'] .'"';
  if ($currentZone == $val['time_zone']) {
    echo ' selected';
  }
  echo '>(UTC'. $val['offset_formatted'] .') '. $place .'</option>'."\n";
}

echo '</select>'."\n";

#-----------------------------------------------------------------------
# Only US timezones

$zones = $zoneObj->GetAllZones('std_offset,place_name', 'desc,asc', 'us');

$currentZone = 'America/Los_Angeles';

echo '<select>'."\n";

foreach ($zones as $key => $val) {
  $place = array();
  $place[] = $val['place_name'];
  $place[] = $val['region_code'];
  #$place[] = $val['country_name'];
  $place = array_filter($place);
  $place = array_unique($place);
  $place = implode(', ', $place);
  echo '  <option value="'. $val['time_zone'] .'"';
  if ($currentZone == $val['time_zone']) {
    echo ' selected';
  }
  echo '>(UTC'. $val['offset_formatted'] .') '. $place .'</option>'."\n";
}

echo '</select>'."\n";

/*
<select>
  <option value="Pacific/Wake">(UTC+1200) Wake Island</option>
  <option value="America/Detroit">(UTC-0500) Detroit, MI</option>
  <option value="America/Indiana/Indianapolis">(UTC-0500) Indianapolis, IN</option>
  <option value="America/Kentucky/Louisville">(UTC-0500) Louisville, KY</option>
  <option value="America/Indiana/Marengo">(UTC-0500) Marengo, IN</option>
  <option value="America/Kentucky/Monticello">(UTC-0500) Monticello, KY</option>
  <option value="America/New_York">(UTC-0500) New York, NY</option>
  <option value="America/Indiana/Petersburg">(UTC-0500) Petersburg, IN</option>
  <option value="America/Indiana/Vevay">(UTC-0500) Vevay, IN</option>
  <option value="America/Indiana/Vincennes">(UTC-0500) Vincennes, IN</option>
  <option value="America/Indiana/Winamac">(UTC-0500) Winamac, IN</option>
  <option value="America/North_Dakota/Beulah">(UTC-0600) Beulah, ND</option>
  <option value="America/North_Dakota/Center">(UTC-0600) Center, ND</option>
  <option value="America/Chicago">(UTC-0600) Chicago, IL</option>
  <option value="America/Indiana/Knox">(UTC-0600) Knox, IN</option>
  <option value="America/Menominee">(UTC-0600) Menominee, MI</option>
  <option value="America/North_Dakota/New_Salem">(UTC-0600) New Salem, ND</option>
  <option value="America/Indiana/Tell_City">(UTC-0600) Tell City, IN</option>
  <option value="America/Boise">(UTC-0700) Boise, ID</option>
  <option value="America/Denver">(UTC-0700) Denver, CO</option>
  <option value="America/Phoenix">(UTC-0700) Phoenix, AZ</option>
  <option value="America/Los_Angeles" selected>(UTC-0800) Los Angeles, CA</option>
  <option value="America/Metlakatla">(UTC-0800) Metlakatla, AK</option>
  <option value="America/Anchorage">(UTC-0900) Anchorage, AK</option>
  <option value="America/Juneau">(UTC-0900) Juneau, AK</option>
  <option value="America/Nome">(UTC-0900) Nome, AK</option>
  <option value="America/Sitka">(UTC-0900) Sitka, AK</option>
  <option value="America/Yakutat">(UTC-0900) Yakutat, AK</option>
  <option value="America/Adak">(UTC-1000) Adak, AK</option>
  <option value="Pacific/Honolulu">(UTC-1000) Honolulu, HI</option>
  <option value="Pacific/Johnston">(UTC-1000) Johnston Atoll</option>
  <option value="Pacific/Midway">(UTC-1100) Midway Atoll</option>
  <option value="Pacific/Pago_Pago">(UTC-1100) Pago Pago</option>
</select>

*/

#-----------------------------------------------------------------------
# Only US and Canadian timezones

$zones = $zoneObj->GetAllZones('std_offset,place_name', 'desc,asc', 'us,ca');

$currentZone = 'America/Los_Angeles';

echo '<select>'."\n";

foreach ($zones as $key => $val) {
  $place = array();
  $place[] = $val['place_name'];
  $place[] = $val['region_code'];
  $place[] = $val['country_name'];
  $place = array_filter($place);
  $place = array_unique($place);
  $place = implode(', ', $place);
  echo '  <option value="'. $val['time_zone'] .'"';
  if ($currentZone == $val['time_zone']) {
    echo ' selected';
  }
  echo '>(UTC'. $val['offset_formatted'] .') '. $place .'</option>'."\n";
}

echo '</select>'."\n";

/*
<select>
  <option value="Pacific/Wake">(UTC+1200) Wake Island, United States</option>
  <option value="America/St_Johns">(UTC-0330) St. John's, NL, Canada</option>
  <option value="America/Blanc-Sablon">(UTC-0400) Blanc-Sablon, QC, Canada</option>
  <option value="America/Glace_Bay">(UTC-0400) Glace Bay, NC, Canada</option>
  <option value="America/Goose_Bay">(UTC-0400) Goose Bay, NL, Canada</option>
  <option value="America/Halifax">(UTC-0400) Halifax, NS, Canada</option>
  <option value="America/Moncton">(UTC-0400) Moncton, NB, Canada</option>
  <option value="Atlantic/Stanley">(UTC-0300) Stanley, NB, Canada</option>
  <option value="America/Atikokan">(UTC-0500) Atikokan, ON, Canada</option>
  <option value="America/Detroit">(UTC-0500) Detroit, MI, United States</option>
  <option value="America/Indiana/Indianapolis">(UTC-0500) Indianapolis, IN, United States</option>
  <option value="America/Iqaluit">(UTC-0500) Iqaluit, NU, Canada</option>
  <option value="America/Kentucky/Louisville">(UTC-0500) Louisville, KY, United States</option>
  <option value="America/Indiana/Marengo">(UTC-0500) Marengo, IN, United States</option>
  <option value="America/Kentucky/Monticello">(UTC-0500) Monticello, KY, United States</option>
  <option value="America/New_York">(UTC-0500) New York, NY, United States</option>
  <option value="America/Nipigon">(UTC-0500) Nipigon, ON, Canada</option>
  <option value="America/Pangnirtung">(UTC-0500) Pangnirtung, NU, Canada</option>
  <option value="America/Indiana/Petersburg">(UTC-0500) Petersburg, IN, United States</option>
  <option value="America/Thunder_Bay">(UTC-0500) Thunder Bay, ON, Canada</option>
  <option value="America/Toronto">(UTC-0500) Toronto, ON, Canada</option>
  <option value="America/Indiana/Vevay">(UTC-0500) Vevay, IN, United States</option>
  <option value="America/Indiana/Vincennes">(UTC-0500) Vincennes, IN, United States</option>
  <option value="America/Indiana/Winamac">(UTC-0500) Winamac, IN, United States</option>
  <option value="America/North_Dakota/Beulah">(UTC-0600) Beulah, ND, United States</option>
  <option value="America/North_Dakota/Center">(UTC-0600) Center, ND, United States</option>
  <option value="America/Chicago">(UTC-0600) Chicago, IL, United States</option>
  <option value="America/Indiana/Knox">(UTC-0600) Knox, IN, United States</option>
  <option value="America/Menominee">(UTC-0600) Menominee, MI, United States</option>
  <option value="America/North_Dakota/New_Salem">(UTC-0600) New Salem, ND, United States</option>
  <option value="America/Rainy_River">(UTC-0600) Rainy River, ON, Canada</option>
  <option value="America/Rankin_Inlet">(UTC-0600) Rankin Inlet, NU, Canada</option>
  <option value="America/Regina">(UTC-0600) Regina, SK, Canada</option>
  <option value="America/Resolute">(UTC-0600) Resolute, NU, Canada</option>
  <option value="America/Swift_Current">(UTC-0600) Swift Current, SK, Canada</option>
  <option value="America/Indiana/Tell_City">(UTC-0600) Tell City, IN, United States</option>
  <option value="America/Winnipeg">(UTC-0600) Winnipeg, MB, Canada</option>
  <option value="America/Boise">(UTC-0700) Boise, ID, United States</option>
  <option value="America/Cambridge_Bay">(UTC-0700) Cambridge Bay, NU, Canada</option>
  <option value="America/Creston">(UTC-0700) Creston, BC, Canada</option>
  <option value="America/Dawson_Creek">(UTC-0700) Dawson Creek, BC, Canada</option>
  <option value="America/Denver">(UTC-0700) Denver, CO, United States</option>
  <option value="America/Edmonton">(UTC-0700) Edmonton, AB, Canada</option>
  <option value="America/Fort_Nelson">(UTC-0700) Fort Nelson, BC, Canada</option>
  <option value="America/Inuvik">(UTC-0700) Inuvik, NT, Canada</option>
  <option value="America/Phoenix">(UTC-0700) Phoenix, AZ, United States</option>
  <option value="America/Yellowknife">(UTC-0700) Yellowknife, NT, Canada</option>
  <option value="America/Dawson">(UTC-0800) Dawson, YT, Canada</option>
  <option value="America/Los_Angeles" selected>(UTC-0800) Los Angeles, CA, United States</option>
  <option value="America/Vancouver">(UTC-0800) Vancouver, BC, Canada</option>
  <option value="America/Whitehorse">(UTC-0800) Whitehorse, YT, Canada</option>
  <option value="America/Anchorage">(UTC-0900) Anchorage, AK, United States</option>
  <option value="America/Juneau">(UTC-0900) Juneau, AK, United States</option>
  <option value="America/Metlakatla">(UTC-0800) Metlakatla, AK, United States</option>
  <option value="America/Nome">(UTC-0900) Nome, AK, United States</option>
  <option value="America/Sitka">(UTC-0900) Sitka, AK, United States</option>
  <option value="America/Yakutat">(UTC-0900) Yakutat, AK, United States</option>
  <option value="America/Adak">(UTC-1000) Adak, AK, United States</option>
  <option value="Pacific/Honolulu">(UTC-1000) Honolulu, HI, United States</option>
  <option value="Pacific/Johnston">(UTC-1000) Johnston Atoll, United States</option>
  <option value="Pacific/Midway">(UTC-1100) Midway Atoll, United States</option>
  <option value="Pacific/Pago_Pago">(UTC-1100) Pago Pago, United States</option>
</select>

Exec time = 3.18 msec

*/

Get details of given time zone:

use peterkahl\TimeZoneCity\TimeZoneCity;

$link = mysqli_connect($DB_HOSTNAME, $DB_USERNAME, $DB_PASSWORD, $DB_DBNAME);

mysqli_set_charset($link, "utf8mb4");

$zoneObj = new TimeZoneCity;
$zoneObj->dbresource = $link;

$info = $zoneObj->GetZoneInfo('Australia/Melbourne');

var_dump($info);

/*
array(15) {
  ["time_zone"]=>
  string(19) "Australia/Melbourne"
  ["std_abbr"]=>
  string(4) "AEST"
  ["dst_abbr"]=>
  string(4) "AEDT"
  ["std_offset"]=>
  string(2) "10"
  ["dst_offset"]=>
  string(2) "11"
  ["std_full"]=>
  string(32) "Australian Eastern Standard Time"
  ["dst_full"]=>
  string(40) "Australian Eastern Daylight Savings Time"
  ["place_name"]=>
  string(9) "Melbourne"
  ["place_id"]=>
  string(27) "ChIJ90260rVG1moRkM2MIXVWBAQ"
  ["region_code"]=>
  string(3) "VIC"
  ["region_name"]=>
  string(8) "Victoria"
  ["country_code"]=>
  string(2) "AU"
  ["country_name"]=>
  string(9) "Australia"
  ["latitude"]=>
  string(11) "-37.8136276"
  ["longitude"]=>
  string(11) "144.9630576"
}

Exec time = 463.96 ?sec
*/

Get abbreviation of given time zone:

use peterkahl\TimeZoneCity\TimeZoneCity;

$link = mysqli_connect($DB_HOSTNAME, $DB_USERNAME, $DB_PASSWORD, $DB_DBNAME);

mysqli_set_charset($link, "utf8mb4");

$zoneObj = new TimeZoneCity;
$zoneObj->dbresource = $link;

echo $zoneObj->GetZoneAbbr('Asia/Dubai'); # GST

Alternative time zone library available!

I have created an alternative library which is simpler, less versatile and does not use SQL database, but may do the job you need:

https://github.com/peterkahl/time-zone-name

  Files folder image Files  
File Role Description
Files folder imagesrc (1 file)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file dbdump.sql Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  src  
File Role Description
  Plain text file TimeZoneCity.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:142
This week:0
All time:8,815
This week:334Up