Tuesday, May 21, 2013

Simple Selection Combo box MYSQL database and PHP


combobox.php

<?php
include_once('db.php');
?>

<div  style="width:50px;height: auto; float: left; "> States:</div>
<div align="left" style="width:210px;height: auto; float: left; ">
<select name="states" onChange="getCities(this.value)">
<?php
$result = mysql_query("SELECT * FROM states");
while($row=mysql_fetch_array($result))
{
echo "<option value=".$row[id].">$row[states]</option>";
}
?>
</select>
</div>

database :  
table name : states  

table id :   id
table Name : states 

states
----------------------------
id   | states 
1   | Andra
2   | Tamil Nadu
3   |  Pondicherry 

db.php

<?php
$mysql_hostname = "localhost";
$mysql_user = "test";
$mysql_password = "BJx3p2awbuTvdVwS";
$mysql_database = "test";
$prefix = "";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
?>


No comments: