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

4 votes371 views4 answers
Laravel carbon today date format
PHP Laravel
0 vote432 views1 answer
Laravel creating event get data
PHP Laravel
47 votes377 views6 answers
How to run specific seeder in laravel
PHP Laravel
14 votes374 views3 answers
How to convert string to int in php laravel
PHP Laravel
0 vote368 views1 answer
Laravel passport vue 401 Unauthorized
PHP Laravel
0 vote400 views1 answer
Laravel recursive relationships
PHP Laravel
33 votes328 views6 answers
Migrate specific migration laravel
PHP Laravel
0 vote354 views1 answer
Laravel lang with parameter
PHP Laravel
1 vote395 views1 answer
What is app_env in laravel
PHP Laravel
1 vote349 views1 answer
Php laravel string substring
PHP Laravel