Many-to-many (belongsToMany) in Laravel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the belongsToMany relationship represent in Laravel?

It represents a many-to-many relationship between two models, where each model can be related to many instances of the other.

beginner

How do you define a many-to-many relationship in a Laravel model?

You define a method in the model that returns $this->belongsToMany(RelatedModel::class);.

beginner

What is the purpose of the pivot table in a many-to-many relationship?

The pivot table stores the links between the two related models, holding their foreign keys to connect them.

intermediate

How can you access additional data stored in the pivot table in Laravel?

By using the withPivot('column_name') method on the belongsToMany relationship to include extra pivot columns.

beginner

How do you attach a related model in a many-to-many relationship?

Use the attach() method on the relationship, passing the related model's ID, e.g., $user->roles()->attach($roleId);.

Which method defines a many-to-many relationship in Laravel?

A belongsToMany()

B hasOne()

C hasMany()

D belongsTo()

The belongsToMany() method is used to define many-to-many relationships.

What does the pivot table contain in a many-to-many relationship?

A No data, just a name

B Only primary keys of one model

C All columns of both models

D Foreign keys of both related models

The pivot table stores foreign keys from both related models to link them.

How do you include extra pivot table columns in your Laravel query?

A withColumns()

B withPivot()

C withExtra()

D withData()

The withPivot() method specifies additional pivot columns to retrieve.

Which method adds a related model to a many-to-many relationship?

A attach()

B add()

C link()

D connect()

The attach() method adds a record to the pivot table linking the models.

If you want to remove a related model from a many-to-many relationship, which method do you use?

A remove()

B delete()

C detach()

D unlink()

The detach() method removes the link between models in the pivot table.

Explain how to set up a many-to-many relationship between two Laravel models.

Think about how two things can be connected many times both ways.

Describe how to access and use extra data stored in the pivot table of a many-to-many relationship.

Extra info in the middle table can be included in queries.