data provider not found error

ashoo333 · April 20, 2016, 7:07am

Can anybody tell me what is the possible solution for the following code. It is giving me error that class CArrayDataProvider is not found.Although I have included the class on the top of the code:

use yii\framework\web\CArrayDataProvider;

Code:

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

    &#036;user = Yii::app()-&gt;user-&gt;getId();


    &#036;rows= &#036;connection-&gt;createCommand()-&gt;select('*')-&gt;from('tbl_project_user_assignment')-&gt;

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

    //&#036;rows=&#036;command-&gt;execute();


    foreach(&#036;rows as &#036;row){


        //process each item here


        &#036;pid=&#036;row['project_id'];


        //echo &#036;pid;


        &#036;rows2= Yii::app()-&gt;db-&gt;createCommand()-&gt;select('*')-&gt;from('tbl_project')-&gt;

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

        //&#036;rows2=&#036;command2-&gt;execute();


        &#036;arr=array();


        &#036;i=0;


        foreach(&#036;rows2 as &#036;row) {


            &#036;arr=array(


                &#036;i=&gt;array(


                    'id'=&gt;&#036;row['id'],


                    'name'=&gt;&#036;row['name'],


                    'description'=&gt;&#036;row['description'],


                    'create_time'=&gt;&#036;row['create_time'],


                    'create_user_id'=&gt;&#036;row['create_user_id'],


                    'update_time'=&gt;&#036;row['update_time'],


                    'update_user_id'=&gt;&#036;row['update_user_id']


                ),


            );


        }


    }


    &#036;dataProvider=new CArrayDataProvider([


        'allModels' =&gt; &#036;arr,


        'pagination' =&gt; [


            'pageSize' =&gt; 10,


        ],


        'sort' =&gt; [


            'attributes' =&gt; ['id', 'name'],


        ],


    ]);


	&#036;this-&gt;render('index',array(


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


	));

phtamas · April 20, 2016, 9:03am

You are trying to use yii\framework\web\CArrayDataProvider class which doesn’t exist. Yii 1.x branch predates PHP 5.3 and therefore isn’t namespaced. Just remove the use statement.

Also note that “use” statements don’t “include” or autoload anything, you need an actual autoloader implementation for that. (For core and application classes Yii 1 has a built in autolading mechanism, only 3rd party libraries may require additional steps.)

softark · April 20, 2016, 1:51pm

[color="#006400"]/* Moved from "2.0" to "1.1" */[/color]