11 - DB Refactoring: From BelongsTo to BelongsToMany
30 - Advanced Polymorphic: Many-to-Many
Now, let's look at the polymorphic relation, which is a bit more complex: a many-to-many polymorphic relation. Suppose we look at the photos table from a previous lesson example
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.
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.
Quick Tip
Add where statement to Many-to-Many relation
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