高手過來看看！
<?php
namespace app\controllers;
use yii\web\Controller;
use app\models\Users;
class IndexController extends Controller{
public function actionIndex(){
//查詢數(shù)據(jù)
$sql = 'select * from users where id=1'; ? ? ? ? ? ? ? ? ?//一會兒將改這里
$results=Users::findBySql($sql)->all();
print_r($results);
}
}
查詢一次數(shù)據(jù)庫中users表后，刪掉users表，新建一個users1表，將上述代碼改為
<?php
namespace app\controllers;
use yii\web\Controller;
use app\models\Users;
class IndexController extends Controller{
public function actionIndex(){
//查詢數(shù)據(jù)
$sql = 'select * from users1 where id=1'; ? ? ? ? ? ? ? ? ?//這里做了改動
$results=Users::findBySql($sql)->all();
print_r($results);
}
}
刷新頁面為什么提示
Invalid Configuration – yii\base\InvalidConfigException
The table does not exist: {{%users}}
我明明要查詢users1了呀，為什么還查詢之前的users?
2015-09-23
請理解命名空間與use關(guān)鍵字的用法，將所改的那個文件改成這樣
<?php namespace?app\controllers; use?yii\web\Controller; use?app\models\Users1;????????????????????????????????????????//此處要變 class?IndexController?extends?Controller{ public?function?actionIndex(){ //查詢數(shù)據(jù) $sql?=?'select?*?from?users1?where?id=1';??????????????????//這里做了改動 $results=Users1::findBySql($sql)->all();????????????????????//此處要變 print_r($results); } }