How to make Yii2 handle two different instances of a dataprovider?

Question

This is siteController index.php. Here I want to display two list from different table on same page.But it display only one table data for both div.when I set only $dataProvider on both div widget and if I set $dataProvider2 which create in actionIndex() it get error $dataProvider2 not found.

                        <?= GridView::widget([
                        'dataProvider' => $dataProvider,
                        'columns' => [
                            ['class' => 'yii\grid\SerialColumn'],
                       [

                           'attribute'=>'practiceCode',
                           'format' => 'raw',
                           'value'=>function ($model, $index, $widget) {
                       },
                    ],
                    'firstName',

                        ],

              ]); ?>

            </div>
            <div class="col-lg-6" style="border:solid 1px;">
                <h2>Member</h2>
                <?= GridView::widget([
                        'dataProvider2' => $dataProvider2,//Error $dataProvider2 not found
                        'columns' => [
                            ['class' => 'yii\grid\SerialColumn'],
                       [

                           'attribute'=>'memberCode',
                           'format' => 'raw',
                           'value'=>function ($model, $index, $widget) {

                       },
                    ],
                    'firstName',
              ]); ?>    
            </div>

This is actionIndex() here i have write two dataProvider($dataProvider,$dataProvider2) But i am not able to set set this dataProvider in index.php widget

public function actionIndex()
    {
        $query = new \yii\db\Query;
        $query->select('*')
              ->from('practice');
        $query->createCommand();

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
            'pageSize' => 10,
             ],
        ]);
        $query = new \yii\db\Query;
        $query->select('*')
              ->from('member');
        $query->createCommand();

        $dataProvider2 = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
            'pageSize' => 10,
             ],
]);
        return $this->render('index', [
            'dataProvider' => $dataProvider,'dataprovider2'=>$dataProvider2 ]);
}

Double H · Accepted Answer · 2015-12-17T05:41:58.050

6

You Need to change dataProvider2 to dataProvider

<div class="col-lg-6" style="border:solid 1px;">
<h2>Member</h2>
<?= GridView::widget([
    'dataProvider' => $dataProvider2,//Error $dataProvider2 not found
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        [

            'attribute'=>'memberCode',
            'format' => 'raw',
            'value'=>function ($model, $index, $widget) {

            },
        ],
        'firstName',
    ]
]); ?>

Since dataProvider is a Property Of GridView .. It will works

And Change Your Controller Action as

return $this->render('index', [
        'dataProvider' => $dataProvider,'dataProvider2'=>$dataProvider2 ]);

edited Dec 17 '15 at 05:41

answered Dec 17 '15 at 05:27

Double H

4,120
1
15
26

Controller action is already return $this->render('index', [ 'dataProvider' => $dataProvider,'dataProvider2'=>$dataProvider2 ]); even I chande in div 'dataProvider' => $dataProvider2, but error still is Undefined variable: dataProvider2 – Priyanka Ahire Dec 17 '15 at 05:41
1

see your code you are using `['dataProvider' => $dataProvider,'dataprovider2'=>$dataProvider2 ]` Here you are using `dataprovider2` not `dataProvider2` – Double H Dec 17 '15 at 05:43
Click to accept this answer because it solved your problem ... Just below Answer upvote no. – Double H Dec 18 '15 at 05:26

How to make Yii2 handle two different instances of a dataprovider?

1 Answers1