Thinkphp realizes three-level linkage between provinces and municipalities-PHP源码-php.cn

Home

php教程

PHP源码

Thinkphp realizes three-level linkage between provinces and municipalities

不言

May 18, 2018 pm 04:21 PM

Skip to [1] [2] [3] [4] [Full screen preview]

 public function index(){
        $province = M(&#39;Tree&#39;)->where ( array(&#39;pid&#39;=>1) )->select ();
        $this->assign(&#39;province&#39;,$province);
        $this->display();
    
    }
    public function getRegion(){
        $Region=M("Tree");
        $map[&#39;pid&#39;]=$_REQUEST["pid"];
        $map[&#39;type&#39;]=$_REQUEST["type"];
        $list=$Region->where($map)->select();
        echo json_encode($list);
    }

Copy after login

2. [Code][HTML] Code Skip to [1] [2] [3] [4] [Full screen preview]

<select name="province" id="province" onchange="loadRegion(&#39;province&#39;,2,&#39;city&#39;,&#39;{:U(&#39;Index/getRegion&#39;)}&#39;);">
       <option value="0" selected>省份/直辖市</option><volist name="province" id="vo"> 
       <option value="{$vo.id}" >{$vo.name}</option></volist>
    </select>          
    <select name="city" id="city"  onchange="loadRegion(&#39;city&#39;,3,&#39;town&#39;,&#39;{:U(&#39;Index/getRegion&#39;)}&#39;);">
      <option value="0">市/县</option>
    </select>
<select name="town" id="town">
      <option value="0">镇/区</option>
    </select>

Copy after login

3. [Code][JavaScript]Code Jump to [1] [2] [3] [4] [Full screen preview]

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));
}
}
);
}
</script>

Copy after login

4. [Code][SQL]Code Jump to [1] [2] [ 3] [4] [Full screen preview]

DROP TABLE IF EXISTS `tp_tree`;
CREATE TABLE `tp_tree` (
 `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
 `pid` int(5) unsigned NOT NULL DEFAULT &#39;0&#39;,
 `name` varchar(120) DEFAULT NULL,
 `type` tinyint(1) DEFAULT &#39;2&#39;,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3410 DEFAULT CHARSET=utf8;

Copy after login

5. [File] TP_tree.sql ~ 215KB Download (7) [Full screen preview]

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn