Location: PHPKode > scripts > queryList > querylist/install_tbl_country.php
<?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!
Return current item: queryList