Relationship in 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

How to use where relationship laravel

Event::with(["owner", "participants" => function($q) use($someId){
    $q->where('participants.IdUser', '=', 1);
    //$q->where('some other field', $someId);
}])

Source: stackoverflow.com

Eloquent relationships

$roles = App\User::find(1)->roles()->orderBy('name')->get();

Source: laravel.com

Laravel how to query belongsTo relationship

$movies = Movie::whereHas('director', function($q) {
    $q->where('name', 'great');
})->get();

Source: stackoverflow.com

Relationship in laravel

N + 1
return new SongsCollection(Song::with('album')->get());

'songs' => SongResource::collection($this->whenLoaded($this->songs))

Laravel relationship

$comment = Post::find(1)->comments()
                    ->where('title', 'foo')
                    ->first();

Source: laravel.com

Similar codes

2 votes325 views2 answers
Laravel dropIndex
PHP Laravel
0 vote356 views1 answer
Set custome table laravel eloquent
PHP Laravel
1 vote403 views3 answers
Laravel convert timestamp to date
PHP Laravel
7 votes316 views5 answers
Laravel slug
PHP Laravel
28 votes334 views6 answers
Laravel drop foreign key
PHP Laravel
2 votes352 views2 answers
Laravel/ui for laravel 7
PHP Laravel
2 votes320 views2 answers
Laravel whereIn example
PHP Laravel
9 votes344 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
16 votes352 views6 answers
Confirm password validation laravel
PHP Laravel
21 votes336 views6 answers
Laravel route parameters
PHP Laravel