Model Association Not Correct

Question

I am few months old with CakePHP. This is first time I am trying CakePhp Association. I assume I am following almost all instruction but still my model doesn't seem to work.

This is simple 'User' and 'Profile' Model. Table Structure: User:
- id (Primary Key)
- name

Profile:
- id (primary key)
- role
- user_id (Reference Key)

Models: User:

class UserModel extends AppModel{
    var $name = 'User';
    public $hasOne = array(
        'Profile'
    );

}

Profile:

class ProfileModel extends AppModel{
    var $name = 'Profile';
    public $belongsTo = array('User'); } 

Controller: Users:

lass UsersController extends AppController{
    var $name = 'Users';
    public $scaffold;

    function index(){
        $user = $this->User->find('all'); //HERE I expect to get User and Profiles data
        pr($user);
    }

} 

Profiles:

 class ProfilesController extends AppController{
    var $name = 'Profiles';
    public $scaffold;

    function index(){
        $profile = $this->Profile->find('all');
        pr($profile);
    }

} 

If I run users: /localhost/test_php_apps/users/ I get:

Array (
    [0] => Array
        (
            [User] => Array
                (
                    [id] => 1
                    [name] => rohini
                )

        )

) 

I am wondering why 'Profile' data is not shown. I have manually added records in tables.

Further if I try in UsersController: $user = $this->User->Profile->find('all'); I get the following error:

Call to a member function find() on a non-object

My guess is something is wrong with setting up Associations. But not sure what is messing things up.

I know this is very basic question, but even after reading 10 to 15 related cases I don't seem to find the answer.

Any help will be much appreciated.

Answer 1

Do me a favor, change

class UserModel extends AppModel

to

class User extends AppModel

and

class ProfileModel extends AppModel

to

class Profile extends AppModel

and see if that helps when doing $user = $this->User->Profile->find('all'); in the UsersController.

Also, is

public $actsAs = array('Containable');

not

public $actAs = 'Containable';

not actAs. See if that helps any. If not, it would be helpful to know your cake version.

See here for containable and this for naming model conventions.

Answer 2

add the following lines in your usermodel

public $useTable = 'YOUR USERTABLENAME';

and change

public $hasOne = array(
        'Profile'
    );

to public $hasOne = 'Profile';

in your profilmodel add the same.

public $useTable = 'YOUR PROFILETABLENAME';

and change

public $belongsTo = array('User'); 

to

public $belongsTo = array('User' => array('className' => 'User',
                                          'foreignKey' => 'user_id'));

in your userscontontroller add this

public $uses = array('User','Profile');

normally it should work now when you try the query

$u = $this->User->find('all',array('contain' => array('Profile'));

or

$u = $this->User->find('all',array('recursive' => 2));

but it also should work if you write only:

$u $this->User->find('all');

regards

Answer 3

If you bake this things is made your life easier.

Models: User:

    class User extends AppModel{
        var $name = 'User';
        public $hasMany = array(
            'Profile'=>array(
                'className' => 'Profile',
                'foreignKey' => 'user_id',)
        );    
}

Profile:

class Profile extends AppModel{
    var $name = 'Profile';
            public $belongsTo = array(
        'User' => array(
            'className' => 'User',
            'foreignKey' => 'user_id',
        )
    );

}

Controller: Users:

    class UsersController extends AppController{
        var $name = 'User';        

        public function index(){
            $users = $this->User->find('all'); 
            var_dump($users);
        }

} 

Controller Profile:

    class ProfilesController extends AppController{
            var $name = 'Profile';        

            public function index(){
                $user_id = 2;
                $users = $this->Profile->find('all', array('conditions'=>array('Profile.user_id'=>$user_id))); 
                var_dump($users);
            }

    }