确定我使用的解决方案，对于任何想知道我如何解决的人
我的index.php，其中包含javascript和表单代码
Javascript代码
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js" type="text/javascript"></script><script>function showUser(str){if (str==""){ document.getElementById("company_name").value=""; return;}if (window.XMLHttpRequest){// pre for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest();}else{// pre for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}xmlhttp.onreadystatechange=function(){ if (xmlhttp.readyState==4 && xmlhttp.status==200) { var data = JSON.parse(xmlhttp.responseText); for(var i=0;i<data.length;i++) { document.getElementById("company_name").value = data[i].name; document.getElementById("company_email").value = data[i].web; } }}xmlhttp.open("GET","formdata.php?q="+str,true);xmlhttp.send();}</script>和表单代码
<select id="company_select" name="company_select" title="Company Select" onChange="showUser(this.value)"><option value="">Please select</option><?php$userID = $user->getUserID();$query = $user->database->query("SELECT * FROM tbl_businesses as business LEFT JOIN tbl_user_businesses as biz_user ON business.businessID = biz_user.businessID WHERe biz_user.userID ='$userID'");while($row=$user->database->fetchArray($query)){ $bizID = $row['businessID']; $bizName = $row['businessName']; echo "<option value='$bizID'>$bizName</option>";}?></select><input id="company_name" type="text" name="company_name" value="" /><input id="company_email" type="text" name="company_name" value="" />然后我的formdata.php
$q = intval($_GET['q']);$sql="SELECT * FROM tbl_businesses WHERe businessID = '".$q."'";$result = $user->database->query($sql);$info = array();while($row=$user->database->fetchArray($result)){ $cID = $row['businessID']; $cName = $row['businessName']; $cWeb = $row['businessWebsite']; $info[] = array( 'id' => $cID, 'name' => $cName, 'web' => $cWeb );}echo json_enpre($info);?>就是这样，感谢charlietfl的帮助！
希望这可以帮助某人:)
