How to add unique records in pivot columns of Laravel pivot table

• Insert unique value combination in pivot columns of Laravel pivot table

  //routes\web.php
  Route::get('/insert-in-pivot-table', function(){
      $user = App\Models\User::find(1);
      $project = App\Models\Project::find(1);
  
      if (!$user->projects->contains($project->id)) {
          $user->projects()->save($project);
      }
  });
  

  You can insert records in pivot table after checking the value in pivot column of pivot table is not already exists. You have to create users, projects and project_user pivot tables. You have to also create projects method with belongsToMany relation in User model.

   

  Projects method with belongsToMany relation

  app\Models\User.php

  public function projects(){
      return $this->belongsToMany('App\Models\Project')
                  ->withTimestamps();
  }

Related Queries

• How to create pivot table in laravel using migration
• Laravel create table migration with model
• How to avoid duplicate entries in pivot table in Laravel

Back to code snippet queries related laravel