How to create grid in yii with custom array?

Question

I have created an array in php.

    Array
    (
        [0] => Array
            (
                [ip_addr] => 152.12.40.205
                [Management_col-2] => Success
                [Management_col-3] => Success
            )

    [1] => Array
        (
            [ip_addr] => 152.12.40.206
            [Management_col-2] => Success
            [Management_col-3] => Error
        )

    [2] => Array
        (
            [ip_addr] => 152.12.40.207
            [Management_col-2] => NA
            [Management_col-3] => Success
        )

    [3] => Array
        (
            [ip_addr] => 152.12.40.209
            [Management_col-2] => Success
            [Management_col-3] => Success
        )
);

I will have dynamic columns like ip_addr, Management_col-2, ....and so on with there respective dynamic values.

I want to use it in Grid view of YII.

    $nc3DataProvider = new CArrayDataProvider($alldata);


    $this->widget('zii.widgets.grid.CGridView', array(
    'id' => 'nc3-audit-grid',
    'dataProvider' => $nc3DataProvider,

));

I also want to use filter on the table.

Plz help me for this.

Thank you so much in advance.

@EdvinTenovim Can you plz give answer for yii2, I will try to make it in yii — Amol
– Amol, Commented Jul 17, 2016 at 9:37

ScaisEdge · Accepted Answer · 2016-07-17 19:23:38Z

1

You can use CArrayDataProvider this a sample

Controller

public function actionGridViewArray() {
 $rawData=array(
         array('id'=>1, 'username'=>'from', 'email'=>'array'),
         array('id'=>2, 'username'=>'test 2', 'email'=>'[email protected]'),
     );

     // or using: $rawData=User::model()->findAll();
     $arrayDataProvider=new CArrayDataProvider($rawData, array(
         'id'=>'id',
         /* 'sort'=>array(
             'attributes'=>array(
                 'username', 'email',
             ),
         ), */
         'pagination'=>array(
             'pageSize'=>10,
         ),
     ));
     $params =array(
         'arrayDataProvider'=>$arrayDataProvider,
     );
     if(!isset($_GET['ajax'])) $this->render('grid_view_array', $params);
     else  $this->renderPartial('grid_view_array', $params);
 }

View (gridview)

$this->widget('zii.widgets.grid.CGridView', array(
    'dataProvider' => $arrayDataProvider,
    'columns' => array(
        array(
            'name' => 'username',
            'type' => 'raw',
            'value' => 'CHtml::encode($data["username"])'
        ),
        array(
            'name' => 'email',
            'type' => 'raw',
           'value' => 'CHtml::link(CHtml::encode($data["email"]), "mailto:".CHtml::encode($data["email"]))',
        ),
    ),
));

And buildin the column dinamically

foreach ($header as $cols){ 
   $column[] = array( 'name'=> $cols, 
   'value'=>'isset($data[\''.$cols.'\'])?$data[\''.$cols.'\']:""', ); 
}


$this->widget('zii.widgets.grid.CGridView', array(
    'dataProvider' => $arrayDataProvider,
    'columns' => $column
));

edited Jul 17, 2016 at 19:23

answered Jul 17, 2016 at 11:02

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

6 Comments

Amol Over a year ago

I have dynamic columns in grid, it can be change, its name and number columns too with its value. So how can i implement it? Here u have taken only username and email in columns array.

ScaisEdge Over a year ago

this seems another answer .. anyway you can set the dataProvider based in your dinamic array and also you can use a var for the column and you can build the var with the columns coniguration as you need .. but this i repeart seems another question to me ..

Amol Over a year ago

foreach ($header as $cols){     $column[] =           array(             'name'=> $cols,             'value'=>'isset($data[\''.$cols.'\'])?$data[\''.$cols.'\']:""',              ); }

I have used this to set columns in grid: 'columns' => $column, Its makes my work done.. Thanxs for ur support @scaisEdge

ScaisEdge Over a year ago

I have update the answer with a suggestion based on your comment

ScaisEdge Over a year ago

Well then is that you are looking for?

|

Collectives™ on Stack Overflow

How to create grid in yii with custom array?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related