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

控制器

    /**
     * 获取所有省份
     */
    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();
    }

表格