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 vote214 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel
2 votes189 views5 answers
Undefined index: name laravel
PHP Laravel
0 vote191 views1 answer
Optimistic Locking Laravel
PHP Laravel
0 vote187 views1 answer
Laravel add model to polymorphic relationships
PHP Laravel
2 votes187 views1 answer
Delete confirmation destroy laravel
PHP Laravel
0 vote194 views1 answer
Menyimpan get di laravel
PHP Laravel
2 votes193 views1 answer
Laravel meilisearch flush
PHP Laravel
0 vote194 views2 answers
View blade not found in laravel
PHP Laravel
1 vote193 views1 answer
Laravel 8 $request->intersect not working
PHP Laravel
1 vote206 views1 answer
Laravel date rule before 18 years ago
PHP Laravel