Laravel 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

Get all data eloquent laravel

Blog::all();

//example usage.
$posts = Blog::all();

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 vote355 views1 answer
How to Add Custom Navigation Menus in WordPress Themes
PHP Wordpress
0 vote290 views1 answer
Php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider
PHP
0 vote242 views1 answer
Fatal error: cannot redeclare
PHP
4 votes320 views4 answers
Laravel check if table has column
PHP Laravel
0 vote297 views1 answer
Add variables to line in laravel notification
PHP
0 vote300 views1 answer
How to get event dates on change in datetimepicker with laravel livewire
PHP
0 vote268 views1 answer
Php download temp file
PHP
0 vote307 views1 answer
Php get long word in array
PHP
4 votes289 views2 answers
PHP Deprecated: Function create_function()
PHP
0 vote318 views1 answer
Laravel php 8 ububtu
PHP Laravel