Laravel Pivot Tables: Simple to Advanced Many-to-Many

[@user-yy4qz8qq7e]

A simple superfast explanation. No bullshits Straightforward

[@sherwalichd]

for making model as pivot .command php artisan make:model -p

[@ChrisBackhouse]

Ok, I thought I knew pivots, even complex ones, until I watched this. I always learn something from your videos. Truly inspirational! 👍

[@sherwalichd]

Every laravel lover should buy this 4 hours eloquent course .

[@kevinbaenadurango722]

You're a laravel god, and I'm grateful for your teachings, thank you for everything.

[@jakovpavlov6268]

I tried this in Laravel 9 with three tables involved in the many to many relationship, Project / User / Role, and it worked!!! Thanks a lot

[@naine7th33]

i didn't know Carlo Ancelotti was master of laravel, thanks man

[@skyniitzs5942]

guys, this man is the best. Man thank you very much, you have saved me from a problem that I could not find how to solve it. Very good video and explained, it goes on so you will be much bigger than you are now.

[@dcxwms2151]

Must say I'm watching a while and a i bought the stuff - this one is by far one of the best, there's very limited content out there on this topic that explains it like this so many thanks!

[@akarimdad1995]

this video helped me so many times Great video

[@K-John]

This was incredibly useful, thank you! I was struggling to find a good detailed overview of how pivot tables work. The laravel documentation is not clear if you're not already familiar with them. I appreciate you!

[@marceloaborgess]

Thanks a lot !!!! You help so much... I not understand english very well, but I follow your videos and then help me so much... Thank you

[@kamsikodi]

Been watching your videos everyday since i found your channel a couple days ago, thanks a lot for this.

[@alvinkariuki236]

You don't know how much I needed this 😂 thank you so much

[@emraneklaai1808]

you saving my life ❤❤

[@randak37]

Your videos are great and cover things that seem to get ignored elsewhere. Impressive work and knowledge!

[@feproniyaf5667]

One of the best video about many to many relationship with pivot in laravel. Thank you buddy. Keep going

[@pierdocks5412]

I agree, This guy is a great instructor!

[@benzazalaid6623]

you explain very very very good , thank and God give you peace

[@LaravelDaily]

Want more? Here's my course "Eloquent: Expert Level" laraveldaily.com/course/eloquent-the-expert-level

[@bboydarknesz]

man your eloquent skill is very crazy ofcourse you are Laravel God too

[@muhammadwaqar2519]

I was working on a project and going through the documentation for this "Many to Many" part when your video came up xD. You explain very good. Thanks

[@skyniitzs5942]

I hope you continue to make videos of advanced things in Laravel, and the basics are very covered on youtube. I hope you continue with advanced things like these that are what make Laravel great. you deserve all the likes and many more

[@kayleeherrmann308]

I liked this before I even watched it as I already knew your video would help me! Thanks for such consistent high-quality content.

[@JesusGil90]

super complete explanation 👍

[@sefedinrreci]

Best Tutorial I saw! Thank you very much!

[@muhammadwaqar2519]

One thing to ask, you have queried the *manager* relationship of pivot table in every iteration. Isn't there a way to eager load the relationships on pivot table too?

[@rudal]

Stumbled upon this, and wow thank you for the great howto on deeper eloquent topics cheers

[@AhsanKhan89]

Extremely great.

[@nursemagunbay5460]

Billurlarına sağlık be adam.

[@ernesto.pareja]

Thank you. Great as always

[@pedrolucca9596]

dude, i`m in middle of a project with a lot pivot tables, i`m using query builder but use this gonna be really more easier for me and for the other guys make some maintenance and understand the code. Thx for this lessons

[@silvesterwali6565]

it's save my day. thanks so much

[@essamal_agamy148]

Thank you very much for this information💙

[@GergelyCsermely]

Very interesting. Thanks. I made a similar project, but with the pivot table I faced problems on delete on the origonal records from the parent tabel. I solved it with with on delete cascade $table->foreignId('checkout_id') ->references('id')->on('checkouts') ->onDelete('cascade'); $table->foreignId('paymethode_id') ->references('id')->on('paymethodes') ->onDelete('cascade'); $table->primary(['checkout_id', 'paymethode_id']);

[@alimransujon6388]

Another great video . Brilliant examples. Thanks a lot.

