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

3 votes136 views5 answers
Laravel permission
PHP
0 vote165 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
0 vote118 views1 answer
Download html table to excel
PHP
-1 vote143 views1 answer
Views_pre_view
PHP
16 votes127 views6 answers
Laravel redirect back
PHP
0 vote180 views1 answer
Laravel after method()
PHP
-2 votes102 views1 answer
Php boolean
PHP
1 vote148 views2 answers
Join multiple query in laravel
PHP
0 vote155 views1 answer
Laravel checkbox checked
PHP
4 votes96 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel