passing an array from an user defined action in controller to a view in Yii

Question

In my Yii application I need to perform joint queries in controller and display the final view in views. this is the mysql query I need to perform.I hav three tables namely,items,manufacturers,items_manufacturers

SELECT items.id,item_desc,manufacturers.id,manufacturers.name FROM items_manufacturers,items,manufacturers WHERE items_manufacturers.item_id=item.id AND items_manufacturers.manufacturer_id=manufacturers.id.

The relation between the models is

public function relations()
    {

            'item' => array(self::BELONGS_TO, 'Items', 'item_id'),
            'manufacturer' => array(self::BELONGS_TO, 'Manufacturers', 'manufacturer_id'),
            'itemsManufacturersLocations' => array(self::HAS_MANY, 'ItemsManufacturersLocations', 'items_manufacturer_id'),
        );

This is the Query I performed in the controller

public function actionJoint()
{

        $imf=ItemsManufacturers::model()->with('item','manufacturer')->findAll();
    $this->render('joint',array(
    'imf'=>$imf
    ));

}

This is the code I implemented in the view

<?php



$this->breadcrumbs=array(
    'joint',  
);
$this->menu=array(
    array('label'=>'Create ItemsManufacturers', 'url'=>array('create')),
    array('label'=>'Manage ItemsManufacturers', 'url'=>array('admin')),
);
?>
<h1> List Items and Manufacturers </h1>
<?php 
$this->widget('zii.widgets.CListView',array(
 'dataProvider'=>$imf,
'itemView'=>'_jointview',
)); ?>

My code for the render of partial of view

    <?php
   /* @var $this ItemsManufacturersController */
/* @var $data ItemsManufacturers */
    ?>

    <div class="view">



        <b><?php echo CHtml::encode($data->getAttributeLabel('item_desc')); ?>:</b>
        <?php echo CHtml::encode($data->item_desc); ?>
        <br />

        <b><?php echo CHtml::encode($data->getAttributeLabel('name')); ?>:</b>
        <?php echo CHtml::encode($data->name); ?>
        <br />




</div>

But I am getting this error which I am unable to rectify.. Anybody help me with this.

Fatal error: Call to a member function getData() on a non-object in /var/www/yii_framework/framework/zii/widgets/CBaseListView.php on line 107

Any body help me how should I proceed since I am a newbie

You understand the $imf in your case is an array of results, this is what findAll() returns, its not an object. Which is probably why you are getting an error, Call to member function on a non object. I think that CListView expects the dataprovider to be a CDataProvider instance, not an array of results. Look at the SQL functions and find one that returns the CDataProvider then pass that to the widget. — Daryl B
– Daryl B, Commented Dec 3, 2013 at 6:43
In my previous comment when i say Array of results, i mean an array of CActiveRecord because you used the static function Class::model()-> — Daryl B
– Daryl B, Commented Dec 3, 2013 at 6:52

Muhammad Rizwan Kaim Khani · Accepted Answer · 2013-12-05 05:26:03Z

2

I think you are doing mistake on view listing code.

<?php
$this->breadcrumbs=array(
    'joint',  
);
$this->menu=array(
    array('label'=>'Create ItemsManufacturers', 'url'=>array('create')),
    array('label'=>'Manage ItemsManufacturers', 'url'=>array('admin')),
);
?>
<h1> List Items and Manufacturers </h1>
<?php 
$this->widget('zii.widgets.CListView',array(

'dataProvider'=>$dataProvider,,
'itemView'=>'_jointview',
)); ?>

Now you change your actionJoint() method in your controller.

public function actionJoint()
{

 $imf=ItemsManufacturers::model()->with('item','manufacturer')->findAll();

 $dataProvider=new CArrayDataProvider($imf, array(
 'id'=>'ItemsManufacturers',
 'sort'=>array(
    'attributes'=>array(
         'item_desc', 'name'
    ),
 ),
 'pagination'=>array(
    'pageSize'=>10,
 ),));

 $this->render('joint',array('dataProvider'=>$dataProvider));       

}

Now on _joinview page.

check print_r($data); then retrieve data according to your need.

Now it is fine.

Hope it will help you.

Thanks

edited Dec 5, 2013 at 5:26

answered Dec 3, 2013 at 9:46

Muhammad Rizwan Kaim Khani

2,1003 gold badges30 silver badges39 bronze badges

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

4 Comments

user2492854 Over a year ago

thks.. But,I am getting the same error I was getting before "Fatal error: Call to a member function getData() on a non-object in /var/www/yii_framework/framework/zii/widgets/CBaseListView.php on line 107"

user2492854 Over a year ago

Thanks a ton.. I am almost near .. but its showing an empty list.Its not displaying the results.

user2492854 Over a year ago

ya its working thk u very much . On a side note to render a controller's action two view's would be sufficient right? One for displaying the index of records and another for displaying the individual .I am unabe to make out what is the purpose of the partial like "_view". We find three views generally index,view _view. Could You please tell me what is that?

Muhammad Rizwan Kaim Khani Over a year ago

first it depends on you how many views you want. Secondly when we use CRUD or gii code generator then it will make three different views file i.e. index, view and _view. but index file just redirect it to _view page and show all the listing and view will show individual record.

Collectives™ on Stack Overflow

passing an array from an user defined action in controller to a view in Yii

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related