Query Builder and CListView

Yii 1.1 General Discussion
1

Is it possible to use the data returned by a query, that was builed using the Query Builder funtion, in a CListView?

it would be nice to use the pagaing and stuff of the CListView…

2

You need a dataProvider, so you can use the CSqlDataProvider





$sql = Yii::app()->db->createCommand()

    ->select('*')

    ->from('tbl_user')

    ->text;


$count=Yii::app()->db->createCommand('SELECT COUNT(*) FROM tbl_user')->queryScalar();


$dataProvider=new CSqlDataProvider($sql, array(

    'totalItemCount'=>$count,

    'sort'=>array(

        'attributes'=>array(

             'id', 'username', 'email',

        ),

    ),

    'pagination'=>array(

        'pageSize'=>10,

    ),

));


//render the view with the CListView

$this->render('index',array('dataProvider'=>$dataProvider));