實(shí)用的mysql ajax php 三級(jí)級(jí)聯(lián)下拉框

1、實(shí)用的mysql ajax php 三級(jí)級(jí)聯(lián)下拉框1,昨天弄了一個(gè)簡(jiǎn)單的三級(jí)級(jí)聯(lián)下拉框。超級(jí)實(shí)用。index.php：html head meta http-equiv=content-typecontent=text/html；charset=gb2312title ajax聯(lián)動(dòng)菜單/title script language=javascripttype=text/javascriptsrc=aa.js/script/head body form label select name=selid=selonchange=showmenu(this.value)；option一級(jí)分類/opti

2、on?php$conn=mysql_connect(localhost,root,)or die(could not connect：.mysql_error()；mysql_select_db(fitment,$conn)or die(cant use database：.mysql_error()；mysql_query(set namesgb2312)；$str=select*fromfitment_sortwhere supid=0order byidasc；$result=mysql_query($str)or die(invalid query：.mysql_error()；if(

3、$result)while($arr=mysql_fetch_array($result)echo eod option value=$arrid$arrname/option eod；mysql_close($conn)；?/select/label label select name=sel2id=sel2onchange=showmenu2(this.value)option二級(jí)分類/option/select/label label select name=sel3id=sel3option三級(jí)分類/option/select/label/form input type=button

4、value=send valueonclick=alert(document.getelementbyid(sel).optionsdocument.getelementbyid(sel).selectedindex.text+-+document.getelementbyid(sel2).optionsdocument.getelementbyid(sel2).selectedindex.text+-+document.getelementbyid(sel3).optionsdocument.getelementbyid(sel3).selectedindex.text)/body/html

5、 aa.js！-var xmlhttp var xmlhttp2/函數(shù)showmenu(str)-功能函數(shù)1 function showmenu(str)xmlhttp=getxmlhttpobject()/調(diào)用getxmlhttpobject()函數(shù)，創(chuàng)建xmlhttprequest對(duì)象if(xmlhttp=null)/如果創(chuàng)建失敗，則alert(browser does not support http request)returnvar url=get2.php/定義url,其主要讀取數(shù)據(jù)庫url=url+?q=+str url=url+&sid=+math.random()/math對(duì)

6、象的random方法，取隨機(jī)數(shù)xmlhttp.onreadystatechange=statechanged/設(shè)置當(dāng)xmlhttprequest對(duì)象xmlhttp狀態(tài)改變時(shí)調(diào)用的函數(shù),注意函數(shù)名后不要添加小括號(hào)xmlhttp.open(get,url,true)/使用xmlhttprequest對(duì)象的open()方法,創(chuàng)建http請(qǐng)求xmlhttp.send(null)/使用xmlhttprequest對(duì)象的open()方法,發(fā)送http請(qǐng)求/函數(shù)showmenu(str)-功能函數(shù)1 function showmenu2(str)xmlhttp2=getxmlhttpobject()/調(diào)用g

7、etxmlhttpobject()函數(shù)，創(chuàng)建xmlhttprequest對(duì)象if(xmlhttp2=null)/如果創(chuàng)建失敗，則alert(browser does not support http request)returnvar url=get2.php/定義url,其主要讀取數(shù)據(jù)庫url=url+?q2=+str url=url+&sid=+math.random()/math對(duì)象的random方法，取隨機(jī)數(shù)xmlhttp2.onreadystatechange=statechanged2/設(shè)置當(dāng)xmlhttprequest對(duì)象xmlhttp狀態(tài)改變時(shí)調(diào)用的函數(shù),注意函數(shù)名后不要添加小

8、括號(hào)xmlhttp2.open(get,url,true)/使用xmlhttprequest對(duì)象的open()方法,創(chuàng)建http請(qǐng)求xmlhttp2.send(null)/使用xmlhttprequest對(duì)象的open()方法,發(fā)送http請(qǐng)求/函數(shù)buildsel(),根據(jù)返回的的字串,重新構(gòu)建新的下拉菜單控件select-功能函數(shù)2 function buildsel(str,sel)/先清空原來的數(shù)據(jù).sel.options.length=0；/定義一個(gè)數(shù)組對(duì)象var arrstr=new array()；/以,號(hào)拆分傳入的字串，并存入數(shù)組arrstr=str.split(,)；if(s

9、tr.length 0)/循環(huán)for(var i=0；i arrstr.length；i+)var subarrstr=new array()；/以|拆分subarrstr=arrstri.split(|)；sel.options.add(new option(subarrstr1,subarrstr0)；sel.options0.selected=true；/函數(shù)statechanged()-響應(yīng)http請(qǐng)求狀態(tài)變化function statechanged()/判斷xmlhttprequest對(duì)象的readystate屬性值是否為4,如果為4表示異步調(diào)用完成(注意：異步調(diào)用完成不代表異步調(diào)

10、用成功)if(xmlhttp.readystate=4|xmlhttp.readystate=complete)/如果異步調(diào)用成功-xmlhttprequest對(duì)象的status屬性值為200,html文件在本地運(yùn)行,則xmlhttp.status的返回值為0,故應(yīng)該加上xmlhttp.status=0 if(xmlhttp.status=200|xmlhttp.status=0)/調(diào)用文檔對(duì)象模型dom的getelementbyid()方法查找html文件中的標(biāo)簽txthint,/innerhtml為ie瀏覽器中的屬性,可以用來更改標(biāo)簽間文本的內(nèi)容,/xmlhttp.responsetext

11、,通過xmlhttprequest的responsetext屬性來獲取數(shù)據(jù)responsetext,結(jié)果為字符串；responsexml,結(jié)果為xml形式/document.getelementbyid(txthint).innerhtml=xmlhttp.responsetext buildsel(xmlhttp.responsetext,document.getelementsbytagname(*).sel2)showmenu2(document.getelementsbytagname(*).sel2.value)；/函數(shù)statechanged()-響應(yīng)http請(qǐng)求狀態(tài)變化funct

12、ion statechanged2()/判斷xmlhttprequest對(duì)象的readystate屬性值是否為4,如果為4表示異步調(diào)用完成(注意：異步調(diào)用完成不代表異步調(diào)用成功)if(xmlhttp2.readystate=4|xmlhttp2.readystate=complete)/如果異步調(diào)用成功-xmlhttprequest對(duì)象的status屬性值為200,html文件在本地運(yùn)行,則xmlhttp.status的返回值為0,故應(yīng)該加上xmlhttp.status=0 if(xmlhttp2.status=200|xmlhttp2.status=0)/調(diào)用文檔對(duì)象模型dom的getele

13、mentbyid()方法查找html文件中的標(biāo)簽txthint,/innerhtml為ie瀏覽器中的屬性,可以用來更改標(biāo)簽間文本的內(nèi)容,/xmlhttp.responsetext,通過xmlhttprequest的responsetext屬性來獲取數(shù)據(jù)responsetext,結(jié)果為字符串；responsexml,結(jié)果為xml形式/document.getelementbyid(txthint).innerhtml=xmlhttp.responsetext buildsel(xmlhttp2.responsetext,document.getelementsbytagname(*).sel3)

14、/函數(shù)getxmlhttpobject()-創(chuàng)建xmlhttprequest對(duì)象,即創(chuàng)建一個(gè)異步調(diào)用對(duì)象function getxmlhttpobject()var xmlhttp=null；try/firefox,opera 8.0+,safari xmlhttp=new xmlhttprequest()；catch(e)/internet explorer tryxmlhttp=new activexobject(msxml2.xmlhttp)；catch(e)xmlhttp=new activexobject(microsoft.xmlhttp)；return xmlhttp；-get2

15、.php?php/指定編碼header(content-type：text/html；charset=gb2312)；/連接、選擇數(shù)據(jù)庫,設(shè)置字符集$conn=mysql_connect(localhost,root,)or die(could not connect：.mysql_error()；mysql_select_db(fitment,$conn)or die(cant use database：.mysql_error()；mysql_query(set namesgb2312)；/如果傳遞過來q if($_getq)$strs=select*from fitment_sort w

16、here supid=.$_getq.；/echo$str；$results=mysql_query($strs)or die(invalid query：.mysql_error()；if($results)while($arrs=mysql_fetch_array($results)$strings.=$arrsid.|.$arrsname.,；echo substr($strings,0,strlen($strings)-1)；/如果傳遞過來q2 if($_getq2)$str=select*from fitment_sort where supid=.$_getq2.；/echo$str；$result=m