help filtering data in cakephp

Question

Im new to cakephp and Im having a little problem querying data. I have a User model and a Product model in a many to many relation.

What I what is simply for my Products/Index action to only get the products associated to that User (the user is stored in session) and not all Products (which is what it does by default).

Please help.

Answer 1

This should do the trick:

$products = $this->Product->find('all', array(
    'conditions' => array(
        'User.id' => $user_id_from_session
    )
));

Answer 2

You only need to set up the relationship properly, the rest is automatic.

Model:

class User extends AppModel {
    var $hasAndBelongsToMany = array(
        'Product' => array( /* set up relationship */ )
    );
}

Controller:

$this->User->recursive = 2; // just to make sure, shouldn't be necessary
$user = $this->User->read(null, $userId);

debug($user);
/**
 * $user['User'] contains the user data
 * $user['Product'] contains associated products
 */