11 - DB Refactoring: From BelongsTo to BelongsToMany
31 - Advanced BelongsToMany with Extra Pivot Table Features
Let's talk about a belongs-to-many, also called many-to-many relationships, but on a deeper level. What are other options besides the foreign keys columns in the pivot table? This is a typical pivot table between a project and a user
Video
12:23 mins
Free
Laravel Pivot Tables: Simple to Advanced Many-to-Many
This is a deep dive into belongsToMany Relationships in Laravel with examples - from simple, to much more complex.
Video
6:48 mins
Free
Laravel Many-to-Many: Extra Fields in Pivot Table
What if you have a belongsToMany relationship, and want to add the extra field(s) to the pivot table? In this video, I will show you how to do it, step-by-step: migration, model, form, controller.
Tutorial
6 min read
Free
Pivot tables and many-to-many relationships
Today I want to talk about a feature of Laravel which is really useful but can be potentially difficult to understand at first. Pivot table is an example of intermediate table with relationships between two other "main" tables.
Tutorial
2 min read
Free
Laravel: Get Newest/Oldest Records from Pivot Table in BelongsToMany
Default belongsToMany relationship in Laravel works really well - you can easily attach, detach or sync records. But what if you want to order pivot records by newest or oldest? This article will show you how.
Tutorial
2 min read
Free
WherePivot and WherePivotIn - additional filters for many-to-many relationships
Recently I've found a small detail in Laravel documentation which I want to share with you. Apparently, it's possible to filter pivot tables additionally, if needed. Let me show you how.
Quick Tip
Update an existing pivot record
Code Example
familytree365/backend
familytree365/backend
Files in the example:
-
app/Models/User.php
-
database/migrations/landlord/2021_05_30_082351_create_chat_members_table.php
Code Example
agorakit/agorakit
agorakit/agorakit
Files in the example:
-
app/Group.php
-
app/Http/Controllers/GroupMassMembershipController.php
Code Example
LaraBug/larabug-app
LaraBug/larabug-app
Files in the example:
-
app/Models/User.php
-
app/Http/Controllers/ProjectController.php
-
app/Models/Project.php
Code Example
JustinByrne/Mealing
JustinByrne/Mealing
Files in the example:
-
app/Models/Recipe.php
-
resources/views/recipes/show.blade.php
-
database/migrations/2020_12_03_150502_add_quantity_to_ingredient_meal_pivot_table.php
Code Example
monicahq/monica
monicahq/monica
Files in the example:
-
app/Models/Instance/Emotion/Emotion.php
-
database/migrations/2018_12_09_145956_create_emotion_call_table.php
Code Example
jcergolj/laravellte
jcergolj/laravellte
Files in the example:
-
app/Models/Permission.php
-
database/migrations/2023_03_26_110250_create_permission_role_table.php
-
app/Models/User.php
Code Example
aschmelyun/laravel-job-board
aschmelyun/laravel-job-board
Files in the example:
-
app/Models/Listing.php
-
app/Http/Controllers/ListingController.php
Code Example
academico-sis/academico
academico-sis/academico
Files in the example:
-
app/Models/Enrollment.php
-
app/Http/Controllers/ScheduledPaymentController.php
Code Example
serversideup/financial-freedom
serversideup/financial-freedom
Files in the example:
-
app/Models/Transactions/Transaction.php
-
app/Services/Transactions/AddTransaction.php
Code Example
JhumanJ/OpnForm
JhumanJ/OpnForm
Files in the example:
-
app/Models/Workspace.php
-
database/migrations/2022_09_12_074636_remove_access_token_from_workspaces.php