Hollen-B Designs, Web and Graphic Design Portfolio

Create states and countries

I found a few lists of states and countries but not really anything for setting up a database so I thought i would make my own.

| More

Share with friends and family

Open Connection and Create Database.

List of Countries.

$countries = "Afghanistan,Albania,Algeria,Andorra,Angola,Antigua & Deps,Argentina,Armenia,Australia,Austria,Azerbaijan,Bahamas,Bahrain,Bangladesh,Barbados,Belarus,Belgium,Belize,Benin,Bhutan,Bolivia,Bosnia Herzegovina,Botswana,Brazil,Brunei,Bulgaria,Burkina,Burundi,Cambodia,Cameroon,Canada,Cape Verde,Central African Rep,Chad,Chile,China,Colombia,Comoros,Congo,Congo {Democratic Rep},Costa Rica,Croatia,Cuba,Cyprus,Czech Republic,Denmark,Djibouti,Dominica,Dominican Republic,East Timor,Ecuador,Egypt,El Salvador,Equatorial Guinea,Eritrea,Estonia,Ethiopia,Fiji,Finland,France,Gabon,Gambia,Georgia,Germany,Ghana,Greece,Grenada,Guatemala,Guinea,Guinea-Bissau,Guyana,Haiti,Honduras,Hungary,Iceland,India,Indonesia,Iran,Iraq,Ireland {Republic},Israel,Italy,Ivory Coast,Jamaica,Japan,Jordan,Kazakhstan,Kenya,Kiribati,Korea North,Korea South,Kosovo,Kuwait,Kyrgyzstan,Laos,Latvia,Lebanon,Lesotho,Liberia,Libya,Liechtenstein,Lithuania,Luxembourg,Macedonia,Madagascar,Malawi,Malaysia,Maldives,Mali,Malta,Marshall Islands,Mauritania,Mauritius,Mexico,Micronesia,Moldova,Monaco,Mongolia,Montenegro,Morocco,Mozambique,Myanmar, {Burma},Namibia,Nauru,Nepal,Netherlands,New Zealand,Nicaragua,Niger,Nigeria,Norway,Oman,Pakistan,Palau,Panama,Papua New Guinea,Paraguay,Peru,Philippines,Poland,Portugal,Qatar,Romania,Russian Federation,Rwanda,St Kitts & Nevis,St Lucia,Saint Vincent & the Grenadines,Samoa,San Marino,Sao Tome & Principe,Saudi Arabia,Senegal,Serbia,Seychelles,Sierra Leone,Singapore,Slovakia,Slovenia,Solomon Islands,Somalia,South Africa,Spain,Sri Lanka,Sudan,Suriname,Swaziland,Sweden,Switzerland,Syria,Taiwan,Tajikistan,Tanzania,Thailand,Togo,Tonga,Trinidad & Tobago,Tunisia,Turkey,Turkmenistan,Tuvalu,Uganda,Ukraine,United Arab Emirates,United Kingdom,United States,Uruguay,Uzbekistan,Vanuatu,Vatican City,Venezuela,Vietnam,Yemen,Zambia,Zimbabwe";

List of states.

Insert and Display.

// OH NOEZ ITS BUSH!
$GWBush = explode(",", $countries);
$GWBush_state = explode(",", $states);
?>
<table width="500" border="0" cellpadding="0" cellspacing="0">
<?php
//Start from 1
$i = 1;
foreach($GWBush as $ce){

//Countries & States
$query = mysql_query("INSERT INTO que_countries VALUES('{$i}', '{$ce}' )");
?>
<tr>
<td width="59" align="right"><div style="padding:4px;"><?= $i ?>. )</div></td>
<td width="441" align="left"><div style="padding:4px;"><?= $ce ?>  <?php
if (!$query) {
echo '<span style="font-weight:bold; color:#FF0000;">( Failed )';
}
else {
echo '<span style="font-weight:bold; color:#00FF00;">( GTG! )';
}
?></span></div></td>
</tr>
<?php $i++;
}
?>
</table>
<table width="500" border="0" cellpadding="0" cellspacing="0">
<?php
// Start from 1
$i = 1;
foreach($GWBush_state as $ce){

// Countries & States
$query = mysql_query("INSERT INTO que_states VALUES('{$i}', '{$ce}' )");
?>
<tr>
<td width="59" align="right"><div style="padding:4px;"><?= $i ?>. )</div></td>
<td width="441" align="left"><div style="padding:4px;"><?= $ce ?>  <?php
if (!$query) {
echo '<span style="font-weight:bold; color:#FF0000;">( Failed )';
}
else {
echo '<span style="font-weight:bold; color:#00FF00;">( GTG! )';
}
?></span></div></td>
</tr>
<?php $i++;
}
?>
</table>

If you would like to add to this code to make it better feel free to contact me with what you would like to add.

States and Countries

Site Links

Blogs

Affiliates

Create states and countries

Open Connection and Create Database.

List of Countries.

List of states.

Insert and Display.

Contact