Time Zone HTML Drop Down Selection

const timezone = {
    "Pacific/Midway": "(GMT-11:00) Midway Island",
    "America/Adak": "(GMT-10:00) Hawaii-Aleutian",
    "Etc/GMT+10": "(GMT-10:00) Hawaii",
    "Pacific/Marquesas": "(GMT-09:30) Marquesas Islands",
    "Pacific/Gambier": "(GMT-09:00) Gambier Islands",
    "America/Anchorage": "(GMT-09:00) Alaska",
    "America/Ensenada": "(GMT-08:00) Tijuana, Baja California",
    "Etc/GMT+8": "(GMT-08:00) Pitcairn Islands",
    "America/Los_Angeles": "(GMT-08:00) Pacific Time (US & Canada)",
    "America/Denver": "(GMT-07:00) Mountain Time (US & Canada)",
    "America/Chihuahua": "(GMT-07:00) Chihuahua, La Paz, Mazatlan",
    "America/Dawson_Creek": "(GMT-07:00) Arizona",
    "America/Belize": "(GMT-06:00) Saskatchewan, Central America",
    "America/Cancun": "(GMT-06:00) Guadalajara, Mexico City, Monterrey",
    "Chile/EasterIsland": "(GMT-06:00) Easter Island",
    "America/Chicago": "(GMT-06:00) Central Time (US & Canada)",
    "America/New_York": "(GMT-05:00) Eastern Time (US & Canada)",
    "America/Havana": "(GMT-05:00) Cuba",
    "America/Bogota": "(GMT-05:00) Bogota, Lima, Quito, Rio Branco",
    "America/Caracas": "(GMT-04:30) Caracas",
    "America/Santiago": "(GMT-04:00) Santiago",
    "America/La_Paz": "(GMT-04:00) La Paz",
    "Atlantic/Stanley": "(GMT-04:00) Faukland Islands",
    "America/Campo_Grande": "(GMT-04:00) Brazil",
    "America/Goose_Bay": "(GMT-04:00) Atlantic Time (Goose Bay)",
    "America/Glace_Bay": "(GMT-04:00) Atlantic Time (Canada)",
    "America/St_Johns": "(GMT-03:30) Newfoundland",
    "America/Araguaina": "(GMT-03:00) UTC-3",
    "America/Montevideo": "(GMT-03:00) Montevideo",
    "America/Miquelon": "(GMT-03:00) Miquelon, St. Pierre",
    "America/Godthab": "(GMT-03:00) Greenland",
    "America/Argentina/Buenos_Aires": "(GMT-03:00) Buenos Aires",
    "America/Sao_Paulo": "(GMT-03:00) Brasilia",
    "America/Noronha": "(GMT-02:00) Mid-Atlantic",
    "Atlantic/Cape_Verde": "(GMT-01:00) Cape Verde Is.",
    "Atlantic/Azores": "(GMT-01:00) Azores",
    "Europe/Belfast": "(GMT) Greenwich Mean Time : Belfast",
    "Europe/Dublin": "(GMT) Greenwich Mean Time : Dublin",
    "Europe/Lisbon": "(GMT) Greenwich Mean Time : Lisbon",
    "Europe/London": "(GMT) Greenwich Mean Time : London",
    "Africa/Abidjan": "(GMT) Monrovia, Reykjavik",
    "Europe/Amsterdam": "(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna",
    "Europe/Belgrade": "(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague",
    "Europe/Brussels": "(GMT+01:00) Brussels, Copenhagen, Madrid, Paris",
    "Africa/Algiers": "(GMT+01:00) West Central Africa",
    "Africa/Windhoek": "(GMT+01:00) Windhoek",
    "Asia/Beirut": "(GMT+02:00) Beirut",
    "Africa/Cairo": "(GMT+02:00) Cairo",
    "Asia/Gaza": "(GMT+02:00) Gaza",
    "Africa/Blantyre": "(GMT+02:00) Harare, Pretoria",
    "Asia/Jerusalem": "(GMT+02:00) Jerusalem",
    "Europe/Minsk": "(GMT+02:00) Minsk",
    "Asia/Damascus": "(GMT+02:00) Syria",
    "Europe/Moscow": "(GMT+03:00) Moscow, St. Petersburg, Volgograd",
    "Africa/Addis_Ababa": "(GMT+03:00) Nairobi",
    "Asia/Tehran": "(GMT+03:30) Tehran",
    "Asia/Dubai": "(GMT+04:00) Abu Dhabi, Muscat",
    "Asia/Yerevan": "(GMT+04:00) Yerevan",
    "Asia/Kabul": "(GMT+04:30) Kabul",
    "Asia/Yekaterinburg": "(GMT+05:00) Ekaterinburg",
    "Asia/Tashkent": "(GMT+05:00) Tashkent",
    "Asia/Kolkata": "(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi",
    "Asia/Katmandu": "(GMT+05:45) Kathmandu",
    "Asia/Dhaka": "(GMT+06:00) Astana, Dhaka",
    "Asia/Novosibirsk": "(GMT+06:00) Novosibirsk",
    "Asia/Rangoon": "(GMT+06:30) Yangon (Rangoon)",
    "Asia/Bangkok": "(GMT+07:00) Bangkok, Hanoi, Jakarta",
    "Asia/Krasnoyarsk": "(GMT+07:00) Krasnoyarsk",
    "Asia/Hong_Kong": "(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi",
    "Asia/Irkutsk": "(GMT+08:00) Irkutsk, Ulaan Bataar",
    "Australia/Perth": "(GMT+08:00) Perth",
    "Australia/Eucla": "(GMT+08:45) Eucla",
    "Asia/Tokyo": "(GMT+09:00) Osaka, Sapporo, Tokyo",
    "Asia/Seoul": "(GMT+09:00) Seoul",
    "Asia/Yakutsk": "(GMT+09:00) Yakutsk",
    "Australia/Adelaide": "(GMT+09:30) Adelaide",
    "Australia/Darwin": "(GMT+09:30) Darwin",
    "Australia/Brisbane": "(GMT+10:00) Brisbane",
    "Australia/Hobart": "(GMT+10:00) Hobart",
    "Asia/Vladivostok": "(GMT+10:00) Vladivostok",
    "Australia/Lord_Howe": "(GMT+10:30) Lord Howe Island",
    "Etc/GMT-11": "(GMT+11:00) Solomon Is., New Caledonia",
    "Asia/Magadan": "(GMT+11:00) Magadan",
    "Pacific/Norfolk": "(GMT+11:30) Norfolk Island",
    "Asia/Anadyr": "(GMT+12:00) Anadyr, Kamchatka",
    "Pacific/Auckland": "(GMT+12:00) Auckland, Wellington",
    "Etc/GMT-12": "(GMT+12:00) Fiji, Kamchatka, Marshall Is.",
    "Pacific/Chatham": "(GMT+12:45) Chatham Islands",
    "Pacific/Tongatapu": "(GMT+13:00) Nuku'alofa",
    "Pacific/Kiritimati": "(GMT+14:00) Kiritimati"
}

