php 和ajax,PHP与Ajax

HTML代码

Select a User:

Peter Griffin

Lois Griffin

Glenn Quagmire

Joseph Swanson

Jason Qiao

User info will be listed here.

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代码

$q=$_GET["q"];

$con = mysql_connect('localhost', 'root', 'root');

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("ajax_demo", $con);

$sql="SELECT * FROM user WHERE id = '".$q."'";

$result = mysql_query($sql);

echo "

Firstname	Lastname	Age	Hometown	Job

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['Firstname'] . "";

echo "

" . $row['Lastname'] . "";

echo "

" . $row['Age'] . "";

echo "

" . $row['Hometown'] . "";

echo "

" . $row['Job'] . "";

echo "

";

}

echo "

";

mysql_close($con);

?>

SQL表

Paste_Image.png

注意：MySQL中数据表的每个字段名称是区分大小写的。如果你存的字段是FirstName，但你用Firstname去取数值，就会取不到值。