How to make a related selection from 2 tables in laravel?

Question

Laravel

Hey!
I have two tables for example
User -> id, name
Task -> user_id, task.
How can I get all tasks only instead of user_id so that name is substituted?

Answer 1

Set links

class User extends Eloquent {

    public function task()
    {
        return $this->hasOne('Task');
    }

}

class Task extends Eloquent {

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

}

Well, the sample should be in the spirit of more details here

Task::with('user')->where('user_id', '=', $id)->get()

Answer 2

I think here you will find the answer Eloquent ORM