Laravel eloquent with

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 remove from db

public function destroy($id){

  $res=User::find($id)->delete();
  if ($res){
    $data=[
    'status'=>'1',
    'msg'=>'success'
  ];
  }else{
    $data=[
    'status'=>'0',
    'msg'=>'fail'
  ];
  return response()->json($data);

Source: stackoverflow.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 vote236 views2 answers
Add blade in blade laravel
PHP Laravel
1 vote224 views1 answer
How delete the table in laravel in the commend
PHP Laravel
33 votes234 views6 answers
Create migration command in laravel
PHP Laravel
49 votes244 views6 answers
Laravel clear all cache
PHP Laravel
16 votes261 views5 answers
Laravel one command for model table and controller
PHP Laravel
0 vote255 views1 answer
Laravel print builder
PHP Laravel
23 votes235 views4 answers
Laravel change foreign key name
PHP Laravel
7 votes250 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
0 vote228 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
3 votes273 views2 answers
How to get file extension in laravel
PHP Laravel