How to use join in Laravel Eloquent?

Question

I have following two tables.

users - id,name,title
posts - id,author

where post.author = user.id

My Post model as follows.

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    public function users()
    {
       return $this->belongsTo('App\User');
    }
}

I use Project::find(1)->users

But it giving following error.

SQLSTATE[42S02]: Base table or view not found.

Can anyone please help ?

You need to read the [docs](https://laravel.com/docs/5.2/eloquent-relationships#one-to-one). By default, Laravel assumes the id would be `user_id` in the `posts` table. If you want to use the `author` column name, then you may override that in your `User` model. — Kirk Beard, May 30 '16 at 12:40
Thanks @Krik Bread. Is this the way? return $this->hasManyThrough('App\Post', 'author'); — IshaS, May 30 '16 at 13:36

Robin Dirksen · Answer 1 · 2016-05-31T09:02:30.700

1

You can change your code to this:

class Post extends Model
{
    public function user()
    {
       return $this->hasOne('App\User', 'id', 'author');
    }
}

This will get the user from the database by calling Post::find(1)->user->id.

I suggest to change users to user because a post can have only one author.

Hope this works!

edited May 31 '16 at 09:02

answered May 30 '16 at 12:44

Robin Dirksen

3,322
25
40

Post::find(1)->user->id call from PostController.But it's not work. – IshaS May 30 '16 at 13:33
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'users' doesn't exist (SQL: select * from `users` where `users`.`author` in (1)) – IshaS May 31 '16 at 09:01
Ow I see, the arguments are in the wrong order... I update my answer! – Robin Dirksen May 31 '16 at 09:02
Thanks @Robin Dirksen Now it return string(1) "1" instead of the object – IshaS May 31 '16 at 10:17

score 0 · Answer 2 · edited May 23 '17 at 12:22

0

This should change

Project::find(1)->users

to this

Post::find(1)->users

Read This

Base table or view not found: 1146 Table Laravel 5

edited May 23 '17 at 12:22

Community

1
1

answered May 30 '16 at 12:46

Abdulla Nilam

36,589
17
64
85

score 0 · Accepted Answer · answered Jun 01 '16 at 10:02

Your Post model..

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    public function users()
    {
       return $this->belongsTo('App\User', 'author');
    }
}

Now use it as..

Post::find(1)->users;

As because a post have only a single creator you can change the users method on Post model as user and use it as

Post::find(1)->user;

How to use join in Laravel Eloquent?

3 Answers3