Table Relationship

[baopham]

Table Relationship

[baopham]

You can just do:

foreach ($users as $user) {
   $posts = Post::where('user_id', $user->user_id)->get();
}

[qyqyqy03]

Yes Thank you so much, it got the data
I used {{ $users = App\User::where('user_id', $post->user_id)->get() }} in foreach in blade.php
and it show

[{"user_id":"123","email":"123@com","password":"1234","first_name":"Tony"}]

but how to get "Tony"?
$users.....[]??

[baopham]

Just do $user = App\User::find($post->user_id) - you will get the one user record.

Closing since this question actually has nothing to do with this library. I suggest you reading up on Laravel Eloquent docs first.

[qyqyqy03]

and now I got this

{"user_id":"123","email":"123@com","password":"1234","first_name":"Tony"}

how can I get the first_name -- "Tony"?

[baopham]

$user->first_name

[qyqyqy03]

But it hv an error

Trying to get property of non-object

After define {{$user = App\User::find($post->user_id)}}
I can {{ $user }}
with the same result of

{"user_id":"123","email":"123@com","password":"1234","first_name":"Tony"}

[baopham]

Try to debug by looking at the variable type. Sorry I can't help much on this as it has nothing to do with the library