/PHP/Laravel/Many to many relationship laravel

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

1 vote238 views1 answer
Use model from variable laravel
PHP Laravel
3 votes313 views6 answers
Jwt laravel
PHP Laravel
5 votes240 views2 answers
Route() and with() in laravel
PHP Laravel
12 votes248 views6 answers
Laravel redirect back with input
PHP Laravel
18 votes247 views5 answers
If else statement in laravel blade
PHP Laravel
0 vote265 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
0 vote234 views2 answers
Login with email and phone laravel
PHP Laravel
1 vote231 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP Laravel
1 vote249 views1 answer
Laravel child relation order by desc
PHP Laravel
0 vote256 views1 answer
How to update request all value in laravel controller before save in database
PHP Laravel