how to display array to CGridView (yii framework)

Question

I have next variables:

$type_model = ProductTypeModel::model()->findByPk($id);
$prod = $type_model->product;

Now in $prod:

array
(
    0 => ProductModel#1
    (
        [CActiveRecord:_new] => false
        [CActiveRecord:_attributes] => array
        (
            'product_id' => '6'
            'product_type_id' => '5'
        )
        ...
    )
    1 => ProductModel#2
    (
            'product_id' => '8'
            'product_type_id' => '5'
    )
    ...

How i can display my products in CGridView? Thx.

Rafay Zia Mir · Accepted Answer · 2014-02-10 09:29:28Z

1

I Suppose you are using CarrayDataProvider. So in your controller

$dataProvider = new CArrayDataProvider($prod);

Here $product could be any array you want to display in CgridView. Now In you view write this.

$gridColumns = array(
    array(
        'header' => 'First Name',
        'value' => 'ProductTypeModel::model()->findByPk($data->product_id)->key',
        'htmlOptions' => array('style' => 'text-align:center;')
    ),


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

As in CarrayDataprovider array is obtained so we cant use relations in it. Thats why u have to write 'ProductTypeModel::model()->findByPk($data->product_id)->key'
Here you can display anything attribute of ProductTypeModel so u can replace above mentioned key with your desired attribute

answered Feb 10, 2014 at 9:29

Rafay Zia Mir

2,1166 gold badges23 silver badges50 bronze badges

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

Comments

naveen goyal · Accepted Answer · 2014-02-10 09:23:05Z

0

Try this ... it automatic convert to array data provider.

$dataProvider=new CArrayDataProvider($type_model->product);

answered Feb 10, 2014 at 9:23

naveen goyal

4,6272 gold badges18 silver badges26 bronze badges

Comments

Pirr · Accepted Answer · 2014-02-10 10:18:33Z

0

Thanks all. By means of answers "naveen goyal" and "jailed abroad" i did like this:

$dataProvider=new CArrayDataProvider($type_model->product);
$dataProvider->keyField = 'product_id';
$this->widget('bootstrap.widgets.TbGridView', array(
    'dataProvider' => $dataProvider,
    'columns' => array(
        array(
            'header' => 'Title',
            'value' => 'CHtml::encode($data["product_title"])',
        ),

)));

Nice work for me.

answered Feb 10, 2014 at 10:18

Pirr

1231 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

how to display array to CGridView (yii framework)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related