tp3实现省市区三级联动

博客提供了HTML和PHP的核心代码以及数据库文件,用户可通过链接http://pan.baidu.com/s/1kU2RDTP进行下载。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

html:

<!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 type="text/javascript" src="__ROOT__/Public/js/jquery-1.js"></script> -->
<!-- <script type="text/javascript" src="__ROOT__/Public/js/jquery-2.1.4.min.js"></script> -->
<script src="https://cdn.staticfile.org/jquery/1.10.2/jquery.min.js">
</script>
</head>

<body>
<div>
	<label>所在地点</label>
	<select name="province_id" id="province_id" style="width:150px;">
		<option>请选择</option>
        <volist name="province_list" id="province">
        	<option  value="{$province.region_id}">{$province.region_name}</option>
        </volist>                                                  
     </select>
	 <select name="city_id"  id="city_id" style="width:150px;" >
		 <option>请选择</option>
		 <volist name="city_list" id="city">
		 	<option value="{$city.region_id}" selected="selected">{$city.region_name}</option>
		 </volist>                                                  
	  </select>
	  <select name="district_id"  id="district_id" style="width:150px;" >
		  <option value="0">请选择</option>
		  <volist name="dis_list" id="dis">
		   <option value="{$dis.region_id}" selected="selected">{$dis.region_name}</option>
		  </volist>                                              
	   </select>  
</div>
<script>
	$("#province_id").change(function(){
	var province_id=$(this).val();
	$.ajax({
		url:'Home/Index/get_citys',
		Type:"POST",
		data:"province_id="+province_id,
		dataType:"json",
		success:function(data){
			var city = data.city;
			var option=$("<option></option>");
			$(option).val("0");
			$(option).html("请选择");
			var option1=$("<option></option>");
			$(option1).val("0");
			$(option1).html("请选择");
			$("#city_id").html(option);
			$("#district_id").html(option1);
			for(var i in city){
				var option=$("<option></option>");
				$(option).val(city[i]['region_id']);
				$(option).html(city[i]['region_name']);
				$("#city_id").append(option);
			}
		}
		
	});
});
</script>
<script>
$("#city_id").change(function(){
	var city_id=$(this).val();
	$.ajax({
		url:'Home/Index/get_district',
		Type:"POST",
		data:"city_id="+city_id,
		dataType:"json",
		success:function(data){
			var district = data.district;
			var option=$("<option></option>");
			$(option).val("0");
			$(option).html("请选择");
			$("#district_id").html(option);
			for(var i in district){
				var option=$("<option></option>");
				$(option).val(district[i]['region_id']);
				$(option).html(district[i]['region_name']);
				$("#district_id").append(option);
			}
		}
	});
});
</script>
</body>
</html>

php:

<?php
namespace Home\Controller;
use Think\Controller;
class IndexController extends Controller {
	//获取省和直辖市
    public function index(){
		$listObj = M('region');
		$whereprovince['top_parentid'] = 0;
		$listprovince = $listObj->where($whereprovince)->select();
		$this->assign("province_list",$listprovince);
		
        $this->display();
    }
	//获取地级市
	public function get_citys(){
		$listObj = M('region');
		$where['top_parentid'] = I('province_id');
		$where['level'] = 2;
		$list = $listObj->where($where)->select();
		$data=array('status'=>0,'city'=>$list);
		header("Content-type: application/json");
		exit(json_encode($data));
	}
	//获取地级县
	public function get_district(){
		$listObj = M('region');
		$where['parent_id'] = I('city_id');
		$where['level'] = 3;
		$list = $listObj->where($where)->select();
		$data=array('status'=>0,'district'=>$list);
		header("Content-type: application/json");
		exit(json_encode($data));
	}
}

下面是核心代码和数据库文件,需要的下载就可以了。

http://pan.baidu.com/s/1kU2RDTP

