Can I use Restaurant and Category Table many to many relation in Product Model using Laravel? and How can I add update Categories_Restaurants table?

Question

Restaurant Table
id ---> PK
Name
Address
City
Phone
Latitude
Longitude

Categories Table
id-->PK
section_id ---> FK
parent_id ---> for categories and sub-categories
category_name-->
slug

categories_restaurants_table
id-> PK
category_id --> FK
restaurant_id --> FK

Now I want to establish this many-to-many relations in the Product Model... Is this possible? How can I insert update delete of categories_restaurants pivot table using this many-to-many relations? Can I use Restaurant and Category Table many to many relation in Product Model using Laravel? Please explain me with example

Answer 1

namespace App\Models;

class Restaurant extends Model
{
    public function categories()
    {
        return $this->belongsToMany(App\Models\Category::class);
    }
}

namespace App\Models;

class Category extends Model
{
    public function restaurants()
    {
        return $this->belongsToMany(App\Models\Restaurant::class);
    }
}

$restaurant = App\Models\Restaurant::find(1);
dd($restaurant->categories);

$categoryA = App\Models\Category::find(1);
$categoryB = App\Models\Category::find(2);
dd($categoryA->restaurants);

$restaurant->attach($categoryA);
$restaurant->dettach($categoryB);

$restaurant->sync([ 1, 2, 4 ]);