Eloquent Relationship with 3 tables(User > Albums > Photos)

Try to fix your models by using a singular name for each class and check also the namespaces:

namespace YourModelsNamespace;

class User extends Eloquent
{
    protected $table = 'users';

    public function albums()
    {
         return $this->hasMany('YourModelsNamespace\Album');
    }
}

namespace YourModelsNamespace;

class Album extends Eloquent
{
    protected $table = 'albums';

    public function photos()
    {
         return $this->hasMany('YourModelsNamespace\Photo');
    }
}

namespace YourModelsNamespace;

class Photo extends Eloquent
{
    protected $table = 'photos';
}

And use the load() method to eager load the relationships:

@foreach(Auth::user()->load('albums', 'albums.photos')->albums as $album)
    {{ $album->name . ' (' . $album->photos->count() . ')' }} 
@endforeach

Hi ARCANEDEV,

I tried your solution but am getting an error

Illuminate\Database\Query\Builder::photos()

And am using LARAVEL 4.2

Ok, try to dd() the $album and check if it is an instance of Album class and has the photos Collection in relationships attribute.

For more details, check the docs:

• http://laravel.com/docs/4.2/eloquent#one-to-many
• http://laravel.com/docs/4.2/eloquent#eager-loading

Note: In laravel 4.2, you need to check how to use the autoloading & namespacing the classes.

I checked but could n't find photos in list :(

When I tried Albums::find(static id)->photos->count in controller, it worked well