PHP代码 <?php namespace Admin\Controller; use Think\Controller; class GoodController extends Controller { public function release() { /* * 开始新的操作 * */ $data=array(); $data[&#39;productname&#39;]=$_POST[&#39;productname&#39;]; $data[&#39;introduction&#39;]=$_POST[&#39;introduction&#39;]; $data[&#39;codenumber&#39;]=$_POST[&#39;codenumber&#39;]; $data[&#39;Productunit&#39;]=I(&#39;post.Productunit&#39;); $data[&#39;sku&#39;]=I(&#39;post.sku&#39;); $data[&#39;province&#39;]=I(&#39;post.province&#39;); $data[&#39;city&#39;]=I(&#39;post.city&#39;); $data[&#39;town&#39;]=I(&#39;post.town&#39;); $data[&#39;classification&#39;]=I(&#39;post.classification&#39;); $data[&#39;Extendedclass&#39;]=I(&#39;post.Extendedclass&#39;); $data[&#39;Commoditybrand&#39;]=I(&#39;post.Commoditybrand&#39;); $data[&#39;Commoditybrand&#39;]=I(&#39;post.Commoditybrand&#39;); $data[&#39;Shopprice&#39;]=I(&#39;post.Shopprice&#39;); $data[&#39;Marketvalue&#39;]=I(&#39;post.Marketvalue&#39;); $data[&#39;Capitalizedcost&#39;]=I(&#39;post.Capitalizedcost&#39;); $data[&#39;Commission&#39;]=I(&#39;post.Commission&#39;); $data[&#39;original_img&#39;]=I(&#39;post.original_img&#39;); /*商品重量*/ $data[&#39;Commodityweight&#39;]=I(&#39;post.Commodityweight&#39;); $data[&#39;mail&#39;]=I(&#39;post.mail&#39;); /*库存数量*/ $data[&#39;Inventoryquantity&#39;]=I(&#39;post.Inventoryquantity&#39;); /*赠送积分*/ $data[&#39;Giftpoints&#39;]=I(&#39;post.Giftpoints&#39;); /*兑换积分*/ $data[&#39;exchange_integral&#39;]=I(&#39;post.exchange_integral&#39;); /*商品关检词*/ $data[&#39;Keyword&#39;]=I(&#39;post.Keyword&#39;); /*商品详情描述*/ $data[&#39;describe&#39;]=I(&#39;post.describe&#39;); $commodity=M(&#39;commodity&#39;); /*准备开启事物*/ $commodity->startTrans(); $result=$commodity->add($data); if(!$result){ /*回滚事物*/ $commodity->rollback(); }else{ /*提交事物*/ $commodity->commit(); } /*1导入thinkphp得我自带的auth类库 * 加锁操作。若果同个用户(判断同个用户名操作)同时加入同样的sku时, * 那么如果存在时就加不上去(数量),如果不存在时(如果不存在时的数量不一样时)就insert上去 * */ $province = M(&#39;prvices&#39;)->where ( array(&#39;pid&#39;=>1) )->select (); $this->assign(&#39;province&#39;,$province); $this->display(); } public function getRegion(){ /* * 接收市区 * */ $Region=M("prvices"); $map[&#39;pid&#39;]=$_REQUEST["pid"]; $map[&#39;type&#39;]=$_REQUEST["type"]; $list=$Region->where($map)->select(); echo json_encode($list); } public function sku() { $this->display(); } } html: <tr> <td>商品所在地</td> <td> <select name="addres" id="province" <option value="0" selected>省份/直辖市</option> <volist name="province" id="vo"> <option value="{$vo.id}" >{$vo.name} </option> </volist> </select> <select name="city" id="city" <option value="0">市/县</option> </select> <select name="town" id="town"> <option value="0">镇/区</option> </select> </td> </tr> function loadRegion(sel,type_id,selName,url){ jQuery("#"+selName+" option").each(function(){ jQuery(this).remove(); }); jQuery("<option value=0>请选择</option>").appendTo(jQuery("#"+selName)); if(jQuery("#"+sel).val()==0){ return; } jQuery.getJSON(url,{pid:jQuery("#"+sel).val(),type:type_id}, function(data){ if(data){ jQuery.each(data,function(idx,item){ jQuery("<option value="+item.id+">"+item.name+"</option>").appendTo(jQuery("#"+selName)); }); }else{ jQuery("<option value=&#39;0&#39;>请选择</option>").appendTo(jQuery("#"+selName)); } } ); }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值