PHP;"> Box.css" type="text/css" rel="stylesheet"/>

Box">

PHP;"> 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; }

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);

$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a> = "select * from persons";
//$<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>="SELECT FirstName FROM Persons where Firstname like '%$q%'";

$result =<a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>_query($<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>,$con);
while($row = <a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>_fetch_array($result))
 {
   //匹配判断
   if(stristr(strtolower($row['FirstName']),$q))
   {
     //echo "-----------------Persons-----------------";
     echo /* "firstname:" .*/ $row['FirstName'] . "<br />";
     //echo "lastname:" . $row['LastName'] . "<br />";
     //echo "age:" . $row['Age'] . "<br />";
   }
   //echo $row['FirstName'] . "<br />";
 }
<a href="https://www.jb51.cc/tag/MysqL/" target="_blank" class="keywords">MysqL</a>_close($con);

}
?>