<?php
include ("dbConnect.php");
$country = array(
"ad" => "Andorra",
"ae" => "United Arab Emirates",
"af" => "Afghanistan",
"ag" => "Antigua and Barbuda",
"ai" => "Anguilla",
"al" => "Albania",
"am" => "Armenia",
"an" => "Netherlands Antilles",
"ao" => "Angola",
"aq" => "Antartica",
"ar" => "Argentina",
"as" => "American Samoa",
"at" => "Austria",
"au" => "Australia",
"aw" => "Aruba",
"az" => "Azerbaijan",
"ba" => "Bosnia and Herzegovina",
"bb" => "Barbados",
"bd" => "Bangladesh",
"be" => "Belgium",
"bf" => "Burkina Faso",
"bg" => "Bulgaria",
"bh" => "Bahrain",
"bi" => "Burundi",
"bj" => "Benin",
"bm" => "Bermuda",
"bn" => "Brunei Darussalam",
"bo" => "Bolivia",
"br" => "Brazil",
"bs" => "Bahamas",
"bt" => "Bhutan",
"bv" => "Bouvet Island",
"bw" => "Botswana",
"by" => "Belorussia",
"bz" => "Belize",
"ca" => "Canada",
"cc" => "Cocos (Keeling) Islands",
"cd" => "Democatric Republic of Congo",
"cf" => "Central African Republic",
"cg" => "Congo",
"ch" => "Switzerland",
"ci" => "Cote D'Ivoire (Ivory Coast)",
"ck" => "Cook Islands",
"cl" => "Chile",
"cm" => "Cameroon",
"cn" => "China",
"co" => "Colombia",
"cr" => "Costa Rica",
"cs" => "Czechoslovakia",
"cu" => "Cuba",
"cv" => "Cape Verde",
"cx" => "Christmas Island",
"cy" => "Cyprus",
"cz" => "Czech",
"de" => "Germany",
"dj" => "Djibouti",
"dk" => "Denmark",
"dm" => "Dominica",
"do" => "Dominican Republic",
"dz" => "Algeria",
"ec" => "Ecuador",
"ee" => "Estonia",
"eg" => "Egypt",
"eh" => "Western Sahara",
"er" => "Eritrea",
"es" => "Spain",
"et" => "Ethiopia",
"fi" => "Finland",
"fj" => "Fiji",
"fk" => "Falkland Islands (Malvinas)",
"fm" => "Micronesia",
"fo" => "Faroe Islands",
"fr" => "France",
"fx" => "France, Metropolitan",
"ga" => "Gabon",
"gb" => "Great Britain",
"gd" => "Grenada",
"ge" => "Georgia",
"gf" => "French Guiana",
"gh" => "Ghana",
"gi" => "Gibraltar",
"gl" => "Greenland",
"gm" => "Gambia",
"gn" => "Guinea",
"gp" => "Guadelope",
"gq" => "Equatorial Guinea",
"gr" => "Greece",
"gs" => "S.Georgia and S.Sandwich Isls.",
"gt" => "Guatemala",
"gu" => "Guam",
"gw" => "Guinea Bissau",
"gy" => "Gyana",
"hk" => "Hong Kong",
"hm" => "Heard and McDonald Islands",
"hn" => "Honduras",
"hr" => "Croatia",
"ht" => "Haiti",
"hu" => "Hungary",
"id" => "Indonesia",
"ie" => "Ireland",
"il" => "Israel",
"in" => "India",
"io" => "British Idian Ocean Territory",
"iq" => "Iraq",
"ir" => "Iran",
"is" => "Iceland",
"it" => "Italy",
"jm" => "Jamaica",
"jo" => "Jordan",
"jp" => "Japan",
"ke" => "Kenya",
"kg" => "Kyrgyzstan",
"kh" => "Cambodia",
"ki" => "Kiribati",
"km" => "Comoros",
"kn" => "Saint Kitts and Nevis",
"kp" => "North Korea",
"kr" => "South Korea",
"kw" => "Kuwait",
"ky" => "Cayman Islands",
"kz" => "Kazakhstan",
"la" => "Laos",
"lb" => "Lebanon",
"lc" => "Saint Lucia",
"li" => "Liechtenstein",
"lk" => "Sri Lanka",
"lr" => "Liberia",
"ls" => "Lesotho",
"lt" => "Lithuania",
"lu" => "Luxembourg",
"lv" => "Latvia",
"ly" => "Lybia",
"ma" => "Marocco",
"mc" => "Monaco",
"md" => "Moldova",
"mg" => "Madagascar", # need
"mh" => "Marshall Islands", # need
"mk" => "Macedonia",
"ml" => "Mali", # need
"mm" => "Myanmar", # need
"mn" => "Mongolia", # need
"mo" => "Macau", # need
"mp" => "Northern Mariana Islands", # need
"mq" => "Martinique",
"mr" => "Mauritania",
"ms" => "Montserrat", # need
"mt" => "Malta",
"mu" => "Mauritius",
"mv" => "Maldives", # need
"mw" => "Malawi", # need
"mx" => "Mexico",
"my" => "Malaysia",
"mz" => "Mozambique", # need
"na" => "Namibia",
"nc" => "New Caledonia", # need
"ne" => "Niger",
"nf" => "Norfolk Island", # need
"ng" => "Nigeria",
"ni" => "Nicaragua",
"nl" => "Netherlands",
"no" => "Norway",
"np" => "Nepal",
"nr" => "Nauru", # need
"nt" => "Neutral Zone", # need
"nu" => "Niue",
"nz" => "New Zealand",
"om" => "Oman",
"pa" => "Panama",
"pe" => "Peru",
"pf" => "French Polynesia",
"pg" => "Papua New Guinea", # need
"ph" => "Philippines",
"pk" => "Pakistan",
"pl" => "Poland",
"pm" => "St. Pierre and Miquelon", # need
"pn" => "Pitcairn", # need
"pr" => "Puerto Rico", # need
"pt" => "Portugal",
"pw" => "Palau", # need
"py" => "Paraguay",
"qa" => "Qatar",
"re" => "Reunion", # need
"ro" => "Romania",
"ru" => "Russian Federation",
"rw" => "Rwanda",
"sa" => "Saudi Arabia",
"sb" => "Solomon Islands",
"sc" => "Seychelles", # need
"sd" => "Sudan", # need
"se" => "Sweden",
"sg" => "Singapore",
"sh" => "St. Helena", # need
"si" => "Slovania",
"sj" => "Svalbard and Jan Mayen Islands", # need
"sk" => "Slovak Republic",
"sl" => "Sierra Leone", # need
"sm" => "San Marino", # need
"sn" => "Senegal", # need
"so" => "Somalia", # need
"sr" => "Suriname", # need
"st" => "Sao Tome and Principe", # need
"su" => "Soviet Union",
"sv" => "El Salvador", # need
"sy" => "Syria",
"sz" => "Swaziland",
"tc" => "Turks and Caicos Islands",
"td" => "Chad",
"tf" => "French Southern Territories",
"tg" => "Togo",
"th" => "Thailand",
"tj" => "Tajikistan", # need
"tk" => "Tokelau",
"tm" => "Turkmenistan",
"tn" => "Tunisia",
"to" => "Tonga",
"tp" => "East Timor", # need
"tr" => "Turkey",
"tt" => "Trinidad and Tobago",
"tv" => "Tuvalu", # need
"tw" => "Taiwan",
"tz" => "Tanzania",
"ua" => "Ukraine",
"ug" => "Uganda",
"uk" => "United Kingdom",
"um" => "US Minor Outlying Islands",
"us" => "United States",
"uy" => "Uruguay",
"uz" => "Uzbekistan",
"va" => "Vatican City State (Holy See)",
"vc" => "Saint Vincent and the Grenadines",
"ve" => "Venezuela",
"vg" => "Virgin Islands (British)",
"vi" => "Virgin Islands (US)",
"vn" => "Vietnam",
"wf" => "Wallis and Futuna Islands",
"ws" => "Samoa",
"ye" => "Yemen",
"yt" => "Mayotte",
"yu" => "Yugoslavia",
"za" => "South Africa",
"ze" => "Zaire",
"zm" => "Zambia",
"zw" => "Zimbabwe"
);
/* ----------------------------------------------------------- */
mysql_query("DROP TABLE IF EXISTS tbl_Country");
mysql_query("CREATE TABLE tbl_Country ( code char(2) NOT NULL default '', country varchar(32)
NOT NULL default '', UNIQUE KEY code (code)) TYPE=MyISAM COMMENT='Table des Pays' ");
foreach($country as $k => $v) {
mysql_query("INSERT INTO `tbl_Country` (`code` ,`country` ) VALUES ('$k','$v') ");
}
?>Installation finished!
|