Difference between #6 and #7 of
Accessing data in a join table with the related models

Revision #7 has been created by erikj on Jul 15, 2012, 12:39:42 PM with the memo:

Changing "moviesJoin" to "watched" since "moviesJoin" is not defined anywhere, making the script not work.
« previous (#6) next (#8) »

Changes

Title unchanged

Accessing data in a join table with the related models

Category unchanged

How-tos

Yii version unchanged

Tags unchanged

relations, active record, many_many, join table

Content changed

[...]
...
public function relations() {
return array(
'watched' => array(self::HAS_MANY, 'ViewerWatchedMovie', 'viewer_id'),
'movies' => array(self::HAS_MANY, 'Movie', 'movie_id',
'through' => 'moviesJoinwatched'),
...
```
[...]
To make it eager: `Viewer::model()->with('watched', 'movies')->findByPk($id)`.

I have it on [good authority](http://www.yiiframework.com/forum/index.php?/topic/8581-selecting-join-table-with-mant-to-many/page__st__40__p__123710__hl__creocoder#entry123710 "forum link") that the coherence of indexes of the two arrays `$viewer->moviesJoinwatched` and `$viewer->movies` is assured. But this fact (feature?) is not documented so it makes me nervous. That's why I prefer a variation.

Add a relation to the `ViewerWatchedMovie` model:

```php
class ViewerWatchedMovie extends CActiveRecord {
[...]
16 1
30 followers
Viewed: 146 523 times
Version: 1.1
Category: How-tos
Tags: active record, join table, many_many, relations
Written by: fsb
Last updated by: krowe
Created on: Dec 5, 2011
Last updated: 11 years ago
Update Article
Revert to #6 | Revert to #7

Revisions

View all history