<select id="timezone-select" class="form-select">
</select>

const timezoneSelect = document.getElementById("timezone-select");

for (const [value, text] of Object.entries(timezone)) {
    const option = document.createElement("option");
    option.value = value;
    option.text = text;
    timezoneSelect.appendChild(option);
}

<?php
$timezone = array(
    // Pacific Time Zones
    "Pacific/Midway"         => "(GMT-11:00) Midway Island",
    "America/Adak"           => "(GMT-10:00) Hawaii-Aleutian",
    "Etc/GMT+10"             => "(GMT-10:00) Hawaii",
    "Pacific/Marquesas"      => "(GMT-09:30) Marquesas Islands",
    "Pacific/Gambier"        => "(GMT-09:00) Gambier Islands",
    "America/Anchorage"      => "(GMT-09:00) Alaska",
    "America/Ensenada"       => "(GMT-08:00) Tijuana, Baja California",
    "Etc/GMT+8"              => "(GMT-08:00) Pitcairn Islands",
    "America/Los_Angeles"    => "(GMT-08:00) Pacific Time (US & Canada)",
    "America/Denver"         => "(GMT-07:00) Mountain Time (US & Canada)",
    "America/Chihuahua"      => "(GMT-07:00) Chihuahua, La Paz, Mazatlan",
    "America/Dawson_Creek"   => "(GMT-07:00) Arizona",
    "America/Belize"         => "(GMT-06:00) Saskatchewan, Central America",
    "America/Cancun"         => "(GMT-06:00) Guadalajara, Mexico City, Monterrey",
    "Chile/EasterIsland"     => "(GMT-06:00) Easter Island",
    "America/Chicago"        => "(GMT-06:00) Central Time (US & Canada)",

    // Eastern Time Zones
    "America/New_York"       => "(GMT-05:00) Eastern Time (US & Canada)",
    "America/Havana"         => "(GMT-05:00) Cuba",
    "America/Bogota"         => "(GMT-05:00) Bogota, Lima, Quito, Rio Branco",
    "America/Caracas"        => "(GMT-04:30) Caracas",
    "America/Santiago"       => "(GMT-04:00) Santiago",
    "America/La_Paz"         => "(GMT-04:00) La Paz",
    "Atlantic/Stanley"       => "(GMT-04:00) Faukland Islands",
    "America/Campo_Grande"   => "(GMT-04:00) Brazil",
    "America/Goose_Bay"      => "(GMT-04:00) Atlantic Time (Goose Bay)",
    "America/Glace_Bay"      => "(GMT-04:00) Atlantic Time (Canada)",
    "America/St_Johns"       => "(GMT-03:30) Newfoundland",

    // South American Time Zones
    "America/Araguaina"      => "(GMT-03:00) UTC-3",
    "America/Montevideo"     => "(GMT-03:00) Montevideo",
    "America/Miquelon"       => "(GMT-03:00) Miquelon, St. Pierre",
    "America/Godthab"        => "(GMT-03:00) Greenland",
    "America/Argentina/Buenos_Aires" => "(GMT-03:00) Buenos Aires",
    "America/Sao_Paulo"      => "(GMT-03:00) Brasilia",

    // Atlantic and Azores Time Zones
    "America/Noronha"        => "(GMT-02:00) Mid-Atlantic",
    "Atlantic/Cape_Verde"    => "(GMT-01:00) Cape Verde Is.",
    "Atlantic/Azores"        => "(GMT-01:00) Azores",

    // Western European Time Zones
    "Europe/Belfast"         => "(GMT) Greenwich Mean Time : Belfast",
    "Europe/Dublin"          => "(GMT) Greenwich Mean Time : Dublin",
    "Europe/Lisbon"          => "(GMT) Greenwich Mean Time : Lisbon",
    "Europe/London"          => "(GMT) Greenwich Mean Time : London",
    "Africa/Abidjan"         => "(GMT) Monrovia, Reykjavik",

    // Central European Time Zones
    "Europe/Amsterdam"       => "(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna",
    "Europe/Belgrade"        => "(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague",
    "Europe/Brussels"        => "(GMT+01:00) Brussels, Copenhagen, Madrid, Paris",
    "Africa/Algiers"         => "(GMT+01:00) West Central Africa",
    "Africa/Windhoek"        => "(GMT+01:00) Windhoek",

    // Eastern European and African Time Zones
    "Asia/Beirut"            => "(GMT+02:00) Beirut",
    "Africa/Cairo"           => "(GMT+02:00) Cairo",
    "Asia/Gaza"              => "(GMT+02:00) Gaza",
    "Africa/Blantyre"        => "(GMT+02:00) Harare, Pretoria",
    "Asia/Jerusalem"         => "(GMT+02:00) Jerusalem",
    "Europe/Minsk"           => "(GMT+02:00) Minsk",
    "Asia/Damascus"          => "(GMT+02:00) Syria",

    // Further Eastern Time Zones
    "Europe/Moscow"          => "(GMT+03:00) Moscow, St. Petersburg, Volgograd",
    "Africa/Addis_Ababa"     => "(GMT+03:00) Nairobi",
    "Asia/Tehran"            => "(GMT+03:30) Tehran",
    "Asia/Dubai"             => "(GMT+04:00) Abu Dhabi, Muscat",
    "Asia/Yerevan"           => "(GMT+04:00) Yerevan",
    "Asia/Kabul"             => "(GMT+04:30) Kabul",
    "Asia/Yekaterinburg"     => "(GMT+05:00) Ekaterinburg",
    "Asia/Tashkent"          => "(GMT+05:00) Tashkent",
    "Asia/Kolkata"           => "(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi",
    "Asia/Katmandu"          => "(GMT+05:45) Kathmandu",
    "Asia/Dhaka"             => "(GMT+06:00) Astana, Dhaka",
    "Asia/Novosibirsk"       => "(GMT+06:00) Novosibirsk",
    "Asia/Rangoon"           => "(GMT+06:30) Yangon (Rangoon)",
    "Asia/Bangkok"           => "(GMT+07:00) Bangkok, Hanoi, Jakarta",
    "Asia/Krasnoyarsk"       => "(GMT+07:00) Krasnoyarsk",
    "Asia/Hong_Kong"         => "(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi",
    "Asia/Irkutsk"           => "(GMT+08:00) Irkutsk, Ulaan Bataar",
    "Australia/Perth"        => "(GMT+08:00) Perth",
    "Australia/Eucla"        => "(GMT+08:45) Eucla",
    "Asia/Tokyo"             => "(GMT+09:00) Osaka, Sapporo, Tokyo",
    "Asia/Seoul"             => "(GMT+09:00) Seoul",
    "Asia/Yakutsk"           => "(GMT+09:00) Yakutsk",
    "Australia/Adelaide"     => "(GMT+09:30) Adelaide",
    "Australia/Darwin"       => "(GMT+09:30) Darwin",
    "Australia/Brisbane"     => "(GMT+10:00) Brisbane",
    "Australia/Hobart"       => "(GMT+10:00) Hobart",
    "Asia/Vladivostok"       => "(GMT+10:00) Vladivostok",
    "Australia/Lord_Howe"    => "(GMT+10:30) Lord Howe Island",
    "Etc/GMT-11"             => "(GMT+11:00) Solomon Is., New Caledonia",
    "Asia/Magadan"           => "(GMT+11:00) Magadan",
    "Pacific/Norfolk"        => "(GMT+11:30) Norfolk Island",
    "Asia/Anadyr"            => "(GMT+12:00) Anadyr, Kamchatka",
    "Pacific/Auckland"       => "(GMT+12:00) Auckland, Wellington",
    "Etc/GMT-12"             => "(GMT+12:00) Fiji, Kamchatka, Marshall Is.",
    "Pacific/Chatham"        => "(GMT+12:45) Chatham Islands",
    "Pacific/Tongatapu"      => "(GMT+13:00) Nuku'alofa",
    "Pacific/Kiritimati"     => "(GMT+14:00) Kiritimati"
);
?>

