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.
Even more details - in this article "Laravel BelongsToMany: Add Extra Fields to Pivot Table": quickadminpane...
- - - -
Try our Laravel QuickAdminPanel: bit.ly/quickad...
Enroll in my Laravel courses: laraveldaily.t...

[@maxwellmaragia2272]

This was a life safer for a critical bug at my company. Thanks man

[@stojankukrika7242]

For that case, I used an additional table because didn't know that is that possible. Thank you a lot!

[@d1sgust3d]

Thank you so much! After I understood how sync works I write my code for processing arrays and it worked

[@norbertocammayo2334]

Hi sir, your tutorials are real world use case which helps me a lot. Thank you so much.

[@eloquent2200]

Thank you! It really helped me!

[@luismimora81]

Just what i needed! Many thanks

[@rip182]

this solved my issue thank you so much

[@viniciustavolaro]

damn man u really is the goat, thank u so much

[@jeffhansen4996]

Great video! Thanks

[@kelvinmurithi1993]

Hello sir nice video kindly do a video on how you store ingredients and recipe_id on the pivot table

[@RSantana]

Thanks a lot!

[@shuoyanpei8167]

Hello can you make a grocery list to containt the ingredients pf the recipe selected please

[@frtrash766]

What if i want to edit these records? Is it possible? Should i use an id to directly edit those records?

[@kisho2679]

How could a pivot view be modelled with SQL-Workbench, based on data stored in different mySQL tables?

[@thomaspotterdotexe]

What about the weight data per days? Should I create another table or just use json column?

[@digitaluniverse9826]

Thanks for the amazing video Mr povilas. Just noticed you using In array and old value In case of validation error. How does it work on select 2 drop down ? Could you please send the full snippet for the select 2 for ingredients dropdown?

[@AbdelrahmanEl.Monshed]

thanks , but i have a problem with a case of edit recipe , check ingredients checkbox but ingredients "amount empty " case2 , edit recipe with uncheck some ingredients checkbox . thanks in advance

[@joshbarros1995]

I was trying to do another project but this time: Laravel API and Vue SPA. I followed the steps on the video, but couldn't find a way to insert the "quantity" on the pivot table via Insomnia. PS: the pivot has 3 fields: order_id, product_id, quantity.

[@Muhammad_Bilal911]

Hello Sir, Please give me the link of video in which you are storing the data of Recipe and Ingredients at the same time..

[@BrawlerCreed]

Hello, i really need help :( I'm following your tutorial step by step, and it works fine EXCEPT THAT in my pivot table, one of the foreign_key id is set to 0 for some reason ? I don't understand where's the problem

[@TusharZambare]

What about search engine web ? 1st search box Sr. No. Select 2no. 2nd 🔎 box select 10no. And result show only 10no. field all data. That type search engine possible in quickadminpanel or any old video link.

[@PovilasKorop]

Sorry I can't understand how exactly it would look like, need a screenshot or link to an image of this "search engine web". But we do have a module Global Search in QuickAdminPanel: helpdocs.quickadminpanel.com/modules/global-search

[@mohammadaliabdullah9397]

thanks

[@miftakhusysyiroth9301]

if amount is integer, what is the query to sum total amount in soup?

[@jakovpavlov6268]

What if the extra field is another relation?? I mean think about this, in a project any user can be assigned to multiple projects, and in every project there are multiple users, but each user might have a different role in every project, so the pivot table would be: project_id | user_id | role_id

[@jakovpavlov6268]

I just found your other video, it's kind of what I was asking, just that in your example 'Managers' refers to the same users table instead of a roles table, but I think I got it, thanks!

[@jakovpavlov6268]

Actually I did the explained in the other to my project in Laravel 9 with three tables involved in the many to many relationship, Project / User / Role, and it worked!!! Thanks a lot

[@ricardodiez7941]

Hi!!!! this video safe my life :D , I finally understand about custom fields on pivots table, but i have a question how i can save custom values of pivot table from json-api endpoint? do you have any example for this kind of case ?

[@LaravelDaily]

There's no difference if it's API or not, the request still has parameters so you can work with $request to update data.

[@ricardodiez7941]

​@@LaravelDaily in my case, my endpoint need to get a json for process the request is a specific format json { "data": { "type": "sales", "attributes": { "userId": 85, "storeId": 2, "nroTicket": "123456", "precioTotal": "8500.0000", "createdAt": "2022-11-08 00:00:00", "updatedAt": "2022-11-08 00:00:00" }, "relationships": { "products": { "data": [ { "type": "products", "id": "110547" }, { "type": "products", "id": "110548" } ] } } } } i have sales table, product table and my pivot table is sale_product in my pivot table i have two custom fields 'sale_price' and 'sku_liverpool' i dont know how to send this two field in my json 😢i use Laravel JSON:API library and when im trying to send this data like this i have a format error: "relationships": { "products": { "data": [ { "type": "products", "id": "110547" , "attributes": { "precioVenta":"4500", "skuLiverpool":"LIV123" } }, { "type": "products", "id": "110548", "attributes": { "precioVenta":"4500", "skuLiverpool":"LIV123" } } ] } } do you have any idea ? what im doing wrong?

[@_halidigitulo]

how to update the ingredient value in edit page?

[@tmstechschool7239]

how about more than one extra fields, especially in the MAP case

[@tostrinjj]

Great, love your content. Question - is there a way with your setup to get something like a collection of all recipes with ingredients including amount limiting the data like [recipe id, recipe name,[ingredient_id, ingredient_name, amount]]? Thank you for your videos.

[@PovilasKorop]

Well, you just use ->pivot So do $recipes = Recipe::with('ingredients')->get(); And then, @foreach ($recipes as $recipe) @foreach ($recipe->ingredients as $ingredient) {{ $ingredient->name }}: {{ $ingredient->pivot->amount }} @endforeach @endforeach

[@abdelghafourghribil280]

How to use setter in pivot model?

[@dubinindv]

Hi! You have great content, I watch your videos with pleasure. I have a question. I'm stuck. There are Deals and Warehouses, you need to calculate the amount of transaction prices for the month in the warehouse.

[@PovilasKorop]

You mean something like Warehouse::select('id', \DB::raw('sum(deals.price)'))->groupBy('warehouse.id')->get(); ? Sorry I can't help more just from this short KZbin comment.

[@creeddm]

Have you checked withSum aggregate function? Something like Warehouse::withSum('deals', 'price')->get() ?

[@PovilasKorop]

@@creeddm I don't think there's a withSum method in eloquent, only withCount: laracasts.com/discuss/channels/eloquent/withsum-on-a-column-similar-to-withcount

[@creeddm]

@@PovilasKorop There is. At least if laravel 8. It's in "Other Aggregate Functions" section of the "Eloquent: Relationships" page in the docs. I haven't tried it with additional constraints like month tho. Probably should work like withCount by passing array with relation name as key and constraints callback as value.

[@dubinindv]

@@creeddm Yes, I know about it, but there is no condition. I need to complete this with the condition: transactions this month.

[@relaxwithnetia5409]

What if you enter a null value in amount after checking the checkbox? Any error handling?

[@PovilasKorop]

I didn't implement it in this example, of course you need to add validation.

[@joshbarros1995]

I have a pivot table: negotiation_user with negotiation_id and user_id Is it possible to add project_id between them and add via attach()? PS: project_id is a third foreign key

[@LaravelDaily]

Yes, sure, in the migration of negotiation_user you just add $table->foreignId('project_id')->constrained() Then in the model you define Negotiation -> function users() { return $this->belongsToMany(User::class)->withPivot('project_id'); } And then in Controller, or wherever, you do $negotiation->users()->attach($user_id, ['project_id' => $project_id]);

[@joshbarros1995]

@@LaravelDaily thanks a lot!!! I was trying for more than 4 hours doing confusing queries but I noticed I must change the negotiation_user migration, but now everything is perfect ;)

