How to insert value to additional columns in pivot table in laravel

• Insert value to additional columns in pivot table

  // app\Http\Controllers\<YourController>.php
  // Use Before class definition in your controller
  Use App\Models\User;
  
  //Use Inside controller&rsquo;s method
  $user = User::findOrFail(1);
  $projectIds = array('1', '2');
  $user->projects()->attach($projectIds, ['is_manager'=>1]);
  
  //Create projects() method with belongsToMany Relationship in - App\Models\User.php
  
  public function projects(){
      return $this->belongsToMany('App\Models\Project')
                  ->withPivot('is_manager')
                  ->withTimestamps();
  }
  

  This code snippet is used to insert a value to additional columns in the pivot table. Here we use belongs to many relationships in the User model to get the projects table records with pivot table data using withPivot method. 

   

  To create project model and table structure of project table visit here - Create project table with model and migration .

  If you want to get code snippets to create pivot table for projects and users tables you can visit here -  create pivot table  .

Related Queries

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

Back to code snippet queries related laravel