❶ thinkphp如何實現二級聯動下拉選擇框
可以用ajax實現。
資料庫用無限級分類。比如：
省，市聯動
資料庫欄位 id pid name
插入數據 1 0 山西
2 1 運城 3，1 呂梁
第一個下拉框，所有pid為0的數據全遍歷出來。比如選擇 山西。第二個下拉菜單得到
山西的id（通過jquery $(省).change()），以山西id為父id遍歷所有市。
❷ php頁面，下拉框二級聯動，如何從資料庫讀取數據填入
上面說的沒錯。具體流程如下：一級下拉框選擇其中一個值時，觸發事件，通過ajax講選擇的值進行sql查詢，將返回的結果通過js寫入到第二級下拉框中
❸ php+jquery+MySQL 怎麼實現二級聯動
二級聯動網上就有現成的jquery代碼
搜索jquery三級聯動菜單
❹ 聯動下拉列表 php
09年全國最新重新規劃省市縣三級聯動菜單,非常好用，還帶郵編。
不過字數太多，這里不讓貼，你到這個網頁上自己看
<select id="province" onchange="setCity(this.value);getArea()" name="province">
<option value="" selected="selected">請選擇</option>
</select>
<select id="city" onchange="setCounty(this.value);getArea()" name="city" style="display:;">
<option value="" selected="selected">請選擇</option>
</select>
<select id="county" name="county" onchange="getArea()" style="display:;">
<option value="" selected="selected">請選擇</option>
</select>
<input type="text" name="area" id="area" value="222426" onchange="setArea();"/>
<input type="button" value="轉" onclick="setArea();" />
<script type="text/javascript">
var areaData = "110000|北京市,110100|市轄區,110101|東城區,110102|西城區,110103|崇文區,110104|宣武區,110105|朝陽區,110106|豐台區,110107|石景山區,110108|海淀區,110109|門頭溝區,110111|房山區,110112|通州區,110113|順義區,110114|昌平區,110115|大興區,110116|懷柔區,110117|平谷區,110200|縣,110228|密雲縣,110229|延慶縣,120000|天津市,120100|市轄區,120101|和平區,120102|河東區,120103|河西區,120104|南開區,120105|河北區,120106|紅橋區,120107|塘沽區,120108|漢沽區,120109|大港區,120110|東麗區,120111|西青區,120112|津南區,120113|北辰區,120114|武清區,120115|寶坻區,120200|縣,120221|寧河縣,120223|靜海縣,120225|薊縣,130000|河北省,130100|石家莊市,130101|市轄區,130102|長安區,130103|橋東區,130104|橋西區,130105|新華區,130107|井陘礦區,130108|裕華區,130121|井陘縣,130123|正定縣,130124|欒城縣,130125|行唐縣,130126|靈壽縣,130127|高邑縣,130128|深澤縣,130129|贊皇縣,130130|無極縣,130131|平山縣,130132|元氏縣,130133|趙縣,130181|辛集市,130182|藁城市,130183|晉州市,130184|新樂市,130185|鹿泉市,130200|唐山市,130201|市轄區,130202|路南區,130203|路北區,130204|古冶區,130205|開平區,130207|豐南區,130208|豐潤區,130223|灤縣,130224|灤南縣,130225|樂亭縣,130227|遷西縣,130229|玉田縣,130230|唐海縣,130281|遵化市,130283|遷安市,130300|秦皇島市,130301|市轄區,130302|海港區,130303|山海關區,130304|北戴河區,130321|青龍滿族自治縣,130322|昌黎縣,130323|撫寧縣,130324|盧龍縣,130400|邯鄲市,130401|市轄區,130402|邯山區,130403|叢台區,130404|復興區,130406|峰峰礦區,130421|邯鄲縣,130423|臨漳縣,130424|成安縣,130425|大名縣,130426|涉縣,130427|磁縣,130428|肥鄉縣,130429|永年縣,130430|邱縣,130431|雞澤縣,130432|廣平縣,130433|館陶縣,130434|魏縣,130435|曲周縣,130481|武安市,130500|邢台市,130501|市轄區,130502|橋東區,130503|橋西區,130521|邢台縣,130522|臨城縣,130523|內丘縣,130524|柏鄉縣,130525|隆堯縣,130526|任縣,130527|南和縣,130528|寧晉縣,130529|巨鹿縣,130530|新河縣,130531|廣宗縣,130532|平鄉縣,130533|威縣,130534|清河縣,130535|臨西縣,130581|南宮市,130582|沙河市,130600|保定市,130601|市轄區,130602|新市區,130603|北市區,130604|南市區,130621|滿城縣,130622|清苑縣,130623|淶水縣,130624|阜平縣,130625|徐水縣,130626|定興縣,130627|唐縣,130628|高陽縣,130629|容城縣,130630|淶源縣,130631|望都縣,130632|安新縣,130633|易縣,130634|曲陽縣,130635|蠡縣,130636|順平縣,130637|博野縣,130638|雄縣,130681|涿州市,130682|定州市,130683|安國市,130684|高碑店市,130700|張家口市,130701|市轄區,130702|橋東區,130703|橋西區,130705|宣化區,130706|下花園區,130721|宣化縣,130722|張北縣,130723|康保縣,130724|沽源縣,130725|尚義縣,130726|蔚縣,130727|陽原縣,130728|懷安縣,130729|萬全縣,130730|懷來縣,130731|涿鹿縣,130732|赤城縣,130733|崇禮縣,130800|承德市,130801|市轄區,130802|雙橋區,130803|雙灤區,130804|鷹手營子礦區,130821|承德縣,130822|興隆縣,130823|平泉縣,130824|灤平縣,130825|隆化縣,130826|豐寧滿族自治縣,130827|寬城滿族自治縣,130828|圍場滿族蒙古族自治縣,130900|滄州市,130901|市轄區,130902|新華區,130903|運河區,130921|滄縣,130922|青縣,130923|東光縣,130924|海興縣,130925|鹽山縣,130926|肅寧縣,130927|南皮縣,130928|吳橋縣,130929|獻縣,130930|孟村回族自治縣,130981|泊頭市,130982|任丘市,130983|黃驊市,130984|河間市,131000|廊坊市,131001|市轄區,131002|安次區,131003|廣陽區,131022|固安縣,131023|永清縣,131024|香河縣,131025|大城縣,131026|文安縣,131028|大廠回族自治縣,131081|霸州市,131082|三河市,131100|衡水市,131101|市轄區,131102|桃城區,131121|棗強縣,131122|武邑縣,131123|武強縣,131124|饒陽縣,131125|安平縣,131126|故城縣,131127|景縣,131128|阜城縣,131181|冀州市,131182|深州市,140000|山西省,140100|太原市,140101|市轄區,140105|小店區,140106|迎澤區,140107|杏花嶺區,140108|尖草坪區,140109|萬柏林區,140110|晉源區,140121|清徐縣,140122|陽曲縣,140123|婁煩縣,140181|古交市,140200|大同市,140201|市轄區,140202|城區,140203|礦區,140211|南郊區,140212|新榮區,140221|陽高縣,140222|天鎮縣,140223|廣靈縣,140224|靈丘縣,140225|渾源縣,140226|左雲縣,140227|大同縣,140300|陽泉市,140301|市轄區,140302|城區,140303|礦區,140311|郊區,140321|平定縣,140322|盂縣,140400|長治市,140401|市轄區,140402|城區,140411|郊區,140421|長治縣,140423|襄垣縣,140424|屯留縣,140425|平順縣,140426|黎城縣,140427|壺關縣,140428|長子縣,140429|武鄉縣,140430|沁縣,140431|沁源縣,140481|潞城市,140500|晉城市,140501|市轄區,140502|城區,140521|沁水縣,140522|陽城縣,140524|陵川縣,140525|澤州縣,140581|高平市,140600|朔州市,140601|市轄區,140602|朔城區,140603|平魯區,140621|山陰縣,140622|應縣,140623|右玉縣,140624|懷仁縣,140700|晉中市,140701|市轄區,140702|榆次區,140721|榆社縣,140722|左權縣,140723|和順縣,140724|昔陽縣,140725|壽陽縣,140726|太谷縣,140727|祁縣,140728|平遙縣,140729|靈石縣,140781|介休市,140800|運城市,140801|市轄區,140802|鹽湖區,140821|臨猗縣,140822|萬榮縣,140823|聞喜縣,140824|稷山縣,140825|新絳縣,140826|絳縣,140827|垣曲縣,140828|夏縣,140829|平陸縣,140830|芮城縣,140881|永濟市,140882|河津市,140900|忻州市,140901|市轄區,140902|忻府區,140921|定襄縣,140922|五台縣,140923|代縣,140924|繁峙縣,140925|寧武縣,140926|靜樂縣,140927|神池縣,140928|五寨縣,140929|岢嵐縣,140930|河曲縣,140931|保德縣,140932|偏關縣,140981|原平市,141000|臨汾市,141001|市轄區,141002|堯都區,11|曲沃縣,12|翼城縣,13|襄汾縣,14|洪洞縣,15|古縣,16|安澤縣,17|浮山縣,18|吉縣,19|鄉寧縣,141030|大寧縣,141031|隰縣,141032|永和縣,141033|蒲縣,141034|汾西縣,141081|侯馬市,141082|霍州市,141100|呂梁市,141101|市轄區,141102|離石區,141121|文水縣,141122|交城縣,141123|興縣,141124|臨縣,141125|柳林縣,141126|石樓縣,141127|嵐縣,141128|方山縣,141129|中陽縣,141130|交口縣,141181|孝義市,141182|汾陽市,150000|內蒙古自治區,150100|呼和浩特市,150101|市轄區,150102|新城區,150103|回民區,150104|玉泉區,150105|賽罕區,150121|土默特左旗,150122|托克托縣,150123|和林格爾縣,150124|清水河縣,150125|武川縣,150200|包頭市,150201|市轄區,150202|東河區,150203|昆都侖區,150204|青山區,150205|石拐區,150206|白雲礦區,150207|九原區,150221|土默特右旗,150222|固陽縣,150223|達爾罕茂明安聯合旗,150300|烏海市,150301|市轄區,150302|海勃灣區,150303|海南區,150304|烏達區,150400|赤峰市,150401|市轄區,150402|紅山區,150403|元寶山區,150404|松山區,150421|阿魯科爾沁旗,150422|巴林左旗,150423|巴林右旗,150424|林西縣,150425|克什克騰旗,150426|翁牛特旗,150428|喀喇沁旗,150429|寧城縣,150430|敖漢旗,150500|通遼市,150501|市轄區,150502|科爾沁區,150521|科爾沁左翼中旗,150522|科爾沁左翼後旗,150523|開魯縣,150524|庫倫旗,150525|奈曼旗,150526|扎魯特旗,150581|霍林郭勒市,150600|鄂爾多斯市,150601|市轄區,150602|東勝區,150621|達拉特旗,150622|准格爾旗,150623|鄂托克前旗,150624|鄂托克旗,150625|杭錦旗,150626|烏審旗,150627|伊金霍洛旗,150700|呼倫貝爾市,150701|市轄區,150702|海拉爾區,150721|阿榮旗,150722|莫力達瓦達斡爾族自治旗,150723|鄂倫春自治旗,150724|鄂溫克族自治旗,150725|陳巴爾虎旗,150726|新巴爾虎左旗,150727|新巴爾虎右旗,150781|滿洲里市,150782|牙克石市,150783|扎蘭屯市,150784|額爾古納市,150785|根河市,150800|巴彥淖爾市,150801|市轄區,150802|臨河區,150821|五原縣,150822|磴口縣,150823|烏拉特前旗,150824|烏拉特中旗,150825|烏拉特後旗,150826|杭錦後旗,150900|烏蘭察布市,150901|市轄區,150902|集寧區,150921|卓資縣,150922|化德縣,150923|商都縣,150924|興和縣,150925|涼城縣,150926|察哈爾右翼前旗,150927|察哈爾右翼中旗,150928|察哈爾右翼後旗,150929|四子王旗,150981|豐鎮市,152200|興安盟,152201|烏蘭浩特市,152202|阿爾山市,152221|科爾沁右翼前旗,152222|科爾沁右翼中旗,152223|扎賚特旗,152224|突泉縣,152500|錫林郭勒盟,152501|二連浩特市,152502|錫林浩特市,152522|阿巴嘎旗,152523|蘇尼特左旗,152524|蘇尼特右旗,152525|東烏珠穆沁旗,152526|西烏珠穆沁旗,152527|太僕寺旗,152528|鑲黃旗,152529|正鑲白旗,152530|正藍旗,152531|多倫縣,152900|阿拉善盟,152921|阿拉善左旗,152922|阿拉善右旗,152923|額濟納旗,210000|遼寧省,210100|沈陽市,210101|市轄區,210102|和平區,210103|瀋河區,210104|大東區,210105|皇姑區,210106|鐵西區,210111|蘇家屯區,210112|東陵區,210113|沈北新區,210114|於洪區,210122|遼中縣,210123|康平縣,210124|法庫縣,210181|新民市,210200|大連市,210201|市轄區,210202|中山區,210203|西崗區,210204|沙河口區,210211|甘井子區,210212|旅順口區,210213|金州區,210224|長海縣,210281|瓦房店市,210282|普蘭店市,210283|庄河市,210300|鞍山市,210301|市轄區,210302|鐵東區,210303|鐵西區,210304|立山區,210311|千山區,210321|台安縣,210323|岫岩滿族自治縣,210381|海城市,210400|撫順市,210401|市轄區,210402|新撫區,210403|東洲區,210404|望花區,210411|順城區,210421|撫順縣,210422|新賓滿族自治縣,210423|清原滿族自治縣,210500|本溪市,210501|市轄區,210502|平山區,210503|溪湖區,210504|明山區,210505|南芬區,210521|本溪滿族自治縣,210522|桓仁滿族自治縣,210600|丹東市,210601|市轄區,210602|元寶區,210603|振興區,210604|振安區,210624|寬甸滿族自治縣,210681|東港市,210682|鳳城市,210700|錦州市,210701|市轄區,210702|古塔區,210703|凌河區,210711|太和區,210726|黑山縣,210727|義縣,210781|凌海市,210782|北鎮市,210800|營口市,210801|市轄區,210802|站前區,210803|西市區,210804|鮁魚圈區,210811|老邊區,210881|蓋州市,210882|大石橋市,210900|阜新市,210901|市轄區,210902|海州區,210903|新邱區,210904|太平區,210905|清河門區,210911|細河區,210921|阜新蒙古族自治縣,210922|彰武縣,211000|遼陽市,211001|市轄區,211002|白塔區,211003|文聖區,211004|宏偉區,211005|弓長嶺區,211011|太子河區,211021|遼陽縣,211081|燈塔市,211100|盤錦市,211101|市轄區,211102|雙檯子區,211103|興隆台區,211121|大窪縣,211122|盤山縣,211200|鐵嶺市,211201|市轄區,211202|銀州區,211204|清河區,211221|鐵嶺縣,211223|西豐縣,211224|昌圖縣,211281|調兵山市,211282|開原市,00|朝陽市,01|市轄區,02|雙塔區,03|龍城區,21|朝陽縣,22|建平縣,24|喀喇沁左翼蒙古族自治縣,81|北票市,82|凌源市,211400|葫蘆島市,211401|市轄區,211402|連山區,211403|龍港區,211404|南票區,211421|綏中縣,211422|建昌縣,211481|興城市,220000|吉林省,220100|長春市,220101|市轄區,220102|南關區,220103|寬城區,220104|朝陽區,220105|二道區,220106|綠園區,220112|雙陽區,220122|農安縣,220181|九台市,220182|榆樹市,220183|德惠市,220200|吉林市,220201|市轄區,220202|昌邑區,220203|龍潭區,220204|船營區,220211|豐滿區,220221|永吉縣,220281|蛟河市,220282|樺甸市,220283|舒蘭市,220284|磐石市,220300|四平市,220301|市轄區,220302|鐵西區,220303|鐵東區,220322|梨樹縣,220323|伊通滿族自治縣,220381|公主嶺市,220382|雙遼市,220400|遼源市,220401|市轄區,220402|龍山區,220403|西安區,220421|東豐縣,220422|東遼縣,220500|通化市,220501|市轄區,220502|東昌區,220503|二道江區,220521|通化縣,220523|輝南縣,220524|柳河縣,220581|梅河口市,220582|集安市,220600|白山市,220601|市轄區,220602|八道江區,220605|江源區,220621|撫松縣,220622|靖宇縣,220623|長白朝鮮族自治縣,220681|臨江市,220700|松原市,220701|市轄區,220702|寧江區,220721|前郭爾羅斯蒙古族自治縣,220722|長嶺縣,220723|乾安縣,220724|扶余縣,220800|白城市,220801|市轄區,220802|洮北區,220821|鎮賚縣,220822|通榆縣,220881|洮南市,220882|大安市,222400|延邊朝鮮族自治州,222401|延吉市,222402|圖們市,222403|敦化市,222404|琿春市,222405|龍井市,222406|和龍市,222424|汪清縣,222426|安圖縣,230000|黑龍江省,230100|哈爾濱市,230101|市轄區,230102|道里區,230103|南崗區,230104|道外區,230108|平房區,230109|松北區,230110|香坊區,230111|呼蘭區,230112|阿城區,230123|依蘭縣,230124|方正縣,230125|賓縣,230126|巴彥縣,230127|木蘭縣,230128|通河縣,230129|延壽縣,230182|雙城市,230183|尚志市,230184|五常市,230200|齊齊哈爾市,230201|市轄區,230202|龍沙區,230203|建華區,230204|鐵鋒區,230205|昂昂溪區,230206|富拉爾基區,230207|碾子山區,230208|梅里斯達斡爾族區,230221|龍江縣,230223|依安縣,230224|泰來縣,230225|甘南縣,230227|富裕縣,230229|克山縣,230230|克東縣,230231|拜泉縣,230281|訥河市,230300|雞西市,230301|市轄區,230302|雞冠區,230303|恆山區,230304|滴道區,230305|梨樹區,230306|城子河區,230307|麻山區,230321|雞東縣,230381|虎林市,230382|密山市,230400|鶴崗市,230401|市轄區,230402|向陽區,230403|工農區,230404|南山區,230405|興安區,230406|東山區,230407|興山區,230421|蘿北縣,230422|綏濱縣,230500|雙鴨山市,230501|市轄區,230502|尖山區,230503|嶺東區,230505|四方台區,230506|寶山區,230521|集賢縣,230522|友誼縣,230523|寶清縣,230524|饒河縣,230600|大慶市,230601|市轄區,230602|薩爾圖區,230603|龍鳳區,230604|讓胡路區,230605|紅崗區,230606|大同區,230621|肇州縣,230622|肇源縣,433130|龍山縣,440000|廣東省,440100|廣州市,440101|市轄區,440103|荔灣區,440104|越秀區,440105|海珠
❺ php和js下拉菜單聯動
var selected_state=state_list.options[state_list.selectedIndex].value;
❻ 如何用PHP實現select二級聯動，根據第一個下拉框選擇的內容來選擇第二個下拉框的內容
給第一個select加js事件，點擊它的時候動態載入第二個select的內容，比如寫個ajax獲取第一個select的value（這個value是哪個quanx_id），然後去後台請求，後無論是用緩存還是說直接從資料庫中查，得到這個value對應的field，再返回數據到前台進行處理。也可以在頁面載入的時候就直接吧每個quanx_id的對應關系全部查找並在模板中的js用相應變數存儲後，再採用上面的思路去動態載入就是了。反正最終都是當select1的value發生變化，動態載入select2的value.
❼ 如何用PHP做二級下拉菜單啊
首先，這種效果是html的select標簽實現的，其實php要做的就是將數據按照一定的格式組織好，然後按照一定的規則輸出即可。
下面是大致的示例代碼。
// 首先根據你現有的數據對其按照一定的格式組織
$brands = array(
'東風本田' => array('艾力紳','本田CR-V',...),
'廣汽本田' => array(...),
...
);
// 輸出HTML標簽
echo '<select name="brands" size="1">';
echo '<option value="">請選擇車系</option>';
foreach ($brands as $brand => $items) {
echo '<optgroup label="',$brand,'">';
foreach ($items as $item) {
echo '<option value="',$item,'">',$item,'</option>';
}
echo '</optgroup>';
}
echo '</select>';