PHP+Mysql+AJAX无跳转刷新例子

来源：互联网发布：判断素数c语言 9是素数编辑：程序博客网时间：2024/06/01 09:33

html部分<html><head><script src="selectuser.js"></script></head><body><form>Select a User:<select name = "users" onchange = "showUser(this.value)"><option value = "1"> Peter </option><option value = "2"> Lois </option><option value = "3"> Glenn </option><option value = "4"> Joseph </option></select></form><p><div id = "txtHint"><b>User info will be listed here.</b></div></p></body></html>

js部分

var xmlHttpfunction showUser(str){ xmlHttp=GetXmlHttpObject()if (xmlHttp==null) { alert ("Browser does not support HTTP Request"); return; }var url="getuser.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$q = $_GET["q"];$con = mysql_connect("localhost","root");mysql_select_db("my_db",$con);$sql = "SELECT * FROM users WHERE id = '".$q."'";$result = mysql_query($sql);echo "<table border = '1'><tr><th>UserName</th><th>PassWord</th></tr>";while($row = mysql_fetch_array($result)){echo "<tr>";echo "<td>" . $row['UserName'] . "</td>";echo "<td>" . $row['PassWord'] . "</td>";echo "</tr>";}echo "</table>";mysql_close($con);?>

0 0