I have 2 tables:
profiles - for user profiles. posts - for user posts.
posts only has a user_id from profiles, to keep the table clean.
my HomeController have a function that get all published posts:
public function index()
{
$posts = Post::where('publish','=',1)->orderBy('created_at', 'DSC')->paginate(5);
return view('home',['posts'=>$posts]);
}
which post only contains user_id to link it back to its owner. How can I use the user_id from $posts to retrieve user data (user_name, user_image) and append it to its specific post?
I tried:
foreach ($posts->items() as $p) {
$profile = Profile::where('user_id','=',$p->user_id)->first();
$p->put('profile',$profile);
}
and I get an error:
Call to undefined method Illuminate\Database\Query\Builder::put()
How can I resolve this?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire