無刷新三級聯(lián)動菜單從數(shù)據(jù)庫獲取數(shù)據(jù)(適用于fir
系統(tǒng)
2107 0
表單葉面
<
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
>
區(qū)/縣
<
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
>
js包含葉面
//
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
;
}
}
}
}
}
}
讀取數(shù)據(jù)庫葉面
<
!
--
#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
%
>
無刷新三級聯(lián)動菜單從數(shù)據(jù)庫獲取數(shù)據(jù)(適用于firefox和ie)
更多文章、技術交流、商務合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元