php如何处理ajax实例化数据库,PHP 和 AJAX MySQL 数据库实例 (总结)

js查询mysql数据库 中间件php

html中加载js代码， 用js打开php文件，调用php查询数据库的数据。(前台页面，可以将html和js放在一个文件里html内写具体js)

01.html

Select a User:

Peter Griffin

Lois Griffin

Glenn Quagmire

Joseph Swanson

User info will be listed here.

selectuser.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;

}

getuser.php

header("Content-type:text/html;charset=utf8");

$q=$_GET["q"];

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

if (!$con)

{

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

}

mysql_select_db("t2ecmall", $con);

mysql_query("set names utf8");

$sql="SELECT * FROM ecm_acategory ";

$result = mysql_query($sql);

echo "

Firstname	Lastname	Age	Hometown

//$row=mysql_fetch_array($result))!==false

//$row = mysql_fetch_array($result)

while($row=mysql_fetch_array($result))

{

echo "

";

echo "

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

echo "

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

echo "

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

echo "

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

echo "

";

}

echo "

";

mysql_close($con);

?>