无刷新三级联动菜单从数据库获取数据(适用于fir

< script language ="javascript" src ="include/selectoption.js" ></ script >

< select name ="privceid" id ="privceid" onchange ="editnextselect(this,'cityid');" >
< option value ="-1" > 请选择 </ option >
</ select > 省
< select name ="cityid" id ="cityid" onchange ="editnextselect(this,'county');" >
< option value ="-1" > 请选择 </ option >
</ select > 市
< select name ="county" id ="county" >
< option value ="-1" > 请选择 </ option >
</ select > 区/县

< script language ="javascript" > ...
var privceid = " <%=privceid%> " ;
var cityid = " <%=cityid%> " ;
var county = " <%=county%> " ;
getdatelist( ' &pid= ' ,privceid, ' privceid ' );
if (cityid != "" ) ... {getdatelist( ' &pid= ' + privceid,cityid, ' cityid ' );}
if (county != "" ) ... {getdatelist( ' &pid= ' + cityid,county, ' county ' );}
function editnextselect(obj,nexselid) ... {
if (nexselid == ' cityid ' ) ... {
selvalue = cityid;
} else ... {
selvalue = county;
}
var pid = obj.options[obj.selectedIndex].value;
if (pid != null ) ... {
getdatelist( ' &pid= ' + pid,selvalue,nexselid);
}
}
</ script >

// JavaScriptDocument
function InitAjax() ... {
var ajax = false ;
try ... {ajax = new ActiveXObject( " Msxml2.XMLHTTP " );}
catch (e) ... {
try ... {ajax = new ActiveXObject( " Microsoft.XMLHTTP " );}
catch (E) ... {ajax = false ;}
}
if ( ! ajax && typeof XMLHttpRequest != ' undefined ' ) ... {ajax = new XMLHttpRequest();}
return ajax;
}
function datexml(url,value) ... {
var number = Math.random();
var url = url + " ?qaaq= " + number + value;
var ajax = InitAjax();
　ajax.open( " GET " ,url, false );
　ajax.send( null );
// ajax.onreadystatechange=function(){}
if (ajax.readyState == 4 && ajax.status == 200 ) ... { return ajax.responseText;}
}
function getdatelist(values,selvalues,SelectName) ... {
var getdate = datexml( " include/xmlgetp_c_c.asp " ,values);
if (getdate) ... {
if (getdate != " wrong " && getdate != " no " ) ... {
var objSelect = document.getElementById(SelectName);
objSelect.options.length = 1 ;
var datearray = getdate.split( " $ " );
for (i = 0 ;i < datearray.length - 1 ;i ++ ) ... {
var op = window.document.createElement( " option " );
op.value = datearray[i].split( " | " )[ 0 ];
op.innerHTML = unescape(datearray[i].split( " | " )[ 1 ]);
objSelect.appendChild(op);
}
if (selvalues != "" ) ... {
for (i = 0 ;i < objSelect.options.length;i ++ ) ... {
if (objSelect.options[i].value == selvalues) ... {
objSelect.options[i].selected = true ;
break ;
}
}
}
}
}
}

< ! -- #includefile = " dbconn.asp " -->
< %
pid = request.querystring( " pid " )
if pid <> "" then
if isnumeric (pid) = false then
response.write " wrong "
end if
end if
if pid = "" then
sql = " selectzipcode,zipnamefromZIPCODEINFOwhereparentzipisnull "
else
sql = " selectzipcode,zipnamefromzipcodeinfowhereparentzip=' " & pid & " ' "
end if
call dbopen
set rs = conn.execute(sql)
if not rs.eof then
do while not rs.eof
response.writers( " zipcode " ) & " | " & escape(rs( " zipname " )) & " $ "
rs.movenext
loop
else
response.write " no "
end if
set rs = nothing
call dbclose
% >