laravel has many with pivot table code example
Example 1: one to many laravel
For example, a blog post may have an infinite number of comments. And a single
comment belongs to only a single post
class Post extends Model
{
public function comments()
{
return $this->hasMany('App\Models\Comment');
}
}
class Comment extends Model
{
public function post()
{
return $this->belongsTo('App\Models\Post');
}
}
Example 2: laravel detach
$user->roles()->detach($roleId);
$user->roles()->detach();
Example 3: laravel many to many relationship with pivot table
$user = User::find(1);
$user->trophies()->attach($idOfTrophy);
$trophyId = $request->trophy_id;
$user->trophies()->attach($trophyId);
attach and syncWithoutDetaching both does same job
Example 4: laravel many to many relationship with pivot table
$trophyIds = Trophy::where('some_column','some_value') ->pluck('id')->toArray();