Akelos Framework v1 forum archive. This forum is no longer maintained. To report bugs please visit https://github.com/akelos/akelos/issues

Akelos Programming: Using HasAndBelongsToMany (HABTM) relations

1 to 6 of 6

- CommentAuthorgamma
Hi,

I use the habtm relation to connect the model Movie and the model Actor over a 'actors_movies' table.

<code>
class Movie extends ActiveRecord
{
var $has_and_belongs_to_many = 'actors';

class Actor extends ActiveRecord
{
var $habtm = 'movies';
}
</code>

How do i access all actors who belongs to a movie (e.g. Matrix) and how do i create a new actor who belongs to a movie in the movie controller.
- CommentAuthorbhembree
I put a tutorial for implementing a simple many-to-many relationship up on the wiki. Take a look at it and see if it helps.
- CommentAuthorgamma
Thanks, it realy helps.
If i load a movie like $this->Movie->find($id), how can i access the related Actors. Do i have to load them manualy in the Object?
- CommentAuthorbhembree
Yes. You can use a statement like:

$this->Movie->actor->load();

If you put the above statement in your show() method for your movie_controller.php, you can then add the following code to your show.tpl file (or move it to a helper method if you like) :

<?php
foreach (array_keys ($Movie->actors) as $k {
$actor_name = $Movie->actors[$k]->gat('name');
}

This will put the name for the actor in the variable $actor_name and you can then display it using whatever method you like.

There may be a better way but this is what has worked for me so far.

How do i access all actors who belongs to a movie (e.g. Matrix)

we start with on actors:

$this->Actor->find('all');

include the movies

$this->Actor->find('all',array('include'=>'movies'));

restrict the set using conditions

$this->Actor->find('all',
          array('_movies.name'=>'Matrix'),
          array('include'=>'movies')
);

- CommentAuthorsuthern
FYI: There should be a closing single quote on the 'include the movies' section.

1 to 6 of 6

Akelos PHP Framework Forum