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

最新推荐文章于 2021-04-21 18:14:49 发布

无约客

最新推荐文章于 2021-04-21 18:14:49 发布

阅读量464

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/u013282167/article/details/49558495

版权

PHP 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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 xmlHttp

function 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

收藏

觉得还不错? 一键收藏
0
评论
PHP+Mysql+AJAX无跳转刷新例子

html部分 Select a User: Peter Lois Glenn Joseph User info will be listed here. js部分var xmlHttpfunction showUser(str){ xmlH
复制链接

扫一扫