How to display array data in Yii2 GridView using ActiveDataprovider

Question

I have an array of data very similar to this

$array = [
  'FUNDSCTR' => '10000001' 
  'RCMMTITEM' => 'R400001'
  'YEAR' => '2018'
  'CONSUMA' => 5898257
  'CONSUME' => 30140
  'AVAIL' => 5868117 ]

and use in ArrayDataProvider

 $dataProvider = new ArrayDataProvider(['allModels' => $array,]);

code in gridview

 <?= GridView::widget([
         'dataProvider' => $dataProvider,
         'columns' => [
                      ['class' => 'kartik\grid\SerialColumn'],
                        [
                            'label' => 'Year',
                            'attribute'=>'YEAR',
                        ],
                        [
                            'label' => 'Fund',
                            'attribute'=>'FUNDSCTR',
                        ],
                         [
                            'label' => 'Item',
                            'attribute'=>'RCMMTITEM',
                        ],
                         [
                            'label' => 'Consumeable',
                            'attribute'=>'CONSUMA',
                        ],
                         [
                            'label' => 'Consumed',
                            'attribute'=>'CONSUME',
                        ],
                        [
                            'attribute'=>'Available',
                            'value'=> 'AVAIL',
                        ],
                    ]);
                ?>
      </div>

resluts

print_r($dataProvider); ~ $arrays return

yii\data\ArrayDataProvider Object ( [key] => [allModels] => Array ( [RFUNDSCTR] => 10000001 [RCMMTITEM] => R400013 [RYEAR] => 2018 [CONSUMA] => 5898257 [CONSUME] => 30140 [AVAIL] => 5868117 )

I need to show in gridView data like this.

Andrii Filenko · Accepted Answer · 2019-02-23 18:36:55Z

2

To work properly, an array which you pass to ArrayDataProvider should be two-dimensional, like this:

$array = [
    [
        'FUNDSCTR' => '10000001',
        'RCMMTITEM' => 'R400001',
        'YEAR' => '2018',
        'CONSUMA' => 5898257,
        'CONSUME' => 30140,
        'AVAIL' => 5868117,
    ],
    [
        'FUNDSCTR' => '10000001',
        'RCMMTITEM' => 'R400001',
        'YEAR' => '2018',
        'CONSUMA' => 5898257,
        'CONSUME' => 30140,
        'AVAIL' => 5868117,
    ],
    [
        'FUNDSCTR' => '10000001',
        'RCMMTITEM' => 'R400001',
        'YEAR' => '2018',
        'CONSUMA' => 5898257,
        'CONSUME' => 30140,
        'AVAIL' => 5868117,
    ]
];

answered Feb 23, 2019 at 18:36

Andrii Filenko

9847 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display array data in Yii2 GridView using ActiveDataprovider

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related