[@binarybuilder111]

Thank you for your work and extremely useful content!!!!

[@arsondevelopment3858]

Great stuff, exactly what I needed, cheers!!

[@robertoflores2078]

This is gold.

[@marlonferreira5081]

thanks for this pill of knowledge. it was really awesome for my project.

[@behzodjon]

Great video!Thanks!!!

[@valcmeza]

Really helpful video! Really helped me understand.

[@sobirmalilov8838]

Very useful tutorial for me thanks

[@lukasvanhoof7672]

Another great video, thanks!

[@moumantiok]

Very informative.. thanks

[@gessegoncalves6493]

thank you, your video was very helpful

[@nadeemahmed7947]

Very HelpFull Thanks

[@user-oh3cw2pj1g]

thanks, its a great help

[@adaprogramming8329]

Thanks, this was very helpful

[@MrGuilherme1100]

Perfect. Just perfect.

Dude, you are awesome!

[@nurbolatnurlanuly]

Nice tutorial 👍🏻👍🏻👍🏻

[@wolfrayet81]

i cant' thank you enough!!! that was brilliant!!!!

[@thiagotks]

Your classes are really great. Congrats for talking a language that we can understand. Do u have courses on udemy?

[@hrk5703]

very good thanks sir

[@ErkanVal]

Thanks for the tips! 👍

[@rijalaf724]

thank you my error has been resolved now

[@cedricvumisa7416]

thank you very much

[@user-xu1yp4hy6x]

awesome thank you!!

[@ngebolangria1060]

Thank you !!!!

[@cristianganzer2057]

Saved my day :) thanks

[@alexvaught95]

nice example

[@FortinhoTV]

Great work, thanks

[@joshsavage8659]

Thanks so much!!

[@warisshaikh9474]

Awesome Sir

[@fabiangomez6540]

Thanks!!!

[@risangbaskoro]

Just realized that the manager() method in Invitation model can just have $this->users()->wherePivot($condition) logic.

[@taslimsuman]

Thank you sooooooo much

[@offsideplayer]

Is it possible to call the ProjectSeeder (which would only create the instances of Project) before the UserSeeder, and do the foreach attaching logic in the UserSeeder? Or are we attaching the users to the projects, also according to the naming convention of the pivot table? Thanks, great videos!

[@Heyb111]

How you can load relation(manager) for pivot table with `with()` Project::with('users.pivot.manager') for avoid n+1 issue which exist in your code

[@kamleshpaul414]

thank you for informative video can u create morph relationship and cascade on delete when we use softdelete is not working

[@PovilasKorop]

Yes I'm planning to publish a video on cascading later this week

[@kamleshpaul414]

@@PovilasKorop thank you so much sir ❤️

[@PovilasKorop]

@@kamleshpaul414 while doing research, specifically for polymorphics I've found this package, have you tried? github.com/shiftonelabs/laravel-cascade-deletes

[@kamleshpaul414]

@@PovilasKorop thank you i will look this

[@neerajsinghtangariya2587]

Nice Quick Tips :)

[@agungsugiarto5134]

I hate eloquent. It's work, i love eloquent.

[@user-pc4uc8wn3c]

Thankyouuuuuuuuuu

[@Luisow748]

Wow. Thanks.

[@kratom82]

very helpful and thanks a lot. i cant quite figure out yet how to store values into the boolean fields $user->roles()->sync($request->roles); //This is where i save multiple roles attached to a user $user->classrooms()->sync($request->input('class')); // here i assign the user to a specific classroom from a dropdown return redirect()->route('admin.users.index'); but what do i have to do, to fill in the booleans is_manager if for example one of the multiple roles manager is checked? is this the case where i should use a Pivot Model and rework my classes and relations for cleaner data handling?

[@PovilasKorop]

What you need is intermediate columns, like: return $this->belongsToMany('App\Role')->withPivot('column1', 'column2'); Read the docs laravel.com/docs/7.x/eloquent-relationships#many-to-many - specifically section called Retrieving Intermediate Table Columns

[@masoud_or_whatever]

awesome

[@yusufoz5246]

you are the king. if you come to turkey i will buy you adana kebab.Thank you king:)

[@josiahtmahachi7291]

Thank you for this video. I was wondering how to set a value for one (or more) of the columns in the pivot table while attaching. For example, when attaching a user to a project and set is_admin to 1 at the same time.

