ajax链接数据库实例

<!DOCTYPE html>  
<html>  
<head>  
<meta charset="utf-8">  
<script>  
function showCustomer(str){  
  var xmlhttp;      
  if (str==""){  
    document.getElementById("txtHint").innerHTML="";  
    return;  
  }  
  if (window.XMLHttpRequest){  
    // IE7+, Firefox, Chrome, Opera, Safari 浏览器执行代码  
    xmlhttp=new XMLHttpRequest();  
  }  
  else{  
    // IE6, IE5 浏览器执行代码  
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");  
  }  
  xmlhttp.onreadystatechange=function(){  
    if (xmlhttp.readyState==4 && xmlhttp.status==200){  
      document.getElementById("txtHint").innerHTML=xmlhttp.responseText;  
    }  
  }  
  xmlhttp.open("GET","/try/ajax/getcustomer.php?q="+str,true);  
  xmlhttp.send();  
}  
</script>  
</head>  
<body>  
  
<form action="">   
<select name="customers" onchange="showCustomer(this.value)" style="font-family:Verdana, Arial, Helvetica, sans-serif;">  
<option value="APPLE">Apple Computer, Inc.</option>  
<option value="BAIDU ">BAIDU, Inc</option>  
<option value="Canon">Canon USA, Inc.</option>  
<option value="Google">Google, Inc.</option>  
<option value="Nokia">Nokia Corporation</option>  
<option value="SONY">Sony Corporation of America</option>  
</select>  
</form>  
<br>  
<div id="txtHint">客户信息将显示在这...</div>  
  
</body>  
</html>

//php文件

<%  
response.expires=-1  
sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="  
sql=sql & "'" & request.querystring("q") & "'"  
  
set conn=Server.CreateObject("ADODB.Connection")  
conn.Provider="Microsoft.Jet.OLEDB.4.0"  
conn.Open(Server.Mappath("/db/northwind.mdb"))  
set rs=Server.CreateObject("ADODB.recordset")  
rs.Open sql,conn  
  
response.write("<table>")  
do until rs.EOF  
  for each x in rs.Fields  
    response.write("<tr><td><b>" & x.name & "</b></td>")  
    response.write("<td>" & x.value & "</td></tr>")  
  next  
  rs.MoveNext  
loop  
response.write("</table>")  
%>

欢迎分享本文,转载请保留出处:前端ABC » ajax链接数据库实例

赞 (2)
分享到:更多 ()

发表评论 0