Sign up to access "Build an E-Commerce Platform" right now.

Nike for example we see all of the products that have been attached to that category. So this will be very quick but then we can move on with the rest of our product browser. So we're going to go ahead and create out a migration just a migration on its own and this is going to be to hook up the categories to the products with the belongs to many

relationship. So we're going to start with the category and then say product the reason being is that just C comes before P in the alphabet and Laravel will use this convention by default. So create category product table and that should be everything we need. We just want to prefix that with create so Laravel builds out everything we need. Okay so let's go over to create category

product table and let's fill this in. It's going to be very very simple we're just going to need in here a category id and we'll use foreign id for this so everything gets hooked up for us so category id and we'll constrain this and we also need a product id. Now the reason that this pivot table is important is because multiple products could be in multiple categories

you don't just want to come over to your database and say that a particular product is within a certain category otherwise you would have to duplicate products it doesn't make sense. So let's go ahead and run php artisan migrate and let's go over and start to hook some of these up. So let's say that we want Nike to be in a couple of categories we'll start with that and we'll add

some more later so Nike is obviously going to go in the night category so let's go and select Nike here we don't really need to create it out and update it up but we'll go ahead and fill it anyway and let's go ahead and put that same product that Nike shoe in Nike new in kind of makes sense there we go so they are the same product but in two different categories. Okay so in terms of the

relationship let's go over to the category model to start with and we'll go ahead and create out this product relationship so that is belongs to many and product so that will go ahead and pull out any of the products in that particular category and we can do the reverse which we were trying to do in the last episode over in the product model and we'll just create this down here

and we'll say categories so that will give us all of the categories that that particular product is in and once again we just use the same belongs to many relationship but this time we give the category model in there and again let's just make sure we pull the namespace in for that and that doesn't look like it's working probably because we've already defined the relationship

just here in the last episode so we'll leave that just up there okay so now that we've done that we can actually fix our two searchable array method and we can include them categories in there so let's do that now let's say category ids we'll go ahead and we will pluck out the categories relationship but we'll pull that back as a collection and then we'll just go ahead and

say pluck id because that's really all we need we just need some sort of identifier for each of the category ids and this will obviously give us back an array so that will be absolutely fine we can even cast that to an array just there just to be explicit okay so let's open this up and rerun flush and import and let's head over to melisarch and there we go we can see that that

nike product is in categories three and six now the reason that this is important let's get to that now is that when we come over here and we build out our product browser our product browser is going to make an immediate request to melisarch so what we're going to need to do is when we pull in the products that we want to show say under category nike what we can do is do a quick look

up inside of melisarch and say well what category does nike belong in and we can pull in only them products that belong to them category ids so we can just do a simple search to grab that out if that doesn't make sense now it will do when we get to our product browser which we are going to scaffold out in the next episode