-- Create the timezone table
CREATE TABLE IF NOT EXISTS `timezone` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `code` VARCHAR(30) NOT NULL,
    `name` VARCHAR(50) NOT NULL,
    `offset` VARCHAR(9) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert data into the timezone table
INSERT INTO `timezone` (`id`, `code`, `name`, `offset`) VALUES
(1, 'Pacific/Midway', 'Midway Island', '-11:00'),
(2, 'America/Adak', 'Hawaii-Aleutian', '-10:00'),
(3, 'Etc/GMT+10', 'Hawaii', '-10:00'),
(4, 'Pacific/Marquesas', 'Marquesas Islands', '-09:30'),
(5, 'Pacific/Gambier', 'Gambier Islands', '-09:00'),
(6, 'America/Anchorage', 'Alaska', '-09:00'),
(7, 'America/Tijuana', 'Tijuana, Baja California', '-08:00'),
(8, 'Etc/GMT+8', 'Pitcairn Islands', '-08:00'),
(9, 'America/Los_Angeles', 'Pacific Time (US & Canada)', '-08:00'),
(10, 'America/Denver', 'Mountain Time (US & Canada)', '-07:00'),
(11, 'America/Chihuahua', 'Chihuahua, La Paz, Mazatlan', '-07:00'),
(12, 'America/Phoenix', 'Arizona', '-07:00'),
(13, 'America/Belize', 'Saskatchewan, Central America', '-06:00'),
(14, 'America/Mexico_City', 'Guadalajara, Mexico City, Monterrey', '-06:00'),
(15, 'Pacific/Easter', 'Easter Island', '-06:00'),
(16, 'America/Chicago', 'Central Time (US & Canada)', '-06:00'),
(17, 'America/New_York', 'Eastern Time (US & Canada)', '-05:00'),
(18, 'America/Havana', 'Cuba', '-05:00'),
(19, 'America/Bogota', 'Bogota, Lima, Quito, Rio Branco', '-05:00'),
(20, 'America/Caracas', 'Caracas', '-04:30'),
(21, 'America/Santiago', 'Santiago', '-04:00'),
(22, 'America/La_Paz', 'La Paz', '-04:00'),
(23, 'Atlantic/Stanley', 'Falkland Islands', '-04:00'),
(24, 'America/Campo_Grande', 'Brazil', '-04:00'),
(25, 'America/Goose_Bay', 'Atlantic Time (Goose Bay)', '-04:00'),
(26, 'America/Glace_Bay', 'Atlantic Time (Canada)', '-04:00'),
(27, 'America/St_Johns', 'Newfoundland', '-03:30'),
(28, 'America/Araguaina', 'UTC-3', '-03:00'),
(29, 'America/Montevideo', 'Montevideo', '-03:00'),
(30, 'America/Miquelon', 'Miquelon, St. Pierre', '-03:00'),
(31, 'America/Godthab', 'Greenland', '-03:00'),
(32, 'America/Argentina/Buenos_Aires', 'Buenos Aires', '-03:00'),
(33, 'America/Sao_Paulo', 'Brasilia', '-03:00'),
(34, 'America/Noronha', 'Mid-Atlantic', '-02:00'),
(35, 'Atlantic/Cape_Verde', 'Cape Verde Is.', '-01:00'),
(36, 'Atlantic/Azores', 'Azores', '-01:00'),
(37, 'Europe/London', 'Greenwich Mean Time : London', '+00:00'),
(38, 'Europe/Dublin', 'Greenwich Mean Time : Dublin', '+00:00'),
(39, 'Europe/Lisbon', 'Greenwich Mean Time : Lisbon', '+00:00'),
(40, 'Africa/Monrovia', 'Monrovia, Reykjavik', '+00:00'),
(41, 'Europe/Amsterdam', 'Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna', '+01:00'),
(42, 'Europe/Belgrade', 'Belgrade, Bratislava, Budapest, Ljubljana, Prague', '+01:00'),
(43, 'Europe/Brussels', 'Brussels, Copenhagen, Madrid, Paris', '+01:00'),
(44, 'Africa/Algiers', 'West Central Africa', '+01:00'),
(45, 'Africa/Windhoek', 'Windhoek', '+01:00'),
(46, 'Asia/Beirut', 'Beirut', '+02:00'),
(47, 'Africa/Cairo', 'Cairo', '+02:00'),
(48, 'Asia/Gaza', 'Gaza', '+02:00'),
(49, 'Africa/Harare', 'Harare, Pretoria', '+02:00'),
(50, 'Asia/Jerusalem', 'Jerusalem', '+02:00'),
(51, 'Europe/Minsk', 'Minsk', '+02:00'),
(52, 'Asia/Damascus', 'Syria', '+02:00'),
(53, 'Europe/Moscow', 'Moscow, St. Petersburg, Volgograd', '+03:00'),
(54, 'Africa/Nairobi', 'Nairobi', '+03:00'),
(55, 'Asia/Tehran', 'Tehran', '+03:30'),
(56, 'Asia/Dubai', 'Abu Dhabi, Muscat', '+04:00'),
(57, 'Asia/Yerevan', 'Yerevan', '+04:00'),
(58, 'Asia/Kabul', 'Kabul', '+04:30'),
(59, 'Asia/Yekaterinburg', 'Ekaterinburg', '+05:00'),
(60, 'Asia/Tashkent', 'Tashkent', '+05:00'),
(61, 'Asia/Kolkata', 'Chennai, Kolkata, Mumbai, New Delhi', '+05:30'),
(62, 'Asia/Kathmandu', 'Kathmandu', '+05:45'),
(63, 'Asia/Dhaka', 'Astana, Dhaka', '+06:00'),
(64, 'Asia/Novosibirsk', 'Novosibirsk', '+06:00'),
(65, 'Asia/Rangoon', 'Yangon (Rangoon)', '+06:30'),
(66, 'Asia/Bangkok', 'Bangkok, Hanoi, Jakarta', '+07:00'),
(67, 'Asia/Krasnoyarsk', 'Krasnoyarsk', '+07:00'),
(68, 'Asia/Hong_Kong', 'Beijing, Chongqing, Hong Kong, Urumqi', '+08:00'),
(69, 'Asia/Irkutsk', 'Irkutsk, Ulaan Bataar', '+08:00'),
(70, 'Australia/Perth', 'Perth', '+08:00'),
(71, 'Australia/Eucla', 'Eucla', '+08:45'),
(72, 'Asia/Tokyo', 'Osaka, Sapporo, Tokyo', '+09:00'),
(73, 'Asia/Seoul', 'Seoul', '+09:00'),
(74, 'Asia/Yakutsk', 'Yakutsk', '+09:00'),
(75, 'Australia/Adelaide', 'Adelaide', '+09:30'),
(76, 'Australia/Darwin', 'Darwin', '+09:30'),
(77, 'Australia/Brisbane', 'Brisbane', '+10:00'),
(78, 'Australia/Hobart', 'Hobart', '+10:00'),
(79, 'Asia/Vladivostok', 'Vladivostok', '+10:00'),
(80, 'Australia/Lord_Howe', 'Lord Howe Island', '+10:30'),
(81, 'Etc/GMT-11', 'Solomon Is., New Caledonia', '+11:00'),
(82, 'Asia/Magadan', 'Magadan', '+11:00'),
(83, 'Pacific/Norfolk', 'Norfolk Island', '+11:30'),
(84, 'Asia/Anadyr', 'Anadyr, Kamchatka', '+12:00'),
(85, 'Pacific/Auckland', 'Auckland, Wellington', '+12:00'),
(86, 'Etc/GMT-12', 'Fiji, Kamchatka, Marshall Is.', '+12:00'),
(87, 'Pacific/Chatham', 'Chatham Islands', '+12:45'),
(88, 'Pacific/Tongatapu', 'Nuku\'alofa', '+13:00'),
(89, 'Pacific/Kiritimati', 'Kiritimati', '+14:00');