Importing data into combo box

[mainul]

Hi,
i have a mysql database 'country_list' which consist of two entity- one is country_code another is country_name.now i need to import all the country_code into a combo box and when a user will select a country code the respective country name will be displayed into a text box. how can i do that?

waiting for ur reply.

thanks
Mainul

[ctsasikumar]

Hai Using ajax concept

[PHP]
file name:country_code.php
<?
$connect=mysql_connect("localhost","root","");
$select_db=mysql_select_db("country",$connect);
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
var req
function gettest(key)
{
//alert(key);
req = GetXmlHttpObject();
req.open('POST','getdatbase.php', false);
req.setRequestHeader('Content-type', 'application/x-www-form-urlencoded;charset=UTF-8;');
//req.onreadystatechange=stateChanged
req.send('ids='+key);
if(req.status == 200)
document.getElementById("rr").value=req.responseTe xt;
// document.getElementById("r").innerHTML=req.respons eText;
}
function stateChanged()
{
/*if (req.readyState==0)
{
//alert("loding");
document.getElementById('content').innerHTML=""
}
else if (req.readyState==1)
{
//alert("loding");
document.getElementById('content').innerHTML="LOAD ING"
}
else if (req.readyState==4)
{
//alert("loding");
document.getElementById('content').innerHTML="comp leted"
}*/
}
function GetXmlHttpObject()
{
var objXMLHttp=null
if (window.XMLHttpRequest)
{
objXMLHttp=new XMLHttpRequest()
}
else if (window.ActiveXObject)
{
objXMLHttp=new ActiveXObject("Microsoft.XMLHTTP")
}
return objXMLHttp
}
//-->
</SCRIPT>

<table align=center width=80% border=1>
<form name=test method=post action="">
<tr><td>Select Country name</td><td><select name="country" onChange="gettest(this.value)">
<?
$select_value="Select * from coun";
$exexute_quey=mysql_query($select_value);
$num_rows=mysql_num_rows($exexute_quey);
for($i=0;$i<$num_rows;$i++)
{
$getdata=mysql_fetch_array($exexute_quey);
$country_code=$getdata['cid'];
$country_name=$getdata['cname'];
?>
<option value=<?=$country_code?>><?=$country_name?></option>
<?
}
?>
</select>
</td></tr>
<tr><td>Country name</td><td><input type=text id="rr" ></tr>
<tr><td><span id="r"></span></td></tr>
<tr><td colspan=1><input type=submit name=sub value=submit></td>
</form>
</table>


filename:getdatbase.php
<?
$connect=mysql_connect("localhost","root","");
$select_db=mysql_select_db("country",$connect);
$couid=$_REQUEST['ids'];
$select_value="Select * from coun where cid=$couid";
$exexute_quey=mysql_query($select_value);
$getdata=mysql_fetch_array($exexute_quey);
echo $countryname=$getdata['cname'];
?>
[/PHP]

[ronverdonk]

This looks like a simple problem with a simple solution. I believe Ajax is useful, but not a cure for all ailments and certainly not in this case.

There is (a) a 1-1 relation between the country code and the country name and (b) you display all the country codes already in the box, so there is no need for any fancy and heavy solution. You can use a simple dropdown box that holds all data.

Make one drop down select box with the country name as the value and the country code as the text part of the option. As follows:

<option value='country_name'>country_code</option>

The user selects the country code presented to him/her and the value of the selected box (i.e. country_name) is passed to you and you can display it onto the screen.

Ronald :cool:

[mainul]

hello guys thank you for your solutions