How to add a SAVE POST/BLOG functionality with laravel 9

@shoaibali so add a table with a user_id and a post_id column. Something like a FavoritePost model

@shoaibali In that case, I would suggest you implement a many-to-many relationship where the foreign keys are user_id and post_id; whenever the User likes(/saves) a Post you attach across the relationship:

php artisan make:migration CreateSavedPostsTable --create=post_user

Implement then relationship

public function savedPosts()
{
    return $this->belongsToMany(Post::class);
}

Define an endpoint for saving the Post; and corresponding Controller:

Route::post('posts/{post}/save', [SavedPostController::class, 'store'])->name('saved-posts.store');

Save the Post

public function store(Post $post)
{
	auth()->user()->savedPosts()->attach($post->id);
    return back();
}

Then you can get the saved posts from the relationship using the User instance:

@foreach(auth()->user()->savedPosts as $post)
    // link and title, or something 
@endforeach

Otherwise, consider any up-to-date favoriting package, e.g. https://github.com/overtrue/laravel-favorite

@tykus Hello, How can we achieve this with Query Builder approach? Would be thankful for the response. I've created a post with Query Builder approach. So, want to do it with Query Builder not the Eloquent one.

@shoaibali it should be no different to insert a record into the pivot table using the Query Builder compared with creating the Post, assuming you have the authenticated user's ID and the Post ID:

public function store(Post $post)
{
	DB::table('saved_posts')-> upsert([
        'user_id' => auth()->id(),
        'post_id' => $post->id,
    ], [
        'user_id',
        'post_id',
    ]);

    return back();
}

@tykus What if user wants to unsave post?

Which option is more accurate for such scenario: delete() (delete record) or detach()?

Best regards

@Dmytro_Shved there is toggle method available on BelongsToMany relationships; I would suggest using that method to handle the save/unsave behaviours in single Controller action, e.g.

public function store(Post $post)
{
	auth()->user()->savedPosts()->toggle($post->id);
    return back();
}

@tykus

I have a question about naming relationship in Post model

You added to User model:

public function savedPosts()
{
    return $this->belongsToMany(Post::class);
}

but how can I name the relationship in Post model? Is savedBy or savedByUsers would be nice?

I am asking because in my situation I have relationship with User in my Post model with name user() and If I will name other relationship using name users() it will be weird imho.

Would be grateful for your opinion about it

You don't have to strictly name the relationship according to the related model's name; for example, the Post might have followers or subscribers. Similarly, rather than user, it might have an author or creator