populating value from listbox to a textbox.

[ashrafzia]

Hi there!

 

I want to display(select) a no from database in a textbox when the username is selected in the listbox.

Problem is I can't get the person number.

Here's the code:

{javascript part}

var xmlHttp;

function showUser(str)
{ 
xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var url="names.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);
}

function stateChanged() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{ 
document.getElementById("p_no").innerHTML=xmlHttp.responseText;
} 
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
  {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
catch (e)
  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
}
return xmlHttp;
}

 

names.php

<?php
include("../connection.php");
$q=$_GET["q"];
$sql="SELECT p_no FROM resumes WHERE user_id = '".$q."'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo "$row['p_no']";
mysql_close($con);
?>

[priti]

document.getElementById("p_no").innerHTML=xmlHttp.responseText;

 

can be changed to

 

document.getElementById("p_no").value=xmlHttp.responseText; "if p_no is input text box"

 

you can check if you are receiving p_no from server by alert(xmlHttp.responseText)

 

Are you able to receive the response???

[suma237]

check the url using alert statment