yii2.0一些重要但不常用知识点

1，原生sql语句写法；

$query = new \yii\db\Query(); $query->select(['el.id','el.member_id','el.be_member_id','el.time']) ->from('tp_each_like as el') ->where($condition)->orderBy('time desc'); //分页 $pages = new Pagination([ 'totalCount' => $query->count(), 'pageSize' => '10' ]); //数据 $elData = $query->offset($pages->offset) ->limit($pages->limit) ->all(); //$a = $query->createCommand()->getRawSql();(可以打印sql语句)//var_dump($a); //总个数 $total = $pages->totalCount;