ممكن جدول دول العالم

[Danger_Zone]

هل اجد لدى أحدكم قاعدة بينات لدول العالم باللغة الانجليزية مرتبة
يعني يحتوي على عمودين ID واسم الدولة
وشكرا

[المحروقي]

شوف هذي الخدمة ممكن تفيدك
http://almah.net/s/index.php?p=time

[Danger_Zone]

تسلم يا اخي لكني احتاج أسماء الدول فقط وما يهمني التوقيت وغيرة
ممكن جدول الدول ؟

[Danger_Zone]

رحت وين يا المحروقي

[المحروقي]

هلا الحبيب..

جدول للأسف ما عندي..

اذا كنت مبرمج ممكن تسوي كود بسيط يقوم بإستخلاص أسماء الدول ويضعها لك في جدول... بس ما فهمت كلمة ID

ايش تقصد إمتداد الدومين؟ مثل السعودية sa وعمان om؟

[Danger_Zone]

خلاص سويتها كان في بالي اسويه بس قلت يمكن في شي جاهز
سويته وخلصت والحمدلله
وشكرا

id مجرد رقم متسلسل

[العثمان]

تفضل:

UTC">(UTC/GMT)
AF">Afghanistan
AL">Albania
DZ">Algeria
AS">American Samoa
AD">Andorra
AO">Angola
AI">Anguilla
AG">Antigua and Barbuda
AR">Argentina
AM">Armenia
AW">Aruba
AU-ACT">Australia, Australian Capital Territory
AU3">Australia, Broken Hill
AU1">Australia, Lord Howe Island
AU-NSW">Australia, New South Wales
AU-NT">Australia, Northern Territory
AU-QLD">Australia, Queensland
AU-SA">Australia, South Australia
AU-TAS">Australia, Tasmania
AU-VIC">Australia, Victoria
AU-WA">Australia, Western Australia
AT">Austria
AZ">Azerbaijan
BS">Bahamas
BH">Bahrain
BD">Bangladesh
BB">Barbados
BY">Belarus
BE">Belgium
BZ">Belize
BJ">Benin
BM">Bermuda
BT">Bhutan
BO">Bolivia
BA">Bosnia and Herzegovina
BW">Botswana
BR-AC">Brazil, Acre
BR-AL">Brazil, Alagoas
BR-AP">Brazil, Amapa
BR-AM">Brazil, Amazonas
BR-BA">Brazil, Bahia
BR-CE">Brazil, Ceara
BR-DF">Brazil, Distrito Federal
BR-ES">Brazil, Espirto Santo
BR-FN">Brazil, Fernando de Noronha
BR-GO">Brazil, Goias
BR-MA">Brazil, Maranhao
BR-MT">Brazil, Mato Grosso
BR-MS">Brazil, Mato Grosso do Sul
BR-MG">Brazil, Minas Gerais
BR-PA1">Brazil, Para (eastern)
BR-PA2">Brazil, Para (western)
BR-PB">Brazil, Paraiba
BR-PR">Brazil, Parana
BR-PE">Brazil, Pernambuco
BR-PI">Brazil, Piaui
BR-RN">Brazil, Rio Grande do Norte
BR-RS">Brazil, Rio Grande do Sul
BR-RJ">Brazil, Rio deJaneiro
BR-RO">Brazil, Rondonia
BR-RR">Brazil, Roraima
BR-SC">Brazil, Santa Catarina
BR-SP">Brazil, Sao Paulo
BR-SE">Brazil, Sergipe
BR-TO">Brazil, Tocantins
BN">Brunei Darussalam
BG">Bulgaria
BF">Burkina Faso
BI">Burundi
KH">Cambodia
CM">Cameroon
CA-AB">Canada, Alberta
CA-BC">Canada, British Columbia
CA-BC1">Canada, British Columbia (exception 1)
CA-BC2">Canada, British Columbia (exception 2)
CA2">Canada, Labrador
CA2A">Canada, Labrador (exception)
CA-MB">Canada, Manitoba
CA-NB">Canada, New Brunswick
CA-NF">Canada, Newfoundland
CA-NT">Canada, Northwest Territories
CA-NS">Canada, Nova Scotia
CA-NT2B">Canada, Nunavut (Central)
CA-NT2">Canada, Nunavut (Eastern)
CA-NT2C">Canada, Nunavut (Mountain)
CA-NT2A">Canada, Nunavut - Southampton Island
CA-ON">Canada, Ontario
CA-ON1">Canada, Ontario (western)
CA-PE">Canada, Prince Edward Island
CA-QC">Canada, Quebec
CA-SK">Canada, Saskatchewan
CA-SK2">Canada, Saskatchewan (exceptions - east)
CA-SK1">Canada, Saskatchewan (exceptions - west)
CA-YT">Canada, Yukon
CV">Cape Verde
KY">Cayman Islands
CF">Central African Republic
TD">Chad
CL">Chile
CL2">Chile - Easter Island
CN">China
CX">Christmas Island (Indian Ocean)
CC">Cocos (Keeling) Islands
CO">Colombia
KM">Comoros
CG">Congo
CD2">Congo, Democratic Republic of, Kasai
Occidental, Kasai Oriental, Haut-Zaire, Shaba
CD">Congo, Democratic Republic of, Kinshasa, Bandungu, Bas-Zaire, Equateur
CK">Cook Islands
CR">Costa Rica
CI">Cote D'Ivoire
HR">Croatia
CU">Cuba
CY">Cyprus
CZ">Czech Republic
DK">Denmark
DJ">Djibouti
DM">Dominica
DO">Dominican Republic
EC">Ecuador
EC2">Ecuador - Galapagos Islands
EG">Egypt
SV">El Salvador
GQ">Equatorial Guinea
ER">Eritrea
EE">Estonia
ET">Ethiopia
FK">Falkland Islands (Malvinas)
FO">Faroe Islands
FJ">Fiji
FI">Finland
FR">France
GF">French Guiana
PF3">French Polynesia, Gambier
Islands
PF1">French Polynesia, Marquesas Islands
PF">French Polynesia, Society Archipelago (including Tahiti)
PF2B">French Polynesia, Tuamotu Archipelago
PF2A">French Polynesia, Tubuai Islands
GA">Gabon
GM">Gambia
GE">Georgia
DE">Germany
GH">Ghana
GI">Gibraltar
GR">Greece
GL">Greenland, Greenland
GL3">Greenland, Ittoqqortoormiit, Nerlerit Inaat
GL2">Greenland, Pituffik
GD">Grenada
GP">Guadeloupe
GU">Guam
GT">Guatemala
GN">Guinea
GW">Guinea-Bissau
GY">Guyana
HT">Haiti
HN">Honduras
HK">Hong Kong
HU">Hungary
IS">Iceland
IN">India
ID2">Indonesia, (Central)
ID3">Indonesia, (Eastern)
ID">Indonesia, (Western)
IR">Iran, Islamic Republic of
IQ">Iraq
IE">Ireland
IL">Israel
IT">Italy
JM">Jamaica
JP">Japan
UM1">Johnston Atoll (U.S.)
JO">Jordan
KZ2">Kazakhstan, Central
KZ">Kazakhstan, Eastern
KZ1">Kazakhstan, Western
KE">Kenya
KI">Kiribati, Gilbert Islands
KI2">Kiribati, Line Islands
KI3">Kiribati, Phoenix Islands
KP">Korea, Democratic People's Republic of
KR">Korea, Republic of
KW">Kuwait
KG">Kyrgyzstan
LA">Lao People's Democratic Republic
LV">Latvia
LB">Lebanon
LS">Lesotho
LR">Liberia
LY">Libyan Arab Jamahiriya
LI">Liechtenstein
LT">Lithuania
LU">Luxembourg
MO">Macao
MK">Macedonia, The Former Yugoslav Republic Of
MG">Madagascar
MW">Malawi
MY">Malaysia
MV">Maldives
ML">Mali
MT">Malta
MH">Marshall Islands
MQ">Martinique
MR">Mauritania
MU">Mauritius
YT">Mayotte
MX3">Mexico, Baja California Norte
MX2">Mexico, Baja California Sur
MX2-3">Mexico, Chihuahua
MX2-1">Mexico, Nayarit
MX2-2">Mexico, Sinaloa
MX2A">Mexico, Sonora
MX">Mexico, South, Central, and Eastern
UM2">Midway Islands (U.S.)
MD">Moldova, Republic of
MC">Monaco
MN">Mongolia
MS">Montserrat
MA">Morocco
MZ">Mozambique
MM">Myanmar
NA">Namibia
NR">Nauru
NP">Nepal
NL">Netherlands
AN">Netherlands Antilles
NC">New Caledonia
NZ">New Zealand
NZ2">New Zealand - Chatham Islands
NI">Nicaragua
NE">Niger
NG">Nigeria
NU">Niue
NF">Norfolk Island
MP">Northern Mariana Islands
NO">Norway
OM" selected>Oman
PK">Pakistan
PW">Palau
PS">Palestinian Territory
PA">Panama
PG">Papua New Guinea
PY">Paraguay
PE">Peru
PH">Philippines
PL">Poland
PT2">Portugal, Azores
PT">Portugal, Mainland, Madeira
PR">Puerto Rico
QA">Qatar
RE">Reunion
RO">Romania
RU10">Russian Federation, (Zone 10)
RU11">Russian Federation, (Zone 11)
RU1">Russian Federation, (Zone 01)
RU">Russian Federation, (Zone 02)
RU3">Russian Federation, (Zone 03)
RU4">Russian Federation, (Zone 04)
RU5">Russian Federation, (Zone 05)
RU6">Russian Federation, (Zone 06)
RU7">Russian Federation, (Zone 07)
RU8">Russian Federation, (Zone 08)
RU9">Russian Federation, (Zone 09)
RW">Rwanda
SH">Saint Helena
KN">Saint Kitts and Nevis
LC">Saint Lucia
PM">Saint Pierre and Miquelon
VC">Saint Vincent and The Grenadines
WS">Samoa
SM">San Marino
ST">Sao Tome and Principe
SA">Saudi Arabia
SN">Senegal
CS">Serbia and Montenegro
SC">Seychelles
SL">Sierra Leone
SG">Singapore
SK">Slovakia
SI">Slovenia
SB">Solomon Islands
SO">Somalia
ZA">South Africa
ES2">Spain, Canary Islands
ES">Spain, Mainland, Baleares, Melilla, Ceuta
LK">Sri Lanka
SD">Sudan
SR">Suriname
SJ">Svalbard and Jan Mayen
SZ">Swaziland
SE">Sweden
CH">Switzerland
SY">Syrian Arab Republic
TW">Taiwan
TJ">Tajikistan
TZ">Tanzania, United Republic of
TH">Thailand
TL">Timor-Leste
TG">Togo
TO">Tonga
TT">Trinidad and Tobago
TN">Tunisia
TR">Turkey
TM">Turkmenistan
TC">Turks and Caicos Islands
TV">Tuvalu
UG">Uganda
UA">Ukraine
AE">United Arab Emirates
GB">United Kingdom
US-AL">United States, Alabama
US-AK">United States, Alaska
US-AK1">United States, Alaska (Aleutian Islands)
US-AZ">United States, Arizona
US-AZ1">United States, Arizona (Navajo Reservation)
US-AR">United States, Arkansas
US-CA">United States, California
US-CO">United States, Colorado
US-CT">United States, Connecticut
US-DE">United States, Delaware
US-DC">United States, District of Columbia
US-FL">United States, Florida
US-FL1">United States, Florida (far west)
US-GA">United States, Georgia
US-HI">United States, Hawaii
US-ID1">United States, Idaho (northern)
US-ID">United States, Idaho (southern)
US-IL">United States, Illinois
US-IN">United States, Indiana
US-IN2">United States, Indiana (exceptions)
US-IN1">United States, Indiana (southwest and northwest corners)
US-IA">United States, Iowa
US-KS">United States, Kansas
US-KS1">United States, Kansas (exception)
US-KY">United States, Kentucky (eastern)
US-KY1">United States, Kentucky (western)
US-LA">United States, Louisiana
US-ME">United States, Maine
US-MD">United States, Maryland
US-MA">United States, Massachusetts
US-MI">United States, Michigan
US-MI1">United States, Michigan (exception)
US-MN">United States, Minnesota
US-MS">United States, Mississippi
US-MO">United States, Missouri
US-MT">United States, Montana
US-NE">United States, Nebraska
US-NE1">United States, Nebraska (western)
US-NV">United States, Nevada
US-NH">United States, New Hampshire
US-NJ">United States, New Jersey
US-NM">United States, New Mexico
US-NY">United States, New York
US-NC">United States, North Carolina
US-ND">United States, North Dakota
US-ND1">United States, North Dakota (western)
US-OH">United States, Ohio
US-OK">United States, Oklahoma
US-OR">United States, Oregon
US-OR1">United States, Oregon (exception)
US-PA">United States, Pennsylvania
US-RI">United States, Rhode Island
US-SC">United States, South Carolina
US-SD">United States, South Dakota (eastern)
US-SD1">United States, South Dakota (western)
US-TN1">United States, Tennessee (eastern)
US-TN">United States, Tennessee (western)
US-TX">United States, Texas
US-TX1">United States, Texas (far west)
US-UT">United States, Utah
US-VT">United States, Vermont
US-VA">United States, Virginia
US-WA">United States, Washington
US-WV">United States, West Virginia
US-WI">United States, Wisconsin
US-WY">United States, Wyoming
UY">Uruguay
UZ">Uzbekistan
VU">Vanuatu
VE">Venezuela
VN">Viet Nam
VG">Virgin Islands (British)
VI">Virgin Islands (U.S.)
UM3">Wake Island (U.S.)
WF">Wallis and Futuna
YE">Yemen
ZM">Zambia
ZW">Zimbabwe