Many to many relationship laravel

WhereHas site:https://laravel.com/docs/

use Illuminate\Database\Eloquent\Builder;

// Retrieve posts with at least one comment containing words like code%...
$posts = Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'code%');
})->get();

// Retrieve posts with at least ten comments containing words like code%...
$posts = Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'code%');
}, '>=', 10)->get();

Source: laravel.com

Laravel pivot table model

/*Model - Service*/
public function customer(){
    return $this->belongsToMany('customer')->withPivot(
        'start_date',
        'stop_date',
        'rem_date',
        'due_date',
        'status'
        );
}

/*Model - customer*/
public function services(){
    return $this->belongsToMany('Service')->withPivot(
        'start_date',
        'stop_date',
        'rem_date',
        'due_date',
        'status'
        );
}

////These following relations didnt workout
/*Model - custserv*/ //uses the pivot table customer_service//
public function staff(){
    return $this->belongsToMany('Staff');
}

/*Model - Staff*/
public function custservs(){
    return $this->belongsToMany('Custserv');
}

/*schema for pivot table 'staff' and 'Custserv' */
Schema::create('customer_service_user', function(Blueprint $table)
    {
        $table->increments('id');
        $table->integer('customer_service_id')->unsigned()->index();
        $table->foreign('customer_service_id')->references('id')->on('customer_service')->onDelete('cascade');
        $table->integer('staff_id')->unsigned()->index();
        $table->foreign('staff_id')->references('id')->on('staff')->onDelete('cascade');
        $table->timestamps();
    });

Source: stackoverflow.com

Many to many relationship laravel

use App\Models\User;

$user = User::find(1);

$user->roles()->attach($roleId);

Source: laravel.com

Many to many relationship laravel example

<?php namespace App; use Illuminate\Database\Eloquent\Model; class UserRole extends Model{     }

Source: itsolutionstuff.com

Similar codes

48 votes160 views6 answers
Php find in array
PHP
2 votes112 views1 answer
Download speed limit php
PHP
0 vote126 views2 answers
Display money format php
PHP
0 vote110 views1 answer
Change php version in vagrant
PHP
0 vote151 views4 answers
Laravel get last created id
PHP Laravel
0 vote128 views1 answer
Php get first digit of number
PHP
1 vote108 views1 answer
Laravel date rule before 18 years ago
PHP
0 vote131 views1 answer
Laravel API Endpoint "401 Unauthorized" on Server But Works Fine On Localhost
PHP Laravel
0 vote141 views1 answer
Check if column has value in laravel eloquent
PHP Laravel
0 vote134 views1 answer
Woocommerce mini cart ajax count
PHP