首页 > Web开发 > 详细

php 地区三级联动

时间:2020-06-17 18:42:57      阅读:61      评论:0      收藏:0      [点我收藏+]
/**
     * Notes:省市级联动
     * Created by xxg@seabig.cn
     * Date: 2020/6/4
     * Time: 17:24
     */
    public function getCityData()
    {
        $cityList = $this->getAll(array("pid = 1"));
        $data = array();
        foreach ($cityList as $v) {
            $data[$v[‘id‘]] = array(
                "id" => $v[‘id‘],
                "name" => $v[‘name‘],
                "subList" => array()
            );
            //获取二级
            $cityTow = $this->getAll(array("pid = {$v[‘id‘]}"));
            foreach ($cityTow as $l) {
                $data[$v[‘id‘]][‘subList‘][$l[‘id‘]] = array(
                    "id" => $l[‘id‘],
                    "name" => $l[‘name‘],
                    "subList" => array()
                );
                //获取三级
                $cityThree = $this->getAll(array("pid = {$l[‘id‘]}"));
                foreach ($cityThree as $t) {
                    $data[$v[‘id‘]][‘subList‘][$l[‘id‘]][‘subList‘][] = array(
                        "id" => $t[‘id‘],
                        "name" => $t[‘name‘]
                    );
                }
            }
        }
        //格式化数据
        $res = array();
        foreach ($data as $val) {
            $item = array();
            foreach ($val[‘subList‘] as $v) {
                $item[] = $v;
            }
            $res[] = array(
                ‘id‘ => $val[‘id‘],
                ‘name‘ => $val[‘name‘],
                ‘subList‘ => $item
            );
        }
        return $res;
    }

数据库表:

链接:https://pan.baidu.com/s/1L29fBe2EHblJbmBuzf38Ng 

提取码:6ch0

数据返回结果: 

技术分享图片

 

 

技术分享图片

 

php 地区三级联动

原文:https://www.cnblogs.com/xiangangXu1997/p/13153804.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!