1. 用POST發(fā)送數(shù)據(jù),在2號(hào)線函數(shù)(也是ajax發(fā)送數(shù)據(jù)的函數(shù):ajaxCall)必須加上一句:xmlObject.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
2.使用XML數(shù)據(jù)格式必須加上:header("Content-Type: text/xml; charset=gb2312");//這里要寫(xiě)XML
mysql_query("SET character_set_connection=$charset, character_set_results=$charset, character_set_client=binary"); //這句是必須的,解決中文亂碼加密問(wèn)題s
否則就會(huì)亂碼加密,今天我就是在這里浪費(fèi)了很久時(shí)間,我是用ECSHOP GBK版 默認(rèn)安裝的數(shù)據(jù)庫(kù)
function getXMLData(tagName)//獲取XML數(shù)據(jù),分IE和非IE處理
{
var info;
if(window.ActiveXObject) //IE取回XML文件方法
{
var doc = new ActiveXObject("MSxml2.DOMDocument");
doc.loadXML(xmlObject.responseText);
info = doc.getElementsByTagName(tagName);
}
else //---------------------------非IE取回XML文件方法
{
info = xmlObject.responseXML.getElementsByTagName(tagName);
}
return info;
}
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
html xmlns="http://www.w3.org/1999/xhtml">
head>
meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
title>省事聯(lián)動(dòng)測(cè)試/title>
style type="text/css" >
select{
width:100px;
}
/style>
script type="text/javascript" >
var thisId = ""; //當(dāng)前操作的selectI的D
var xmlObject; //ajax 對(duì)象全局變量,
function getAjaxObject()//AJAX 1號(hào)線,返回一個(gè)AJAX 對(duì)象引擎
{
var xmlObject ;
if(window.ActiveXObject)
{
xmlObject = new ActiveXObject("Microsoft.XMLHTTP");
}
else
{
xmlObject = new XMLHttpRequest();
}
return xmlObject ;
}
function ajaxCall(id) //ajax 二號(hào)線 ,這里采用 post 傳遞參數(shù)
{
xmlObject = new getAjaxObject();
if(xmlObject)
{
var url = "chuli.php";
var data = "id=" + id;
xmlObject.open("post",url,true);
xmlObject.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xmlObject.onreadystatechange = repayFuncion;
xmlObject.send(data);
}
}
function repayFuncion() //ajax 四號(hào)線 ,這里采用 xml 接受數(shù)據(jù),這里還涉及到xmldom編程
{
if(xmlObject.readyState==4 xmlObject.status==200)
{
var info = getXMLData("res");//獲取XML數(shù)據(jù)
$(thisId).length = 0;//清楚select 中的option節(jié)點(diǎn)
for(i=0;iinfo.length;i++)
{
var optionId = info[i].childNodes[0].childNodes[0].nodeValue;
var optionValue = info[i].childNodes[1].childNodes[0].nodeValue;
var optionNode = document.createElement('option');
optionNode.value = optionId;
optionNode.innerText =optionValue;
$(thisId).appendChild(optionNode);
}
}
}
function getXMLData(tagName)//獲取XML數(shù)據(jù),分IE和非IE處理
{
var info;
if(window.ActiveXObject) //IE取回XML文件方法
{
var doc = new ActiveXObject("MSxml2.DOMDocument");
doc.loadXML(xmlObject.responseText);
info = doc.getElementsByTagName(tagName);
}
else //---------------------------非IE取回XML文件方法
{
info = xmlObject.responseXML.getElementsByTagName(tagName);
}
return info;
}
function $(id)//常用函數(shù),通過(guò)ID取對(duì)象
{
return document.getElementById(id);
}
function getProvice()//獲取省
{
thisId = "Province";
var id = '1';
ajaxCall(id);
}
function getCity()//獲取市
{
thisId = "City";
$("County").length = 0;
var id = $("Province").value;
ajaxCall(id);
}
function getCounty()//獲取縣城
{
thisId = "County";
var id = $("City").value;
if($("City").length)
{
ajaxCall(id);
}
}
window.onlaod = getProvice();//頁(yè)面開(kāi)始載入省
/script>
/head>
body>
form action="javascript:void(0)" method="post">
label for="username" >用戶名:/label> input type="text" name="username" id="username" width="60px" />br />
label for="psd" >密 nbsp;碼:/label> input type="password" name="psd" id="psd" width="80px" />/br>
label for="psd" >地 nbsp;址:/label>
select id="Province" onclick="getCity()">
/select>nbsp;
select id="City" onclick="getCounty()" >
/select>nbsp;
select id="County" name="xian" >
/select>
input type="submit" value="提交" />
/form>
/body>
/html>
?php
//3號(hào)線
header("Cache-Control:no-cache");
header("Content-Type: text/xml; charset=gb2312");//這里要寫(xiě)XML
require("function.php");
$id = $_POST['id'];
file_put_contents("my1.txt",$act . "------" . $ziduan);
$result = getresultById($id);
$info = "mes>";
foreach($result as $row)
{
$info .= "res>";
$info .= "id>" . $row['region_id'] . "/id>";
$info .= "name>" . $row['region_name'] . "/name>";
$info .= "/res>";
}
$info .= "/mes>";
echo $info;
?>
?php
function getresultById($id)
{
$con = mysql_connect("localhost","root","");
if($con)
{
$charset = "gb2312";
mysql_query("SET character_set_connection=$charset, character_set_results=$charset, character_set_client=binary"); //這句是必須的,解決中文亂碼加密問(wèn)題s
mysql_select_db("ajax",$con);
$sql = "select * from ecs_region where parent_id = '$id'";
$res = mysql_query($sql);
$arr = array();
while($row = mysql_fetch_assoc($res))
{
$arr[] = $row;
}
return $arr;
}
return false;
}