全国省市县区街道 无联动下拉选择 数据库及源代码
前端JQ代码
引入jq库<script><br />
$(document).ready(function() {<br />
// 加载所有的省份<br />
$.ajax({<br />
type: "get",<br />
url: "{:U('Lease/region')}", // type=1表示查询省份 <br />
dataType: "json",<br />
success: function(data) {<br />
$("#provinces").html("<option value=''>请选择省份");<br />
$.each(data, function(i, item) {<br />
$("#provinces").append("<option value='" + item.provice_id + "'>" + item.provice_name + "");<br />
});<br />
}<br />
});<br />
$("#provinces").change(function() {<br />
$.ajax({<br />
type: "get",<br />
url: "{:U('Lease/regioncity')}", // type =2表示查询市<br />
data: {<br />
"province_id": $(this).val(),<br />
},<br />
dataType: "json",<br />
success: function(data) {<br />
$("#citys").css('display','block');<br />
$("#citys").html("<option value=''>请选择市");<br />
$.each(data, function(i, item) {<br />
$("#citys").append("<option value='" + item.city_id + "'>" + item.city_name + "");<br />
});<br />
}<br />
});<br />
});<br />
$("#citys").change(function() {<br />
$.ajax({<br />
type: "get",<br />
url: "{:U('Lease/regioncounty')}", // type =2表示查询市<br />
data: {<br />
"city_id": $(this).val(),<br />
},<br />
dataType: "json",<br />
success: function(data) {<br />
$("#countys").css('display','block');<br />
$("#countys").html("<option value=''>请选择县");<br />
$.each(data, function(i, item) {<br />
$("#countys").append("<option value='" + item.county_id + "'>" + item.county_name + "");<br />
});<br />
}<br />
});<br />
});<br />
$("#countys").change(function() {<br />
$.ajax({<br />
type: "get",<br />
url: "{:U('Lease/regiontown')}", // <br />
data: {<br />
"county_id": $(this).val(),<br />
},<br />
dataType: "json",<br />
success: function(data) {<br />
$("#towns").css('display','block');<br />
$("#towns").html("<option value=''>请选择街道");<br />
$.each(data, function(i, item) {<br />
$("#towns").append("<option value='" + item.town_id + "'>" + item.town_name + "");<br />
});<br />
}<br />
});<br />
});<br />
$("#towns").change(function() {<br />
$.ajax({<br />
type: "get",<br />
url: "{:U('Lease/regionvillage')}", // <br />
data: {<br />
"town_id": $(this).val(),<br />
},<br />
dataType: "json",<br />
success: function(data) {<br />
$("#villages").css('display','block');<br />
$("#villages").html("<option value=''>请选择社区");<br />
$.each(data, function(i, item) {<br />
$("#villages").append("<option value='" + item.village_id + "'>" + item.village_name + "");<br />
});<br />
}<br />
});<br />
});<br />
});<br />
</script>html代码<div>
<br>
<select><br>
<option>请选择省份</option>
<br>
</select><br>
<select><br>
<option>请选择市</option>
<br>
</select><br>
<select><br>
<option>请选择县</option>
<br>
</select><br>
<select><br>
<option>请选择街道</option>
<br>
</select><br>
<select><br>
<option>请选择社区</option>
<br>
</select><br>
</div>thinkphp代码//读取省数据库<br>
public function region(){<br>
$provinces=M('Position_provice')->select();<br>
$provinces_json = json_encode($provinces);<br>
exit($provinces_json);<br>
}<br>
//读取市数据库<br>
public function regioncity(){<br>
$where['province_id']=$_GET['province_id'];<br>
$provinces=M('Position_city')->where($where)->select();<br>
$provinces_city = json_encode($provinces);<br>
exit($provinces_city);<br>
}<br>
//读取省/区数据库<br>
public function regioncounty(){<br>
$where['city_id']=$_GET['city_id'];<br>
$provinces=M('Position_county')->where($where)->select();<br>
$provinces_county = json_encode($provinces);<br>
exit($provinces_county);<br>
}<br>
//读取街道数据库<br>
public function regiontown(){<br>
$where['county_id']=$_GET['county_id'];<br>
$provinces=M('Position_town')->where($where)->select();<br>
$provinces_town = json_encode($provinces);<br>
exit($provinces_town);<br>
}<br>
//读取社区数据库<br>
public function regionvillage(){<br>
$where['town_id']=$_GET['town_id'];<br>
$provinces=M('Position_village')->where($where)->select();<br>
$provinces_village = json_encode($provinces);<br>
exit($provinces_village);<br>
}数据库http://blog.jjonline.cn/soft/J_Position/ajing.sql.gz
AD：真正免费，域名+虚机+企业邮箱=0元
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
C++高性能并发应用_C++如何开发性能关键应用
Java AI集成Deep Java Library_Java怎么集成AI模型部署
Golang后端API开发_Golang如何高效开发后端和API
Python异步并发改进_Python异步编程有哪些新改进
C++系统编程内存管理_C++系统编程怎么与Rust竞争内存安全
Java GraalVM原生镜像构建_Java怎么用GraalVM构建高效原生镜像
Python FastAPI异步API开发_Python怎么用FastAPI构建异步API
C++现代C++20/23/26特性_现代C++有哪些新标准特性如modules和coroutines
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
11059
收藏
