废话不多说了,直接跟大家贴代码了
dropbox_index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://plete") { document.getElementById("txtHint").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; }dropbox.css
.txt{ height:22px; border:1px solid #cdcdcd; width:220px;border-right:none;}
.btn{ background-color:#FFF; border:1px solid #CDCDCD;height:26px; width:70px;}
responsepage.php
<?php //get the q parameter from URL $q=$_GET["q"]; //全部小写化 $q=strtolower($q); //非空验证 if(isset($q) && $q != '') { $con = mysql_connect("localhost","root","lifu"); if(!$con) { die('Could not connect: ' .mysql_error()); } mysql_select_db("my_db",$con); $sql = "select * from persons"; //$sql="SELECT FirstName FROM Persons where Firstname like '%$q%'"; $result =mysql_query($sql,$con); while($row = mysql_fetch_array($result)) { //匹配判断 if(stristr(strtolower($row['FirstName']),$q)) { //echo "-----------------Persons-----------------"; echo $row['FirstName'] . "<br />"; //echo "lastname:" . $row['LastName'] . "<br />"; //echo "age:" . $row['Age'] . "<br />"; } //echo $row['FirstName'] . "<br />"; } mysql_close($con); }?>数据库:
以上就是本文给大家介绍的php+ajax 实现输入读取数据库显示匹配信息的全部内容,希望大家喜欢。