Jump to content

populating value from listbox to a textbox.


ashrafzia
 Share

Recommended Posts

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);
?>

Link to comment
Share on other sites

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???

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.