About Relational AR

Archives Yii 1.0.x Discussions
1

Here is example from guide



class User extends CActiveRecord


{


    public function relations()


    {


        return array(


            'posts'=>array(self::HAS_MANY, 'Post', 'authorID'


                            'order'=>'??.createTime DESC',


                            'with'=>'categories'),


            'profile'=>array(self::HAS_ONE, 'Profile', 'ownerID'),


        );


    }


}

i'm trying to get the same result. i've news category, news list and authors. i select some category and i need to load all news with authors.

where i need to put authors relations? in news ar model?

here is my code:

category relations

'newslist'=>array(self::MANY_MANY, 'news', 'NewsCategory(categoryId, newsId)','with'=>'author')

news relations

'author'=>array(self::BELONGS_TO, 'Users', 'authorId')

but i get only selected category with news and without authors…

P.S.

sry for bad english  ;D

2

this variant does'n work for me too

$posts=Category::model()->with(array('newslist' => array('with' => 'author')))->find($criteria);
3

I think, this has been changed in 1.0.2 to:

$posts=Category::model()->with('newslist.author')->find($criteria);
4

well, maybe yes, but i need to load newslist and newslist.author

5

You get both with the statement above.

<?php


foreach ($posts as $post) {


  echo $post->newslist->name;


  echo $post->newslist->author->name;


}

But your relations have to be correct first, of course. Didn’t have a look at them ;)

6

WOW!!! great, it’ working!!  :D

many thanks!!

7

mmm… and how can i set wich fields to select?

8

Have a look at CActiveRecord::with() API doc, there’s an example.