访问yii2中模型类的数据



在yii2中,我有一个用gii工具构建的控制器和模型。然而,当我从控制器调用模型函数时,它会给出一个错误。

PHP Fatal Error 'yiibaseErrorException' with message 'Class 'backendcontrollersTargetCities' not found' 
in C:xampphtdocsncddpbackendcontrollersTargetCitiesController.php:15
Stack trace:
#0 [internal function]: yiibaseErrorHandler->handleFatalError()
#1 {main}

这是我的管理员。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。

<?php
namespace backendcontrollers;
class TargetCitiesController extends yiiwebController
{
    public function actionIndex()
    {
        return $this->render('index');
    }
    function actionGetcities()
    {
    $prov_code = $_POST['prov_code'];
     $cities = TargetCities::model()->get_cities($prov_code);
     echo $cities;
    }
}

这是我的模型。。。。。。。。。。。。。。。。。。。

<?php
namespace appmodels;
use Yii;
/**
 * This is the model class for table "tbl_target_cities".
 *
 * @property integer $id
 * @property string $city_code
 * @property string $kc_classification
 * @property integer $cluster
 * @property integer $grouping
 * @property string $priority
 * @property integer $launch_year
 */
class TargetCities extends yiidbActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'tbl_target_cities';
    }
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['city_code', 'kc_classification', 'cluster', 'grouping', 'priority', 'launch_year'], 'required'],
            [['cluster', 'grouping', 'launch_year'], 'integer'],
            [['city_code'], 'string', 'max' => 20],
            [['kc_classification', 'priority'], 'string', 'max' => 100],
            [['city_code'], 'unique']
        ];
    }
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'city_code' => 'City Code',
            'kc_classification' => 'Kc Classification',
            'cluster' => 'Cluster',
            'grouping' => 'Grouping',
            'priority' => 'Priority',
            'launch_year' => 'Launch Year',
        ];
    }

    public function get_cities(){
        $select = "SELECT * FROM lib_cities where prov_code=$prov_code";
        $query = Yii::app()->db->createCommand($select)->queryAll();
        return $query;
    }
}

您丢失的use appmodelsTargetCities。因为你在Php。如果您没有为TargetCities模型Php设置use ...,请在"backend\controllers"命名空间中找到它类,但它找不到。像这样添加controller

use appmodelsTargetCities;
class TargetCitiesController extends yiiwebController
{

编辑。

您使用Yii1样式而不是Yii2。在Yii2中不是方法model()。控制器中正确:

function actionGetcities()
    {
    $prov_code = $_POST['prov_code'];
     $cities = TargetCities::get_cities($prov_code);
     echo $cities;
    }

在模型TargetCities中,将get_cities声明为static,并将Yii::app()更改为Yii::$app,如下所示:

public static function get_cities(){
        $select = "SELECT * FROM lib_cities where prov_code=$prov_code";
        $query = Yii::$app->db->createCommand($select)->queryAll();
        return $query;
    }

阅读不同Yii2和Yii2的文档-http://www.yiiframework.com/doc-2.0/guide-intro-upgrade-from-v1.html

最新更新