Laravel 5.2尝试获取user_id帖子

I am following a Laravel course on Udemy and while I followed everything the instructor did, for some weird reason I am not getting the expected result.

This is the Relationship One to One lesson and I added a function in User Model to check if it has any posts.

Then added the route to display post if user_id equals.

app\User.php

public function post() {

    return $this->hasOne('App\Post');

}

app\Httpoutes.php

    Route::get('/user/{id}/post', function($id) {

    return User::find($id)->post;

});

Below is the screenshot from the database showing that I have a post with user_id = 1 in the posts table. I also have a user with id=1 in the user's table. MySQL data Why do I get a blank page when visiting domain/user/1/post?

Sohel, i got a result from your function, but had to use

var_dump(User::with('post')->where('id',1)->first());

Then tried something else:

return User::with('post')->where('id',$id)->first();

And this is the result:

{"id":1,"name":"Nick","email":"nick@kriogen.name","created_at":"2018-03-15 09:49:51","updated_at":"2018-03-15 09:49:51","post":null}

I think you need ->hasMany() relation if you want to check if user has any posts because the user can has many posts... and the code would be:

public function posts() {
    return $this->hasMany('App\Post');
}

The call:

User::find($id)->posts;

Your one to one relationship should go as: app\User.php

public function post() {
    return $this->hasOne('App\Post');
}

app\Post.php

public function user() {
    return $this->hasOne('App\User');
}

you can try doing this function in controller:

public function getPost {
    $user= User::find($id);
    return $user->post();
}

The issue was not with the functions, the issue was in the database. Column deleted_at was not NULL and it was marking the post as being soft deleted, therefore not being displayed.

Since the "user_id" field is in the "posts" table, the relation in the App\User model need to be:

public function post() {
   return $this->hasMany('App\Post');
}

then, call it without the parenthesis to get the result:

public function getPost {
    $user= User::find($id);
    return $user->post;
}

When you use the parenthesis, you get the builder and not the result. example:

public function getPost {
    $user= User::find($id);
    return $user->post()->get();
}

OR

public function getPost {
    $user= User::find($id);
    return $user->post()->where('name', 'like', '%hello%')->get();
}