控制器;$sql="select pl_id,pl_content,pl_time,news_title,username from news join pinglun on news_id=pinglun.pl_int join users on id=pl_person order by pl_id desc";
$datas=Yii::app()->db->createCommand($sql)->queryAll();
$dataProvider = new CActiveDataProvider($datas);
$this->render('index',array(
'dataProvider'=>$dataProvider,
));
视图;<?php
$this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'pager'=>array( //通过pager设置样式 默认为CLinkPager
'prevPageLabel'=>'上一页',
'firstPageLabel'=>'首页', //first,last 在默认样式中为{display:none}及不显示,通过样式{display:inline}即可
'nextPageLabel'=>'下一页',
'lastPageLabel'=>'末页',
'header'=>'',
),
'ajaxUpdate'=>false,
'columns'=>array(
array(
'selectableRows' => 2,
'footer' => '<input type="checkbox" id="cbCheckAll" onclick="checkAll(this);"/><label for="cbCheckAll">全选</label>',
'class' => 'CCheckBoxColumn',
'headerHtmlOptions' => array('width'=>'50px'),
'checkBoxHtmlOptions' => array('name' => 'selectdel[]')
),
array(
'name'=>'编号',
'type'=>'raw',
'value'=>$data['pl_id'],
),
array(
'name'=>'评论者',
'type'=>'raw',
'value'=>$data['username'],
),
array(
'name'=>'评论内容',
'type'=>'raw',
'value'=>Helper::truncate_utf8_string($data['pl_content'],9,false),
),
array(
'name'=>'评论时间',
'type'=>'raw',
'value'=>$data['pl_time'],
),
array(
'class'=>'CButtonColumn',
),
),
));
?>
报错……Fatal error: Call to a member function getDbCriteria() on a non-object in D:\APMServ5.2.6\www\htdocs\yii\framework\web\CActiveDataProvider.php on line 173
什么原因呢?请大家帮忙解决下。