Hi shivneetns
OK, can I ask why use a DB, realistically this could only be a ‘table’ that I would add to my DB why not just serve up JSON files e.g.
var countrylist = [{'label':'Afghanistan','id':'AF'},{'label':'Åland Islands','id':'AX'},{'label':'Albania','id':'AL'},{'label':'Algeria','id':'DZ'},{'label':'American Samoa','id':'AS'},{'label':'Andorra','id':'AD'},{'label':'Angola','id':'AO'},{'label':'Anguilla','id':'AI'},{'label':'Antarctica','id':'AQ'},{'label':'Antigua and Barbuda','id':'AG'},{'label':'Argentina','id':'AR'},{'label':'Armenia','id':'AM'},{'label':'Aruba','id':'AW'},{'label':'Australia','id':'AU'},{'label':'Austria','id':'AT'},{'label':'Azerbaijan','id':'AZ'},{'label':'Bahamas','id':'BS'},{'label':'Bahrain','id':'BH'},{'label':'Bangladesh','id':'BD'},{'label':'Barbados','id':'BB'},{'label':'Belarus','id':'BY'},{'label':'Belgium','id':'BE'},{'label':'Belize','id':'BZ'},{'label':'Benin','id':'BJ'},{'label':'Bermuda','id':'BM'},{'label':'Bhutan','id':'BT'},{'label':'Bolivia, Plurinational State of','id':'BO'},{'label':'Bonaire, Sint Eustatius and Saba','id':'BQ'},{'label':'Bosnia and Herzegovina','id':'BA'},{'label':'Botswana','id':'BW'},{'label':'Bouvet Island','id':'BV'},{'label':'Brazil','id':'BR'},{'label':'British Indian Ocean Territory','id':'IO'},{'label':'Brunei Darussalam','id':'BN'},{'label':'Bulgaria','id':'BG'},{'label':'Burkina Faso','id':'BF'},{'label':'Burundi','id':'BI'},{'label':'Cambodia','id':'KH'},{'label':'Cameroon','id':'CM'},{'label':'Canada','id':'CA'},{'label':'Cape Verde','id':'CV'},{'label':'Cayman Islands','id':'KY'},{'label':'Central African Republic','id':'CF'},{'label':'Chad','id':'TD'},{'label':'Chile','id':'CL'},{'label':'China','id':'CN'},{'label':'Christmas Island','id':'CX'},{'label':'Cocos (Keeling) Islands','id':'CC'},{'label':'Colombia','id':'CO'},{'label':'Comoros','id':'KM'},{'label':'Congo','id':'CG'},{'label':'Congo, the Democratic Republic of the','id':'CD'},{'label':'Cook Islands','id':'CK'},{'label':'Costa Rica','id':'CR'},{'label':'Côte d\'Ivoire','id':'CI'},{'label':'Croatia','id':'HR'},{'label':'Cuba','id':'CU'},{'label':'Curaçao','id':'CW'},{'label':'Cyprus','id':'CY'},{'label':'Czech Republic','id':'CZ'},{'label':'Denmark','id':'DK'},{'label':'Djibouti','id':'DJ'},{'label':'Dominica','id':'DM'},{'label':'Dominican Republic','id':'DO'},{'label':'Ecuador','id':'EC'},{'label':'Egypt','id':'EG'},{'label':'El Salvador','id':'SV'},{'label':'Equatorial Guinea','id':'GQ'},{'label':'Eritrea','id':'ER'},{'label':'Estonia','id':'EE'},{'label':'Ethiopia','id':'ET'},{'label':'Falkland Islands (Malvinas)','id':'FK'},{'label':'Faroe Islands','id':'FO'},{'label':'Fiji','id':'FJ'},{'label':'Finland','id':'FI'},{'label':'France','id':'FR'},{'label':'French Guiana','id':'GF'},{'label':'French Polynesia','id':'PF'},{'label':'French Southern Territories','id':'TF'},{'label':'Gabon','id':'GA'},{'label':'Gambia','id':'GM'},{'label':'Georgia','id':'GE'},{'label':'Germany','id':'DE'},{'label':'Ghana','id':'GH'},{'label':'Gibraltar','id':'GI'},{'label':'Greece','id':'GR'},{'label':'Greenland','id':'GL'},{'label':'Grenada','id':'GD'},{'label':'Guadeloupe','id':'GP'},{'label':'Guam','id':'GU'},{'label':'Guatemala','id':'GT'},{'label':'Guernsey','id':'GG'},{'label':'Guinea','id':'GN'},{'label':'Guinea-Bissau','id':'GW'},{'label':'Guyana','id':'GY'},{'label':'Haiti','id':'HT'},{'label':'Heard Island and McDonald Islands','id':'HM'},{'label':'Holy See (Vatican City State)','id':'VA'},{'label':'Honduras','id':'HN'},{'label':'Hong Kong','id':'HK'},{'label':'Hungary','id':'HU'},{'label':'Iceland','id':'IS'},{'label':'India','id':'IN'},{'label':'Indonesia','id':'ID'},{'label':'Iran, Islamic Republic of','id':'IR'},{'label':'Iraq','id':'IQ'},{'label':'Ireland','id':'IE'},{'label':'Isle of Man','id':'IM'},{'label':'Israel','id':'IL'},{'label':'Italy','id':'IT'},{'label':'Jamaica','id':'JM'},{'label':'Japan','id':'JP'},{'label':'Jersey','id':'JE'},{'label':'Jordan','id':'JO'},{'label':'Kazakhstan','id':'KZ'},{'label':'Kenya','id':'KE'},{'label':'Kiribati','id':'KI'},{'label':'Korea, Democratic People\'s Republic of','id':'KP'},{'label':'Korea, Republic of','id':'KR'},{'label':'Kuwait','id':'KW'},{'label':'Kyrgyzstan','id':'KG'},{'label':'Lao People\'s Democratic Republic','id':'LA'},{'label':'Latvia','id':'LV'},{'label':'Lebanon','id':'LB'},{'label':'Lesotho','id':'LS'},{'label':'Liberia','id':'LR'},{'label':'Libya','id':'LY'},{'label':'Liechtenstein','id':'LI'},{'label':'Lithuania','id':'LT'},{'label':'Luxembourg','id':'LU'},{'label':'Macao','id':'MO'},{'label':'Macedonia, the Former Yugoslav Republic of','id':'MK'},{'label':'Madagascar','id':'MG'},{'label':'Malawi','id':'MW'},{'label':'Malaysia','id':'MY'},{'label':'Maldives','id':'MV'},{'label':'Mali','id':'ML'},{'label':'Malta','id':'MT'},{'label':'Marshall Islands','id':'MH'},{'label':'Martinique','id':'MQ'},{'label':'Mauritania','id':'MR'},{'label':'Mauritius','id':'MU'},{'label':'Mayotte','id':'YT'},{'label':'Mexico','id':'MX'},{'label':'Micronesia, Federated States of','id':'FM'},{'label':'Moldova, Republic of','id':'MD'},{'label':'Monaco','id':'MC'},{'label':'Mongolia','id':'MN'},{'label':'Montenegro','id':'ME'},{'label':'Montserrat','id':'MS'},{'label':'Morocco','id':'MA'},{'label':'Mozambique','id':'MZ'},{'label':'Myanmar','id':'MM'},{'label':'Namibia','id':'NA'},{'label':'Nauru','id':'NR'},{'label':'Nepal','id':'NP'},{'label':'Netherlands','id':'NL'},{'label':'New Caledonia','id':'NC'},{'label':'New Zealand','id':'NZ'},{'label':'Nicaragua','id':'NI'},{'label':'Niger','id':'NE'},{'label':'Nigeria','id':'NG'},{'label':'Niue','id':'NU'},{'label':'Norfolk Island','id':'NF'},{'label':'Northern Mariana Islands','id':'MP'},{'label':'Norway','id':'NO'},{'label':'Oman','id':'OM'},{'label':'Pakistan','id':'PK'},{'label':'Palau','id':'PW'},{'label':'Palestine, State of','id':'PS'},{'label':'Panama','id':'PA'},{'label':'Papua New Guinea','id':'PG'},{'label':'Paraguay','id':'PY'},{'label':'Peru','id':'PE'},{'label':'Philippines','id':'PH'},{'label':'Pitcairn','id':'PN'},{'label':'Poland','id':'PL'},{'label':'Portugal','id':'PT'},{'label':'Puerto Rico','id':'PR'},{'label':'Qatar','id':'QA'},{'label':'Réunion','id':'RE'},{'label':'Romania','id':'RO'},{'label':'Russian Federation','id':'RU'},{'label':'Rwanda','id':'RW'},{'label':'Saint Barthélemy','id':'BL'},{'label':'Saint Helena, Ascension and Tristan da Cunha','id':'SH'},{'label':'Saint Kitts and Nevis','id':'KN'},{'label':'Saint Lucia','id':'LC'},{'label':'Saint Martin (French part)','id':'MF'},{'label':'Saint Pierre and Miquelon','id':'PM'},{'label':'Saint Vincent and the Grenadines','id':'VC'},{'label':'Samoa','id':'WS'},{'label':'San Marino','id':'SM'},{'label':'Sao Tome and Principe','id':'ST'},{'label':'Saudi Arabia','id':'SA'},{'label':'Senegal','id':'SN'},{'label':'Serbia','id':'RS'},{'label':'Seychelles','id':'SC'},{'label':'Sierra Leone','id':'SL'},{'label':'Singapore','id':'SG'},{'label':'Sint Maarten (Dutch part)','id':'SX'},{'label':'Slovakia','id':'SK'},{'label':'Slovenia','id':'SI'},{'label':'Solomon Islands','id':'SB'},{'label':'Somalia','id':'SO'},{'label':'South Africa','id':'ZA'},{'label':'South Georgia and the South Sandwich Islands','id':'GS'},{'label':'South Sudan','id':'SS'},{'label':'Spain','id':'ES'},{'label':'Sri Lanka','id':'LK'},{'label':'Sudan','id':'SD'},{'label':'Suriname','id':'SR'},{'label':'Svalbard and Jan Mayen','id':'SJ'},{'label':'Swaziland','id':'SZ'},{'label':'Sweden','id':'SE'},{'label':'Switzerland','id':'CH'},{'label':'Syrian Arab Republic','id':'SY'},{'label':'Taiwan, Province of China','id':'TW'},{'label':'Tajikistan','id':'TJ'},{'label':'Tanzania, United Republic of','id':'TZ'},{'label':'Thailand','id':'TH'},{'label':'Timor-Leste','id':'TL'},{'label':'Togo','id':'TG'},{'label':'Tokelau','id':'TK'},{'label':'Tonga','id':'TO'},{'label':'Trinidad and Tobago','id':'TT'},{'label':'Tunisia','id':'TN'},{'label':'Turkey','id':'TR'},{'label':'Turkmenistan','id':'TM'},{'label':'Turks and Caicos Islands','id':'TC'},{'label':'Tuvalu','id':'TV'},{'label':'Uganda','id':'UG'},{'label':'Ukraine','id':'UA'},{'label':'United Arab Emirates','id':'AE'},{'label':'United Kingdom','id':'GB'},{'label':'United States','id':'US'},{'label':'United States Minor Outlying Islands','id':'UM'},{'label':'Uruguay','id':'UY'},{'label':'Uzbekistan','id':'UZ'},{'label':'Vanuatu','id':'VU'},{'label':'Venezuela, Bolivarian Republic of','id':'VE'},{'label':'Viet Nam','id':'VN'},{'label':'Virgin Islands, British','id':'VG'},{'label':'Virgin Islands, U.S.','id':'VI'},{'label':'Wallis and Futuna','id':'WF'},{'label':'Western Sahara','id':'EH'},{'label':'Yemen','id':'YE'},{'label':'Zambia','id':'ZM'},{'label':'Zimbabwe','id':'ZW'}]
Is a country list I use - Use JSON and your files could (stress could) become more useable as they then don’t just apply to PHP/dababase driven sites.
Having said that - lists of countries etc - inc. country flags etc are will ‘populated’ already over the web and most are free …