省市县js联动/城市数据

http://www.17sucai.com/preview/776331/2017-12-20/city/index.html

tp5渲染出来

        // 省和市区
        $province = Db::connect('db_lite')->table('lxx_address')->where('class_type', 1)->field('class_id as id,class_name as name')->select();

        foreach ($province as $key => $value) {
            $province[$key]['city'] = DB::connect('db_lite')->table('lxx_address')->where('class_type', 2)->where('class_parent_id', $province[$key]['id'])->field('class_id as id,class_name as name')->select();
        }
        $this->assign('province', json_encode($province));
        // 区县
        $area = DB::connect('db_lite')->table('lxx_address')->where('class_type', 3)->field('class_id as id,class_name as name,class_parent_id as pid')->select();
        $this->assign('area', json_encode($area));
        return view('city');

    public function city($value = '')
    {
        // 省和市区
        $province = Db::name('address')->where('class_type', 1)->field('class_id as id,class_name as name')->select();
        foreach ($province as $key => $value) {
            $province[$key]['city'] = Db::name('address')->where('class_type', 2)->where('class_parent_id', $province[$key]['id'])->field('class_id as id,class_name as name')->select();
        }
        $this->assign('province', json_encode($province));
        // 区县
        $area = Db::name('address')->where('class_type', 3)->field('class_id as id,class_name as name,class_parent_id as pid')->select();
        $this->assign('area', json_encode($area));
        return view();
    }