Laravel where has Relation

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 get data if has relation in laravel

Doctor::has('DoctorMessage')->with('DoctorMessage')->get()

Laravel how to query belongsTo relationship

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

Source: stackoverflow.com

Laravel where has Relation

// Laravel 8+ or above
$projects = Project::whereRelation('projectOffers', ['teacher_id'=>'Naveed', 'status_id'=>'Approved'])->where('status_id', "In Progress")->get();

// Laravel 8 below
$projects = Project::whereHas('projectOffers', function ($offer) {
            $offer->where('teacher_id', "Naveed");
            $offer->where('status_id', "Approved");
        })->where('status_id', "In Progress")->get();

Similar codes

0 vote190 views1 answer
Pdo php search table
PHP
0 vote191 views3 answers
Remove string after comma in php
PHP
0 vote203 views1 answer
Wordpress html classes
PHP Wordpress
0 vote186 views1 answer
Password required wp
PHP
0 vote195 views1 answer
Twig log variable
PHP
21 votes190 views2 answers
Php unset by value
PHP
12 votes335 views4 answers
Laravel call controller method from another controller
PHP
35 votes179 views6 answers
Laravel make auth
PHP
0 vote183 views1 answer
Php 8 constructor promotion
PHP
5 votes187 views6 answers
Hello world in php
PHP