[@andywong2244]

@@LaravelDaily Povilas how does one display the project name if calling the project_id from the pivot table?

[@enriquerobledo845]

this is kind of tricky to do in livewire, for create/edit actions, maybe an idea for a new video?

[@LaravelDaily]

I've done a lot of similar videos with Livewire, I don't see this as particularly tricky, not worth the separate video

[@enriquerobledo845]

@@LaravelDaily hi I just tried it and successfully get it right, and yes not worth the separate video, i did it thanks to another of your videos, thanks a lot again you have been a great help for me an others

[@spartacusyusuf9989]

Please create a tutorial video for laravel resource controller to support restore and force delete automatically. so when we run make:controller and attach to a model it also generates methods for restore and force delete. And restore should use route model binding with trashed models by default instead of doing so manually at routeservice provider. Also, laravel Route::resource should have alias for restore and force delete also. Thanks alot.. wish there would be a shorter means than creating this manually always

[@PovilasKorop]

That make:controller is not supposed to generate restore and force delete, because they are not controller functions. They come from Eloquent and only from Soft Deletes functionality, so there's no way to auto-generate those or make it quicker, sorry. Here are official parameters for make:controller, below. But, of course, you can suggest another parameter and make a Pull Request to official Laravel! php artisan make:controller --help Description: Create a new controller class Usage: make:controller [options] [--] Arguments: name The name of the class Options: --api Exclude the create and edit methods from the controller. --force Create the class even if the controller already exists -i, --invokable Generate a single method, invokable controller class. -m, --model[=MODEL] Generate a resource controller for the given model. -p, --parent[=PARENT] Generate a nested resource controller class. -r, --resource Generate a resource controller class. -h, --help Display this help message -q, --quiet Do not output any message -V, --version Display this application version --ansi Force ANSI output --no-ansi Disable ANSI output -n, --no-interaction Do not ask any interactive question --env[=ENV] The environment the command should run under -v|vv|vvv, --verbose Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

[@tommyrachmadiono]

Do you have github repo for all your video?

[@PovilasKorop]

I post github repos in each video description if there is one. For this video - repo is at the end of related article: quickadminpanel.com/blog/laravel-belongstomany-add-extra-fields-to-pivot-table/

[@rafaelmaghari8033]

What datatable you used ? :)

[@PovilasKorop]

It's our own quickadminpanel.com generator based on datatables.net

[@rafaelmaghari8033]

I see btw i really likevyou tutorials!

[@namakuaku9775]

so hard with livewire

[@Fox6556]

Just what i needed! Many thanks

[@Jonstonrich]

Thanks a lot!