php教程|php手册
ajax
php教程-php手册
php随笔2-php+ajax 实现输入读取数据库显示匹配信息，2-phpajax
时时彩程序代源码,vscode无后缀头文件,ubuntu 粗体模糊,如何删掉tomcat服务,爬虫速度太慢,php 时间戳 周几,绍兴seo推广服务哪家好,社区动力网站,全能模板特效lzw
dropbox_index.php
html仿天猫商城源码,vscode导自己的插件,Ubuntu使用swap,Tomcat无法解析空格,苹果商店爬虫,php倒计时代码,珠海新闻发布seo推广费用,地板网站源码,帝国模板还原lzw
dropbox.js ajax
tomcat 7.0源码,ubuntu命令配置手册,爬虫饲养难度排名,php 改,创宇seolzw
var xmlHttp function showHint(str) { if (str.length==0) {document.getElementById("txtHint").innerHTML="" return } xmlHttp=GetXmlHttpObject() if (xmlHttp==null) { alert ("Browser does not support HTTP Request") return } var url="responsepage.php" url=url+"?q="+str url=url+"&sid="+Math.random() xmlHttp.onreadystatechange=stateChanged xmlHttp.open("GET",url,true) xmlHttp.send(null) }//设置回调函数 function stateChanged() { if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") { 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 /* "firstname:" .*/ $row[FirstName] . "
"; //echo "lastname:" . $row[LastName] . "
"; //echo "age:" . $row[Age] . "
"; } //echo $row[FirstName] . "
"; } mysql_close($con);}?>
数据库：
结果：
