PHP ?? ?? ???? AJAX ? MySQL
AJAX ?????? ????
AJAX? ???? ?? ??????
? ????? ??? ? ????. ? ?? ? ???? AJAX? ?? ???????? ??? ?? ??? ?????.
?? ???? ???? ??? ??????.
? ?? ? ?? ??? ?????.
MySQL ??????
??? HTML ??
JavaScript
PHP ???
??????
? ???? ?? ??? ???? ???? ???. ??????:
HTML ?? ? JavaScript
?? ?? 1? ?????. php
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script>
function showUser(str){
var xmlhttp;
//檢查是否有用戶被選擇
if(str==""){
document.getElementById("txt").innerHTML="";
return;
}
//創(chuàng)建 XMLHttpRequest 對(duì)象
if(window.XMLHttpRequest){
// IE7+, Firefox, Chrome, Opera, Safari 瀏覽器執(zhí)行代碼
xmlhttp=new XMLHttpRequest();
}
else{
//IE6,IE5瀏覽器執(zhí)行代碼
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}
//創(chuàng)建在服務(wù)器響應(yīng)就緒時(shí)執(zhí)行的函數(shù)
xmlhttp.onreadystatechange=function(){
if(xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById("txt").innerHTML=xmlhttp.responseText;
}
}
//向服務(wù)器上的文件發(fā)送請(qǐng)求
xmlhttp.open("GET","2.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body>
<from>
<!-- onchange 事件會(huì)在域的內(nèi)容改變時(shí)觸發(fā)
當(dāng)用戶在上面的下拉列表中選擇某位用戶時(shí)，會(huì)執(zhí)行名為 "showUser()" 的函數(shù)
-->
<select name="users" onchange="showUser(this.value)">
<option value="">選擇一個(gè)人：</option>
<option value="1">Peter Griffin</option>
<option value="2">小 明</option>
<option value="3">小 白</option>
</select>
</from>
<br/>
<br/>
<div id="txt"><b>選擇相應(yīng)用戶，用戶信息將在這里展示出來(lái)</b></div>
</body>
</html>???? ??
???? ???? ??? ?? ??? ? onchange ???? ?? showUser() ??? ?????
showUser() ??? ?? ??? ?????:
???? ?????? ??
XMLHttpRequest ?? ??
?? ??? ????? ? ??? ??? ??
??? ??? ?? ???
-
URL(???? ??? ?? ??) ?? ??? ????(q)? ?????
PHP ???
?? JavaScript? ?? ???? ?? ???? "2.php"?? ??? PHP ?????.
"2.php"? ?? ??? MySQL ??????? ?? ??? ???? ??? HTML ???? ?????.
<?php
header("Content-type: text/html; charset=utf-8");
$q=$_GET["q"];
//連接數(shù)據(jù)庫(kù)
$con = mysqli_connect('localhost','root','root','test');
//判斷是否連接成功
if(!$con){
die('連接數(shù)據(jù)庫(kù)失敗：'.mysqli_error($con));
}
//選擇數(shù)據(jù)庫(kù)
mysqli_select_db($con,"test");
//設(shè)定字符集
mysqli_query($con,'set names utf8');
//從數(shù)據(jù)庫(kù)中查出id對(duì)應(yīng)的相應(yīng)用戶信息
$sql="SELECT * FROM customer WHERE id='".$q."'";
$result=mysqli_query($con,$sql);
echo "<table border='1' cellspacing='0' cellpadding='0'>
<tr>
<th>姓</th>
<th>名</th>
<th>年齡</th>
<th>家鄉(xiāng)</th>
<th>工作</th>
</tr>
";
//循環(huán)顯示出用信息
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td>".$row['FirstName']."</td>";
echo "<td>".$row['LastName']."</td>";
echo "<td>".$row['Age']."</td>";
echo "<td>".$row['Hometown']."</td>";
echo "<td>".$row['Job']."</td>";
echo "</tr>";
}
echo "</table>";
?>?? ??
? ??? ?? ?? ?? ??? ?????.
?? ?? ??: ???? ??
onchange ??? : ???? ??? ????? ? ??
?? ??, ?? ? ??
AJAX XMLHttpRequest ?? ??, ? ??? ??? ?? ??, ??? ??? ?? ??: ?? ??? 1-5 ??
HTML DOM getElementById() ???: ??? ? ?? ??? ?? ??? ?????. ID
?????? ??, ?????? ??, ?????? ??, ??? ??, ID? ?? ?????? ??, ?????? ?? ????
?????? ?? ??:
mysqli_connect(): MySQL ??? ?? ? ?? ??
mysqli_error(): Return to ?? MySQL ???? ?? ??? ??? ?? ??????.
mysqli_select_db(): ??? ?? ?? ??????? ???? ? ?????.
mysqli_query(): ??????? ?? ??? ?????.
mysqli_fetch_array(): ?? ???? ?? ??, ?? ?? ?? ? ?? ?? ?????.