[@LaravelDaily]

Read in the docs: laravel.com/docs/8.x/eloquent-relationships#attaching-detaching

[@josiahtmahachi7291]

@@LaravelDaily thanks for the pointer. Done.

[@josiahtmahachi7291]

@@LaravelDaily thanks for the pointer. Done.

[@tiagopaees]

Awsome!

[@gabrielp.zonatto6411]

I had a problem using the pivot model in many-to-many relationships because the queries in the database used the table name different from what I had named in the varialbe $table in model pivot

[@MouayedElhak]

Very nice work, please if you can make video for OrderBy or sortBy into belongsToMany Relationships ?

[@bitculator]

What if it is a categories/subcategories table like only 'Category' and CategoryGroups, where CategoryGroups has parent_id and child_id, to allow a category to both be a parent but also be a child of more than one parent etc, i cant get that to work

[@kevinnacario359]

How do you add a column like 'timestamps()' without losing previous data? I'm trying to add different column name. I tried $php artisan migrate:fresh --seed, doesn't seem to work. Great video, thanks!

[@hardiklakhalani6268]

did you find the answer?

[@loicrutabana1884]

I knew nothing about pivot before I came here. Now I know how much I don't know. Still confused. That is all UPDATE: nvm I get it now

[@dascorp1]

@PovilasKorop How can we order the results by field in pivot model relation? using the video example by managers name - `$user->pivot->manager->name`

[@dipenparmar2273]

Nice 👍

[@chrisdedavid1860]

Hi, why did you only define the relationship one way? Have a video showing many-to-many relationship defined both directions (from Users and Projects)?

[@linasgutauskas5528]

Is pivot tables the best solution even if you know, that you won't have a lot of records? Are you always using pivot tables, if you know, that there won't be more then 100 records in relationship table? Thank you.

[@prashantredspark4509]

This is working fine but I am not able to see pivot result in controller response(not in blade). How I can achieve? And is it working fine with API?

[@coolcha]

Thank you for making this video it really helps. Question: how to use MorphPivot - there is not much information and examples out there as I suppose it is quite advanced. Please could you explain or point to some resource.

[@javar1987]

thanks man, you are imba.

[@ehtashamshami6969]

Can we have the primary ID inside the pivot table that is for if we want this pivot table's primary ID in another table as a foreign ID? In a scenario where another table is also a pivot table having the current pivot table ID as foreign ID and some other table ID as foreign ID. For more clarification: Table1, Table2, Table3, Table1_Table2 (Pivot Table between Table1 and Table2), Table1_Table2_User (Pivot Table between Table1_Table2 and Table3) Also, is that the correct approach?

[@rejowanahmed6819]

I have a query here, why you put foreignPivotKey projects_id and relatedPivotKey users_id in the belongsToMany method? Shouldn’t it be, belongsToMany(User::class, 'user_id', 'id'),

[@yassinenatij1699]

can we use the same approch when we have categories ,for exemple , id and parent_id for categories in the same table.( id , name , parent_id ) ?

Thank you for the detailed explanation. I want to ask a question. There is a similar construction in the form products (id, name), urls (id, url) and product_url (product_id, url_id). When a product or url is deleted, I can delete it from the product_url table. There is no problem, but when I delete a data from the product table, I want to delete all the urls connected to that product from the urls table, although I gave it onDelete ('cascade') in the product_url table, it did not work. :( is there an easy way to achieve this?

[@erikmortensen3788]

First... excellent video !!! Second ... is it possible to get the id of the pivot table ?? I can't do it

[@ehSamurai3483]

Sir i am confused in why not use hasMany(User::class) in Project Model. Doesnt it mean that a project has many users?

[@davitjanashia9344]

Great video, thank you for amazing content. One question, which text-editor or IDE are you using in this video?

[@PovilasKorop]

Phpstorm.

[@davitjanashia9344]

@@PovilasKorop Thank you, yes, after I asked a question I noticed when you were switching programs. 👍🏻 I use atom, but it seems that PS has more features to work with Laravel

[@lucifer-5ybtn]

How to eager load the manager relation?

[@spraydeveloper5452]

Hello, can I query modal like this $user = user::with('roles')->wherePivot('role_id', 1)->get(); instead of wherePivot in modal class? Thank you :)