Laravel belongs to

Laravel where has

use Illuminate\Database\Eloquent\Builder;

// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
})->get();

// Retrieve posts with at least ten comments containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
}, '>=', 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

Laravel belongs to

    public function user()
    {
        return $this->belongsTo(User::class);
    }

Source: laravel.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

Similar codes

5 votes333 views4 answers
Laravel collection merge
PHP Laravel
0 vote369 views1 answer
Laravel eloquent get x number of results
PHP Laravel
0 vote353 views1 answer
Laravel cookie (flash meesage for time)
PHP Laravel
0 vote366 views1 answer
Laravel route limit parameter
PHP Laravel
7 votes352 views2 answers
Php laravel between dates
PHP Laravel
0 vote355 views1 answer
Laravel create new file if not exists
PHP Laravel
13 votes327 views4 answers
Laravel login by id
PHP Laravel
30 votes327 views6 answers
Laravel migration column types
PHP Laravel
4 votes320 views4 answers
Chunk in laravel
PHP Laravel
1 vote351 views1 answer
Laravel form action with parameter
PHP Laravel