public function change_select_json(){ $type = input('type',''); $id = input('id',''); if($type==1){ $where[] = ['province_num','=',$id]; $list = ZFTB('data_city')->where($where)->order("id asc")->select(); }else{ $where[] = ['city_num','=',$id]; $list = ZFTB('data_area')->where($where)->order("id asc")->select(); } return jssuccess($list);}
<?php if(is_numeric($user['address']) && is_numeric($user['address2']) && is_numeric($user['address3']) ){ ?> <select name="address" class="address_1"> <?php foreach(get_province() as $kk=>$vv){ ?> <option value="{$vv['province_num']}" {$user['address']==$vv['province_num']?'selected':''}>{$vv['province_name']}</option> <?php } ?> </select> <select name="address2" class="address_2"> <option value="{$user['address2']}">{:get_ssq(2,$user['address2'])}</option> </select> <select name="address3" class="address_3"> <option value="{$user['address3']}">{:get_ssq(3,$user['address3'])}</option> </select> <?php }else{ ?> <select name="address" class="address_1"> <option value="{$user['address']}">{$user['address']}</option> <?php foreach(get_province() as $kk=>$vv){ ?> <option value="{$vv['province_num']}">{$vv['province_name']}</option> <?php } ?> </select> <select name="address2" class="address_2"> <option value="{$user['address2']}">{$user['address2']}</option> </select> <select name="address3" class="address_3"> <option value="{$user['address3']}">{$user['address3']}</option> </select> <?php } ?>
<script type="text/javascript"> //查询国家 $(".address_1").on('change',function(){ var id = $(this).val() var type = '1' console.log(id) $.ajax({ type:'post', url:"/change_select_json", data:{id,type}, dataType:'json', success:function(res){ var html = '<option value="请选择">请选择</option>' for (var i = res.msg.length - 1; i >= 0; i--) { html +="<option value='"+res.msg[i].city_num+"'>"+res.msg[i].city_name+"</option>" } $(".address_2").html(html) } }) }) $(".address_2").on('change',function(){ var id = $(this).val() var type = '2' console.log(id) $.ajax({ type:'post', url:"/change_select_json", data:{id,type}, dataType:'json', success:function(res){ var html = '<option value="请选择">请选择</option>' for (var i = res.msg.length - 1; i >= 0; i--) { html +="<option value='"+res.msg[i].id+"'>"+res.msg[i].area_name+"</option>" } $(".address_3").html(html) } }) })
</script>
//获取省份 function get_province(){ $list = db('data_province')->order('id asc')->select(); return $list; }
关于数据库文件,有需要的联系站长,不保证是最新的数据