PHP区域联动后端接口与数据表设计

灰太狼 2022-12-16 13:28 101阅读 0赞

### 控制器 ###

/**
         * 获取所有省份
         */
        public function getProv()
        {
            $data = $this->AreaModel->getProv();
            self::_return($data);
        }
    
        /**
         * 获取指定省份的城市
         */
        public function getCity()
        {
            $id = $_POST['id'];
            $data = $this->AreaModel->getCity($id);
            self::_return($data);
        }
    
        /**
         * 获取指定城市的区域
         */
        public function getArea()
        {
            $id = $_POST['id'];
            $data = $this->AreaModel->getArea($id);
            self::_return($data);
        }

### 模型 ###

/**
         * 获取所有省
         */
        public function getProv()
        {
            $cols = '`provid`, `prov`';
            $where = [];
            $order = '`orderby` ASC';
            return $this->table($this->prov)->cols($cols)->where($where)->order($order)->select()->fetchAll();
        }
    
        /**
         * 获取指定省份的城市
         */
        public function getCity($id)
        {
            $cols = '`cityid`, `city`';
            $where = ['provid' => $id];
            $order = '`orderby` ASC';
            return $this->table($this->city)->cols($cols)->where($where)->order($order)->select()->fetchAll();
        }
    
        /**
         * 获取指定城市的区域
         */
        public function getArea($id)
        {
            $cols = '`areaid`, `area`';
            $where = ['cityid' => $id];
            $order = '`orderby` ASC';
            return $this->table($this->area)->cols($cols)->where($where)->order($order)->select()->fetchAll();
        }

### 表格 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z1amlhbjk1NDQ_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z1amlhbjk1NDQ_size_16_color_FFFFFF_t_70]: /images/20221123/6404da5a3a374891a643be0927068ea8.png