/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 vote218 views2 answers
Cart::subtotal in laravel
PHP Laravel
1 vote233 views1 answer
Docx file validation laravel 8
PHP Laravel
0 vote238 views1 answer
Laravel range query
PHP Laravel
0 vote225 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
12 votes237 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
0 vote276 views1 answer
Count column eloquent laravel
PHP Laravel
0 vote234 views2 answers
Laravel log could not be opened fix
PHP Laravel
2 votes215 views1 answer
Laravel artisan create criteria
PHP Laravel
46 votes291 views6 answers
Add column to migration laravel
PHP Laravel
0 vote213 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel