Many to Many Relationship

Many to Many Relationship

Demo details:

Business Rules:

Relations Diagram:

Relationship Details:

Eloquent Models:

class Driver
{
    public function cars()
    {
       return $this->belongsToMany(Car::class);
    }
}

class Car
{
    public function drivers()
    {
        return $this->belongsToMany(Driver::class);
    }
}

Database Migrations:

Schema::create('drivers', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('cars', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('car_driver', function (Blueprint $table) {
    $table->increments('id');

    $table->integer('car_id')->unsigned()->index();
    $table->foreign('car_id')->references('id')->on('cars')->onDelete('cascade');

    $table->integer('driver_id')->unsigned()->index();
    $table->foreign('driver_id')->references('id')->on('drivers')->onDelete('cascade');
});

Store Records:

// Create relation between Driver and Car.

$driver->cars()->attach([
   $car1->id,
   $car2->id,
]);

// Or use the sync() function to prevent duplicated relations.

$driver->cars()->sync([
   $car1->id,
   $car2->id,
]);

// Create relation between Car and Driver.

$car->drivers()->attach([
   $driver1->id,
   $driver2->id,
]);

// Or use the sync() function to prevent duplicated relations.

$car->drivers()->sync([
   $driver1->id,
   $driver2->id,
]);

Retrieve Records:

// Get Driver Car

$driver->cars

// Get Car Drivers

$car->drivers