Yii中控制器中的呼叫模型方法

Question

Hello Friends I am new to Yii2 Framework.

i am writing following code as specified in mention filename still....

While i am calling model method then does not showing output showing 500 error in console

Is Any Mistake in code then please mention here ..

SiteController.php

<?php

use yii\web\Controller;
use yii\data\Pagination;
use app\models\Site;

class SiteController extends CController
{
    // Define an action. actionIndex is a default action
    public function actionIndex()
    {   
        $data =  Site::models()->getData();    
        $this->render('view',array(
        'data'=>$data,
        ));

        // $this->render('view');
        }
  }

Site.php - Model

<?php
namespace app\models;

use yii\db\ActiveRecord;

    class Site extends ActiveRecord
    {
        public function getData() {
              $connection = Yii::app()->db;
              $command = $connection->createCommand("Select * from site");
              return $caterow = $command->queryAll();
        }
        public static function tableName()
        {
            return 'site';
        }
    }

Answer 1

hello friends, First Thanks to all to help me now i am sharing this code this is complete now work in mycase.

i had sorted out this problem with following code. Try this one now its completely work

main.php

    <?php

// This is the main config file
// You should avoid placing configuration everywhere else
return array(
    // We have to enable Yii to load all the files we created
    'import'=>array(
        'application.models.*',
        'application.views.*',
                'application.components.*'
    ),

    // We set up SQLite database connection. It's a simple database
    // which does not require a separae server
    'components'=>array(
        'db'=>array(
            'class'=>'CDbConnection',
            'connectionString'=>'mysql:host=localhost;dbname=student',
            'username'=>'root',
            'password'=>'',
            'emulatePrepare'=>true,
            ),
    )
);

SiteController.php

<?php

class SiteController extends CController
{
    /**
     * Lists all models.
     */
    public function actionIndex()
    {
                $s = new Site();
                $a = $s->getData();
        $this->render('view',array('a'=>$a));
    }

}

Site.php - Model

<?php

class Site extends CActiveRecord
{
    /**
     * Returns the static model of the specified AR class.
     * @return static the static model class
     */
    public static function model()
    {
        return parent::model('Site');
    }

    /**
     * @return string the associated database table name
     */
    public function tableName()
    {
        return 'site';
    }

        public function getData(){
            return $result =  Site::model()->find();
        }


}