Discussion Comment User relationship

Does this one help? http://laravel.com/docs/4.2/eloquent#has-many-through

Hi Alfrednutile,

even if i use hasManyThrough relationship how will i fetch userdetails ?

how to change profile picture here :) i tried going to my profile but no option to upload avatar....!!!

Cheers...!!! HLonare

What you need is many through many, look at this post

For avatar it's just linked to profil email and gravatar.

Just remove user_id from pivot table. User is the comment writer, so user_id shouldBe a property of Comment.

Hi seb7,

But then how will i fetch user details ?

this is how my comment model looks like:

class Comment extends Eloquent {

    protected $table = 'comments';
    protected $primaryKey = 'id';
    protected $fillable = ['comment'];


    public function user()
    {
        return $this->belongsTo('User');
    }

    public function discussion()
    {
        return $this->belongsTo('Discussion');
    }

}

Looks like your comments table must be the pivot between users and discussions.

Simply '''$user = $comment->user;'''

Discutions hasMany Comments

Comments belongsTo User

Why using a pivot table ? There is no many to many relation.

@pmall seems that there is a many to many relation that results of 2 has many relations, so the comments table becomes the pivot in this relation.

hi @bestmomo

See my tables i have only one pivot table i.e., comment_discussion which has 3 fields - comment_id - discussion_id - user_id

and i am fetching all comments for a discussion like this

$comments      = $discussion->comments;

but i am not receiving any user data...

Try describing your application because this schema is strange.

ok I am building a project management system in which we can create a discussion.

Inside the discussion page -> you can add your comments

and obviously each comment belongs to one user

so i just want to fetch all comments on particular discussion ( which i have already done successfully ) but i am not receiving any user information like username / useravatar etc.

i have tried manytomany, morphMany, hasManyThrough relationships

Help ??

So your schema is over-complicated.

You just need three tables, Discussions, Comments, Users.

• Discussions hasMany Comments / Comments belongsTo a Discussion (discussion_id on comments table)
• User hasMany Comments / Comments belongsTo a User (user_id on comments table)

Then :

$discussion = Discussion::findOrFail($discussion_id);

echo $discussion->title;

foreach($discussion->comments as $comment)
{
  echo $comment->comment;
  echo $comment->user->name;
}

hi @pmall

thats what i dont want to do. I dont want to add

discussion_id
user_id

in comment table

I have created a pivot table where it connects discussion with all comments

comment_discussion
- id
- discussion_id
- comment_id
- user_id

Do you think there is a way i can fetch user detail by using this pivot table ?

Nothing is wrong with having user_id and discussion_id in comments table. Why don't you want to do that ?

It is the conventions that make eloquent easy to use. It will be hell with a triple-pivot table.