CArrayDataProvider how to create view

Yii 1.1 General Discussion
1

Kindly help me in the following code. I am trying to fetch data by filling it an array and then sending it to CListView using ArrayDataProvier. But I dont know how to handle the view:

ControllerFunction:

public function actionIndex()

{


	$connection=Yii::app()->db;


    $user = Yii::app()->user->getId();


    $rows= $connection->createCommand()->select('*')->from('tbl_project_user_assignment')

->where(‘user_id=:id’,array(’:id’=>Yii::app()->user->getId()))->queryAll();

    //$rows=$command->execute();


    foreach($rows as $row){


        //process each item here


        $pid=$row['project_id'];


        //echo $pid;


        $rows2= Yii::app()->db->createCommand()->select('*')->from('tbl_project')

->where(‘id=:pid’,array(’:pid’=>$pid))->queryAll();

        //$rows2=$command2->execute();


        $arr=array();


        $i=0;


        foreach($rows2 as $row) {


            $arr=array(


                $i=>array(


                    'id'=>$row['id'],


                    'name'=>$row['name'],


                    'description'=>$row['description'],


                    'create_time'=>$row['create_time'],


                    'create_user_id'=>$row['create_user_id'],


                    'update_time'=>$row['update_time'],


                    'update_user_id'=>$row['update_user_id']


                ),


            );


            $i++;


        }


    }


    


    $dataProvider=new CArrayDataProvider([


        'allModels' => $arr,


        'pagination' => [


            'pageSize' => 10,


        ],


        'sort' => [


            'attributes' => ['id', 'name'],


        ],


    ]);


	$this->render('index',array(


		'dataProvider'=>$dataProvider,


	));


}

index.php file:

<?php

$this->widget(‘zii.widgets.CListView’, array(

'dataProvider'=&gt;&#036;dataProvider,


'itemView'=&gt;'_view',


));


?&gt;

_view file:

<?php

/* @var $this ProjectController */

/* @var $data Project */

?>

<div class="view">

&lt;b&gt;&lt;?php //echo CHtml::encode(&#036;data-&gt;getAttributeLabel('id')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::link(CHtml::encode(&#036;data-&gt;id), array('view', 'id'=&gt;&#036;data-&gt;id)); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('name')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;name); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('description')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;description); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('create_time')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;create_time); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('create_user_id')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;create_user_id); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('update_time')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;update_time); ?&gt;


&lt;br /&gt;





&lt;b&gt;&lt;?php echo CHtml::encode(&#036;data-&gt;getAttributeLabel('update_user_id')); ?&gt;:&lt;/b&gt;


&lt;?php echo CHtml::encode(&#036;data-&gt;update_user_id); ?&gt;


&lt;br /&gt;

</div>