全国省市县区街道无联动下拉选择-php手册-PHP中文網

首頁

php教程

php手册

全国省市县区街道无联动下拉选择

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 am 11:37 AM

全国省市县区街道无联动下拉选择数据库及源代码
全国省市县区街道无联动下拉选择
前端JQ代码
引入jq库<script> $(document).ready(function() { // 加载所有的省份 $.ajax({ type: "get", url: "{:U('Lease/region')}", // type=1表示查询省份 dataType: "json", success: function(data) { $("#provinces").html("<option value=''>请选择省份"); $.each(data, function(i, item) { $("#provinces").append("<option value='" + item.provice_id + "'>" + item.provice_name + ""); }); } }); $("#provinces").change(function() { $.ajax({ type: "get", url: "{:U('Lease/regioncity')}", // type =2表示查询市 data: { "province_id": $(this).val(), }, dataType: "json", success: function(data) { $("#citys").css('display','block'); $("#citys").html("<option value=''>请选择市"); $.each(data, function(i, item) { $("#citys").append("<option value='" + item.city_id + "'>" + item.city_name + ""); }); } }); }); $("#citys").change(function() { $.ajax({ type: "get", url: "{:U('Lease/regioncounty')}", // type =2表示查询市 data: { "city_id": $(this).val(), }, dataType: "json", success: function(data) { $("#countys").css('display','block'); $("#countys").html("<option value=''>请选择县"); $.each(data, function(i, item) { $("#countys").append("<option value='" + item.county_id + "'>" + item.county_name + ""); }); } }); }); $("#countys").change(function() { $.ajax({ type: "get", url: "{:U('Lease/regiontown')}", // data: { "county_id": $(this).val(), }, dataType: "json", success: function(data) { $("#towns").css('display','block'); $("#towns").html("<option value=''>请选择街道"); $.each(data, function(i, item) { $("#towns").append("<option value='" + item.town_id + "'>" + item.town_name + ""); }); } }); }); $("#towns").change(function() { $.ajax({ type: "get", url: "{:U('Lease/regionvillage')}", // data: { "town_id": $(this).val(), }, dataType: "json", success: function(data) { $("#villages").css('display','block'); $("#villages").html("<option value=''>请选择社区"); $.each(data, function(i, item) { $("#villages").append("<option value='" + item.village_id + "'>" + item.village_name + ""); }); } }); }); }); </script>html代码<div> <select> <option>请选择省份</option> </select> <select> <option>请选择市</option> </select> <select> <option>请选择县</option> </select> <select> <option>请选择街道</option> </select> <select> <option>请选择社区</option> </select> </div>thinkphp代码//读取省数据库 public function region(){ $provinces=M('Position_provice')->select(); $provinces_json = json_encode($provinces); exit($provinces_json); } //读取市数据库 public function regioncity(){ $where['province_id']=$_GET['province_id']; $provinces=M('Position_city')->where($where)->select(); $provinces_city = json_encode($provinces); exit($provinces_city); } //读取省/区数据库 public function regioncounty(){ $where['city_id']=$_GET['city_id']; $provinces=M('Position_county')->where($where)->select(); $provinces_county = json_encode($provinces); exit($provinces_county); } //读取街道数据库 public function regiontown(){ $where['county_id']=$_GET['county_id']; $provinces=M('Position_town')->where($where)->select(); $provinces_town = json_encode($provinces); exit($provinces_town); } //读取社区数据库 public function regionvillage(){ $where['town_id']=$_GET['town_id']; $provinces=M('Position_village')->where($where)->select(); $provinces_village = json_encode($provinces); exit($provinces_village); }数据库http://blog.jjonline.cn/soft/J_Position/ajing.sql.gz