query是个组件,用来生成sql语句,
开启这个组件,在config/web.php的components中配置
'q'=>'yii\db\Query',然后再控制器中调用即可
<?php namespace app\controllers; use app\entry\BasicUser; use yii\db\Query; use yii\web\Controller; class DataController extends Controller{public function actionQuery(){ /* $res=\yii::$app->q->select('username') ->from('test')->where('id=5') ->createCommand()->queryAll(); echo json_encode($res); $res=(new Query())->select('username') ->distinct(true)->from('test') ->createCommand()->queryAll(); $res=(new Query())->select('username') ->from('test')->count('username'); $res=(new Query())->select('*') ->from('test')->limit(10) ->offset(0)->orderBy('rest ') ->createCommand()->queryAll(); */ $res=(new Query())->select('username') ->from('test')->groupBy('username') ->createCommand()->queryAll(); echo json_encode($res); } }