標籤：set doctype meta function and sheng min select where
題目要求：
要求：寫一個省市區（或者年月日）的三級聯動，實現地區或時間的下拉選擇。
實現技術：php ajax
實現：省級下拉變化時市下拉區下拉跟著變化，市級下拉變化時區下拉跟著變化。
使用chinastates表查詢
主介面
<!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=utf-8" /> <title>無標題文檔</title> <script src="jquery-1.11.2.min.js"></script> </head><body><h1>三級聯動</h1><select id="sheng"></select><select id="shi"></select><select id="qu"></select> </body><script type="text/javascript"> $(document).ready(function(e) { sheng(); shi(); qu(); $("#sheng").change(function(){ shi(); qu(); }); $("#shi").change(function(){ qu(); }); }); function sheng() { var areacode = "0001"; $.ajax({ async:false, url: "liandongjiazai.php", data: {areacode: areacode}, type: "POST", dataType: "TEXT", success: function (data) { var str = ""; var hang = data.split("|"); for (var i = 0; i < hang.length; i++) { var lie = hang[i].split("^"); str = str + "<option value=‘"+lie[0]+"‘>" + lie[1] + "</option>"; } $("#sheng").html(str); } }); } function shi() { var areacode = $("#sheng").val(); $.ajax({ async:false, url:"liandongjiazai.php", data:{areacode:areacode}, type:"POST", dataType:"TEXT", success: function(data){ var str = ""; var hang = data.split("|"); for(var i=0;i<hang.length;i++) { var lie = hang[i].split("^"); str = str+"<option value=‘"+lie[0]+"‘>"+lie[1]+"</option>"; } $("#shi").html(str); } }); } function qu() { var areacode = $("#shi").val(); $.ajax({ url:"liandongjiazai.php", data:{areacode:areacode}, type:"POST", dataType:"TEXT", success: function(data){ var str = ""; var hang = data.split("|"); for(var i=0;i<hang.length;i++) { var lie = hang[i].split("^"); str = str+"<option value=‘"+lie[0]+"‘>"+lie[1]+"</option>"; } $("#qu").html(str); } }); } </script></html>
處理
<?php $areacode = $_POST["areacode"];include("LZY.class.php");$db= new LZY(); $sql = "select * from chinastates WHERE parentareacode=‘{$areacode}‘ ";$arr = $db->Query($sql);$str = "";foreach($arr as $v){ $str = $str.implode("^",$v)."|"; }$str = substr($str,0,strlen($str)-1);echo $str;
ajax實現省、市、區、三級聯動（例題）
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
