how to get CakePHP many-to-many result

Question

I have a many-to-many relation between the models Image and Units using a images_units join table.

How can I translate this query to a cakePHP find()?

SELECT * FROM Image, Units, images_units WHERE images_units.unit_id = 29;

Right now I'm trying find() on Image->find('all', $params); with no luck.

That query won't work anyway, you're not looking at the join tables at all. — Dunhamzzz
– Dunhamzzz, Commented Mar 24, 2011 at 15:58

YOMorales · Accepted Answer · 2011-03-24 17:37:36Z

1

Straight from the CakePHP Manual:

$this->Image->bindModel(array('hasOne' => array('ImagesUnit')));
$this->Image->find('all', array('fields' => array('Image.*'),'conditions' => array('ImagesUnit.unit_id' => 29)));

Of course, you will need to have the HABTM association defined in the model. See the whole section on HABTM for learning how to use it.

answered Mar 24, 2011 at 17:37

YOMorales

1,9862 gold badges15 silver badges25 bronze badges

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

4 Comments

Lars C. Magnusson Over a year ago

Thanx alot! Exactly what I was looking for:) I'll have a look at the documentation.

Lars C. Magnusson Over a year ago

Insted of binding the model in the controller, you can also do it in the model using: var $hasOne = 'ImagesUnit'; Which means you can skip that first line: $this->Image->bindModel(array('hasOne' => array('ImagesUnit')));

YOMorales Over a year ago

Oh yeah, indeed. There are a few 'best practices' that I've come up with (not necessarily the community's best practices), and one of them is to define such association in the model and never bind it on the fly. If you need to deal with a model that is not associated, then you can use the loadModel method. And I always recommend to drop the recursive functionality and opt instead for the Containable behavior. This ebook explains this Containable technique.

YOMorales Over a year ago

I just realized that the link to downloading the e-book is broken. Here is a new link: pseudocoder.com/Super_Awesome_Advanced_CakePHP_Tips.pdf

Nick · Accepted Answer · 2011-03-24 17:38:08Z

0

In your Image Model, add the following code:

$hasAndBelongsToMany = 'Unit';

The find() in your Images controller should look like this:

$this->Image->find('all', array('conditions'=>array('Unit.id'=>29)));

Still not quite sure this is what you're looking for but I think this is correct.

answered Mar 24, 2011 at 17:38

Nick

1,3312 gold badges10 silver badges28 bronze badges

1 Comment

Lars C. Magnusson Over a year ago

Tried that, gave med "SQL Error: 1054: Unknown column 'Unit.id' in 'where clause'" on Query: SELECT Image.id, Image.name, Image.url FROM images AS Image WHERE Unit.id = 30

Collectives™ on Stack Overflow

how to get CakePHP many-to-many result

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related