I can not display total number of data. I have one field, name "record", I want to display total records. Can any one help me?
This is my view file
<?php $this->widget(‘zii.widgets.grid.CGridView’, array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'id',
'name',
[b]'records_id',[/b]
'note',
),
)); ?>
Controller
public function actionView()
{
$dataProvider=new CActiveDataProvider('info', array(
'criteria'=>array(
'condition'=>'User_id =' .Yii::app()->user->id,
),
'pagination'=>array(
'pageSize'=>self::PAGE_SIZE,
),
));
$this->render('view',array(
'dataProvider'=>$dataProvider,
));
}
This is my sql command
SELECT count( records_id ) FROM info
WHERE records_id IS NOT NULL AND User_id = 12 GROUP BY records_id