调用省市区联动

子枫 [Rainy]

发布于 2022-07-04

340 浏览

<pre class="brush:php;toolbar:false">
public&nbsp;function&nbsp;change_select_json(){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$type&nbsp;=&nbsp;input(&#39;type&#39;,&#39;&#39;);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$id&nbsp;=&nbsp;input(&#39;id&#39;,&#39;&#39;);
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($type==1){
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$where[]&nbsp;=&nbsp;[&#39;province_num&#39;,&#39;=&#39;,$id];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$list&nbsp;=&nbsp;ZFTB(&#39;data_city&#39;)-&gt;where($where)-&gt;order(&quot;id&nbsp;asc&quot;)-&gt;select();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$where[]&nbsp;=&nbsp;[&#39;city_num&#39;,&#39;=&#39;,$id];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$list&nbsp;=&nbsp;ZFTB(&#39;data_area&#39;)-&gt;where($where)-&gt;order(&quot;id&nbsp;asc&quot;)-&gt;select();
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;jssuccess($list);

&nbsp;&nbsp;&nbsp;&nbsp;}

&lt;?php&nbsp;if(is_numeric($user[&#39;address&#39;])&nbsp;&amp;&amp;&nbsp;is_numeric($user[&#39;address2&#39;])&nbsp;&amp;&amp;&nbsp;is_numeric($user[&#39;address3&#39;])&nbsp;){&nbsp;?&gt;
    &lt;select&nbsp;name=&quot;address&quot;&nbsp;class=&quot;address_1&quot;&gt;
     &lt;?php&nbsp;foreach(get_province()&nbsp;as&nbsp;$kk=&gt;$vv){&nbsp;?&gt;
      &lt;option&nbsp;value=&quot;{$vv[&#39;province_num&#39;]}&quot;&nbsp;{$user[&#39;address&#39;]==$vv[&#39;province_num&#39;]?&#39;selected&#39;:&#39;&#39;}&gt;{$vv[&#39;province_name&#39;]}&lt;/option&gt;
     &lt;?php&nbsp;}&nbsp;&nbsp;?&gt;
    &lt;/select&gt;
   &lt;select&nbsp;name=&quot;address2&quot;&nbsp;class=&quot;address_2&quot;&gt;
      &lt;option&nbsp;value=&quot;{$user[&#39;address2&#39;]}&quot;&gt;{:get_ssq(2,$user[&#39;address2&#39;])}&lt;/option&gt;
   &lt;/select&gt;
   &lt;select&nbsp;name=&quot;address3&quot;&nbsp;class=&quot;address_3&quot;&gt;
      &lt;option&nbsp;value=&quot;{$user[&#39;address3&#39;]}&quot;&gt;{:get_ssq(3,$user[&#39;address3&#39;])}&lt;/option&gt;
   &lt;/select&gt;
 &lt;?php&nbsp;}else{&nbsp;?&gt;
   &lt;select&nbsp;name=&quot;address&quot;&nbsp;class=&quot;address_1&quot;&gt;
     &lt;option&nbsp;value=&quot;{$user[&#39;address&#39;]}&quot;&gt;{$user[&#39;address&#39;]}&lt;/option&gt;
     &lt;?php&nbsp;foreach(get_province()&nbsp;as&nbsp;$kk=&gt;$vv){&nbsp;?&gt;
      &lt;option&nbsp;value=&quot;{$vv[&#39;province_num&#39;]}&quot;&gt;{$vv[&#39;province_name&#39;]}&lt;/option&gt;
      &lt;?php&nbsp;}&nbsp;&nbsp;?&gt;
    &lt;/select&gt;
   &lt;select&nbsp;name=&quot;address2&quot;&nbsp;class=&quot;address_2&quot;&gt;
      &lt;option&nbsp;value=&quot;{$user[&#39;address2&#39;]}&quot;&gt;{$user[&#39;address2&#39;]}&lt;/option&gt;
   &lt;/select&gt;
   &lt;select&nbsp;name=&quot;address3&quot;&nbsp;class=&quot;address_3&quot;&gt;
      &lt;option&nbsp;value=&quot;{$user[&#39;address3&#39;]}&quot;&gt;{$user[&#39;address3&#39;]}&lt;/option&gt;
   &lt;/select&gt;
 &lt;?php&nbsp;}&nbsp;?&gt;

&lt;script&nbsp;type=&quot;text/javascript&quot;&gt;
//查询国家
$(&quot;.address_1&quot;).on(&#39;change&#39;,function(){
&nbsp;&nbsp;var&nbsp;id&nbsp;=&nbsp;$(this).val()
&nbsp;&nbsp;var&nbsp;type&nbsp;=&nbsp;&#39;1&#39;
&nbsp;&nbsp;console.log(id)
&nbsp;&nbsp;$.ajax({
  &nbsp;&nbsp;type:&#39;post&#39;,
  &nbsp;&nbsp;url:&quot;/change_select_json&quot;,
  &nbsp;&nbsp;data:{id,type},
 &nbsp;&nbsp;dataType:&#39;json&#39;,
  &nbsp;&nbsp;success:function(res){
    &nbsp;&nbsp;var&nbsp;html&nbsp;=&nbsp;&#39;&lt;option&nbsp;value=&quot;请选择&quot;&gt;请选择&lt;/option&gt;&#39;
   &nbsp;&nbsp;for&nbsp;(var&nbsp;i&nbsp;=&nbsp;res.msg.length&nbsp;-&nbsp;1;&nbsp;i&nbsp;&gt;=&nbsp;0;&nbsp;i--)&nbsp;{
     html&nbsp;+=&quot;&lt;option&nbsp;value=&#39;&quot;+res.msg[i].city_num+&quot;&#39;&gt;&quot;+res.msg[i].city_name+&quot;&lt;/option&gt;&quot;
    &nbsp;&nbsp;}
   &nbsp;&nbsp;$(&quot;.address_2&quot;).html(html)
  &nbsp;&nbsp;}
&nbsp;&nbsp;})
})
$(&quot;.address_2&quot;).on(&#39;change&#39;,function(){
&nbsp;&nbsp;var&nbsp;id&nbsp;=&nbsp;$(this).val()
&nbsp;&nbsp;var&nbsp;type&nbsp;=&nbsp;&#39;2&#39;
&nbsp;&nbsp;console.log(id)
&nbsp;&nbsp;$.ajax({
 &nbsp;&nbsp;type:&#39;post&#39;,
  &nbsp;&nbsp;url:&quot;/change_select_json&quot;,
  &nbsp;&nbsp;data:{id,type},
 &nbsp;&nbsp;dataType:&#39;json&#39;,
  &nbsp;&nbsp;success:function(res){
    &nbsp;&nbsp;var&nbsp;html&nbsp;=&nbsp;&#39;&lt;option&nbsp;value=&quot;请选择&quot;&gt;请选择&lt;/option&gt;&#39;
   &nbsp;&nbsp;for&nbsp;(var&nbsp;i&nbsp;=&nbsp;res.msg.length&nbsp;-&nbsp;1;&nbsp;i&nbsp;&gt;=&nbsp;0;&nbsp;i--)&nbsp;{
     html&nbsp;+=&quot;&lt;option&nbsp;value=&#39;&quot;+res.msg[i].id+&quot;&#39;&gt;&quot;+res.msg[i].area_name+&quot;&lt;/option&gt;&quot;
    &nbsp;&nbsp;}
   &nbsp;&nbsp;$(&quot;.address_3&quot;).html(html)
  &nbsp;&nbsp;}
&nbsp;&nbsp;})
})

&lt;/script&gt;

//获取省份
function&nbsp;get_province(){
&nbsp;&nbsp;&nbsp;&nbsp;$list&nbsp;=&nbsp;db(&#39;data_province&#39;)-&gt;order(&#39;id&nbsp;asc&#39;)-&gt;select();
&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;$list;
}</pre><p>关于数据库文件,有需要的联系站长,不保证是最新的数据<br/></p>

评论输入框

评论列表

没有任何评论

调用省市区联动

评论 (56)

分享图片