Table Relationship

[qyqyqy03]

Hello, I have an question
I want to display all posts in a page

Here is my dynamodb

users Table: user_id | name | password
posts Table: id | body | user_id

user_id for me to link, so one user has many posts
I just simply use Auth::user()->user_id to get user id and request body to create a new post item

but how to foreach the following?

name(from users) : body(from posts)

[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