I am making an activity page, which will show the activity of a user and i'm wondering the best way to approach this issue of showing the different activity and ordering the activity on the created_at timestamps of all the tables merged.
at the moment i have
Controller
public function getActivity()
{
$blogs = Blogs::where('blogs.user_id', '=', Auth::User()->id)->orderBy('created_at', 'DESC')
$comments = Comments::where('comments.user_id', '=', Auth::User()->id)- >orderBy('created_at', 'DESC')
$forumposts = Forumpost::where('forumposts.user_id', '=', Auth::User()->id)->orderBy('created_at', 'DESC')
return view('myactivity')->withBlogs($blogs)->withComments($comments)->withForumposts($forumposts);
}
View:
@foreach($blogs as $blog)
<p>You posted at </p>
@endforeach
@foreach($comments as $comment)
<p>You posted at </p>
@endforeach
@foreach($forumposts as $forumpost)
<p>You posted at </p>
@endforeach
The issue with the above code is that it is not merged on one created_at, it is essentially three different created_at lists, how do i merge them into one?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire