Relationship between User and Comment model

Question

I did relationships between different models all the time but for some reason I can't get this one to work. I tried everything I can find on Google but no luck.

I want to create a relation between Comment and User models. Any user can make many comments and I need to use email address of the commenter.

Basically, this:

$comments->user->email

My database looks like this:

userdata
--- id
--- username
--- email

comments
--- id
--- username
--- comment

userdata.username and comments.username should be related to eachother.

I pass the data to views like this:

Comment::with('user')->where('on', $news->id)->orderBy('id', 'DESC')->take(10)->get()

No matter what I try, I can't get it to work. Relations are not created. Maybe I came across a strange laravel bug?

Those are my models: (I write the default ones since I messed them up so much trying different approaches)

class Comment extends Eloquent {

    public static $key = 'id';
    protected $table = 'comments';
    public $timestamps = true;
}


class User extends Eloquent implements UserInterface, RemindableInterface {
    protected $table = 'userdata';
    public $timestamps = false;

    //It contains necessary imports and methods, I cutted them off for stackoverflow
}

Does anybody have an idea how can I solve this?

alayli · Accepted Answer · 2014-01-05 03:42:10Z

1

In a normal database scheme, docs written here. In your case, this should work:

// Model: Comment
public function user()
{
    //belongsTo('User', 'local_key', 'parent_key'); so:
    return $this->belongsTo('User', 'username', 'username');
}

//Then get this
Route::get('/test', function()
{
    return Comment::find($id)->user->email;
});

answered Jan 5, 2014 at 3:42

alayli

3451 gold badge6 silver badges19 bronze badges

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

2 Comments

Aristona Over a year ago

Strange enough, it didn't work but I dropped username column on my comments table and replaced it with user_id. That way, it worked. I'll pick your answer as selected regardless.

alayli Over a year ago

I'm glad to help you. You can edit my post if you think other users will benefit from this.

Niels B. · Accepted Answer · 2014-01-04 23:16:52Z

0

This code $comments->user->email is not going to work.

$comments is an array of comments. It does not hold any shared reference to a user, you will have to pull a particular comment out and read the associated user.

Have you added the belongsTo() method to your comment model?

answered Jan 4, 2014 at 23:16

Niels B.

6,3804 gold badges30 silver badges46 bronze badges

1 Comment

Aristona Over a year ago

Well, $comments is an array. I didn't want to include my foreach loop. Normally it is $comments[$k]->user->email, or $v->user->email

Collectives™ on Stack Overflow

Relationship between User and Comment model

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related