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

7 votes206 views3 answers
Laravel where has
PHP Laravel
1 vote213 views1 answer
AUTO_INCREMENT in laravel
PHP Laravel
1 vote189 views1 answer
Laravel add crf token form
PHP Laravel
10 votes215 views2 answers
ForeignId in laravel
PHP Laravel
15 votes200 views3 answers
Get id user login laravel
PHP Laravel
18 votes198 views4 answers
Use if in laravel blade
PHP Laravel
0 vote195 views1 answer
Running laravel project in mobile phone
PHP Laravel
0 vote219 views1 answer
Install sass laravel
PHP Laravel
29 votes203 views6 answers
Laravel timestamp
PHP Laravel
0 vote195 views1 answer
Delete image s3 laravel
PHP Laravel