从查询sql数据库获取数据到javascript

在javascript中，您必须

ajax call

var xmlhttp;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)    {    document.getElementById("send2").innerHTML=xmlhttp.responseText;    }  }xmlhttp.open("GET","yourFile.php",true);xmlhttp.send();

并且在您的php文件中，您必须以

echo

echo json_enpre(array('id'=>$id,'name'=>$name));

*在您的情况下， *UPDATe 使用以下代码：（未测试）

php代码：

<?php    $query = mysql_query("select * from data where id_user = '$id_user' order by date asc");    $i = 0;    $options = array();    while($data = mysql_fetch_array($query)){       $options[$data['id']] =  $data['name'];    }    echo json_enpre($options);?>

Javascript代码：

var xmlhttp;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 response = JSON.parse(xmlhttp.responseText);      var select = '<select >';      for( var index in response ){          select = select + "<option value='"+ index +"'>"+response[index]+"</option>";      }      select += "</select>";      document.getElementById("send2").innerHTML= select;  }}function changeSend() {   var selectBox = document.getElementById("sender");   var selectedValue = selectBox.options[selectBox.selectedIndex].value;   if (selectedValue==0) {       xmlhttp.open("GET","yourFile.php",true);       xmlhttp.send();   }    else {      $('#send2').html('');   }}

使用jQuery

Javascript代码：

function changeSend() {   var selectBox = document.getElementById("sender");   var selectedValue = selectBox.options[selectBox.selectedIndex].value;   if (selectedValue==0) {       $.get("yourFile.php", function(data){var response = JSON.parse(data);var select = '<select >';for( var index in response ){    select = select + "<option value='"+ index +"'>"+response[index]+"</option>";}select += "</select>";$("#send2").html(select);       });   }    else {      $('#send2').html('');   }}