Store views in background into the table

Question

I want to save comments, posts and profiles that a user views in a viewable table. Posts and comments are displayed in a stream similar to social networks. How can I store the data in a viewable table in the background?

Table:

viewables
    user_id
    viewable_id
    viewable_type

For example, if a user views or sees a post in the stream, the database should store the user_id and post_id. The same should be possible with comments and profiles.

EDIT:

The posts are issued in a forelse loop and the comments in a foreach.

 @forelse ($posts as $post)
            @if ($post->type === 1)
{{$post->body}}
                @foreach ($post->comments as $comment)          
                   {!!$comment->body!!}
                @endforeach
            @elseif ($post->type === 2)
{{$post->image}}
                @foreach ($post->comments as $comment)          
                   {!!$comment->body!!}
                @endforeach
            @elseif ($post->type === 3)
show post with type 3
            @elseif ($post->type === 4)
show post with type 4
            @else
show remaining
    @endforelse

Answer 1

Based on your edit, there are a few different ways to handle this. Technically, since all posts are included on the page, it could be assumed that the user has read them all and simply save the user id for all of the posts loaded before rending the view.

If you wanted something more refined, however, you could use an ajax method to post the user id, post id, etc. when scrolling over it, though I don't find that very practical, as that could cause problems if someone scrolls through too fast.

The best option (without requiring user interaction) would be to load a couple posts at a time. Either automatically when scrolling (see this answer), or with the help of Laravel's pagination (https://laravel.com/docs/5.7/pagination) and set the user id when loading the data.

Example:

$posts = Posts::paginate(5);

foreach($posts as $p) {
    DB::table('viewables')->insert([
        'user_id' => $user->id,
        'viewble_id' => $p->id,
        `viewable_type` => $p->type,
    ]);
}