PHP - AJAX ? MySQL
AJAX? ???? ??????? ????? ??? ? ????.
AJAX ?????? ????
?? ???? ? ???? AJAX? ?? ???????? ??? ?? ??:
html ??? ??
?? ?? - MySQL ??????
? ??? ??? ???? ?????? ???? ??? ????.
?? ?? - HTML ???
? ???? ???? ???? ???? ???? "showUser()"?? ??? ?????. ? ??? "onchange" ???? ?? ??????.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script>
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{
// IE7+, Firefox, Chrome, Opera, Safari 瀏覽器執(zhí)行代碼
xmlhttp=new XMLHttpRequest();
}
else
{
// IE6, IE5 瀏覽器執(zhí)行代碼
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body>
<form>
<select name="users" onchange="showUser(this.value)">
<option value="">Select a person:</option>
<option value="1">John Doe</option>
<option value="2">tom Mary</option>
<option value="3">lijing liuqi</option>
<option value="4">liu li</option>
</select>
</form>
<br>
<div id="txtHint"><b>數(shù)據(jù)庫信息展示在這</b></div>
</body>
</html>showUser() ??? ?? ??? ?????.
· ???? ?????? ??
· XMLHttpRequest ??
· ?? ??? ????? ? ???? ?? ???
· ??? ??? ?? ???
· ????(q)? ?????. URL ?? ???(???? ?? ??? ??)
PHP ??
??? ??? ?? ??? JavaScript? ?? "database"?? PHP ??? ?????.
database.php"? ?? ??? MySQL ??????? ?? ??? ???? ??? HTML ???? ?????.
database.php ??
<?php
$q=$_GET["q"];
$con = mysqli_connect('localhost','root','root','test');
if (!$con)
{
die('Could not connect: ' . mysqli_error($con));
}
//mysqli_select_db($con,"ajax_demo");
$sql="SELECT * FROM Myguests WHERE id = '".$q."'";
$result = mysqli_query($con,$sql);
echo "<table border='1'>
<tr>
<th>firstname</th>
<th>lastname</th>
<th>email</th>
<th>Age</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td>" . $row['Age'] . "</td>";
;
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>??: JavaScript?? PHP ??? ??? ???? ??? ?? ?? ?????.
1. PHP? MySQL ??????? ?? ??? ???.
2 . ??? ???? ?????
3. HTML ??? ???, ???? ????, "txtHint" ?? ???? ?? ????.
???? ?? ??:
