Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
180 views
in Technique[技术] by (71.8m points)

javascript - select value in dropdown dynamically change value in textbox

I am working on this form where it has drop down and text box. When value selected in one drop-down should change value in text-box dynamically.

for eg if I select a value "3" in select box then

select ename from emp where eid ='3';

and result should be in text box

Similarly form has multiple drop-down list with respective text-box.

Please suggest. Thanks in advance.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Try this one:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#empID').change(function(){
    $.get('getEmpInfo.php',{empId:$(this).val()},function(data){
    $('#emp_id').val(data);
 });
});
});
</script>
</head>

<body>
<select name="empID" id="empID">
    <option value="">Select Emp</option>
    <option value='1'>Emp1</option>
    <option value='2'>Emp2</option>
    <option value='3'>Emp3</option>
    <option value='4'>Emp4</option>
</select>
<input type="text" name="emp_id" id="emp_id" />
</body>
</html>

AT getEmpInfo.php PAge

<?php
if(isset($_REQUEST['empId'])){
  // connection should be on this page  
    $sql = mysql_query("select ename from emp where eid =".$_REQUEST['empId']);
    $res = mysql_fetch_assoc($sql);
    echo $res['ename'];die;
}
?>

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...