Eloquent with

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

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

Laravel eloquent with

$books = Book::with(['author', 'publisher'])->get();

Source: laravel.com

Eloquent with

use App\Models\User;

$users = User::with(['posts' => function ($query) {
    $query->where('title', 'like', '%code%');
}])->get();

# Select columns

Post::query()
    ->with(['user' => function($query) {
        $query->select('id','username');
    }])
    ->get();

Source: laravel.com

Laravel eloquent with

$users = User::with('podcasts')->get();

foreach ($users->flatMap->podcasts as $podcast) {
    echo $podcast->subscription->created_at;
}

Source: laravel.com

Similar codes

0 vote211 views1 answer
Laravel make migration controller resource mcr
PHP Laravel
1 vote222 views1 answer
Laravel validation in controller
PHP Laravel
2 votes235 views2 answers
How to add recaptcha to woocommerce register php
PHP
0 vote191 views1 answer
Ip condition in php
PHP
3 votes185 views1 answer
Wordpress get domain
PHP Wordpress
0 vote195 views1 answer
Implement class in autoloader athow to implment data table in laravel project
PHP Laravel
10 votes212 views4 answers
Laravel migration set default value
PHP Laravel
53 votes248 views6 answers
Check laravel version
PHP Laravel
0 vote197 views1 answer
Get data from 2 table in response laravel
PHP
13 votes196 views5 answers
Laravel get last record
PHP