Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?

by

With

with() is for eager loading. That basically means, along the main model, Laravel will preload the relationship(s) you specify. This is especially helpful if you have a collection of models and you want to load a relation for all of them. Because with eager loading you run only one additional DB query instead of one for every model in the collection.

Example:

User > hasMany > Post

$users = User::with('posts')->get();
foreach($users as $user){
    $users->posts; // posts is already loaded and no additional DB query is run
}

Has

has() is to filter the selecting model based on a relationship. So it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

Example:

User > hasMany > Post

$users = User::has('posts')->get();
// only users that have at least one post are contained in the collection

WhereHas

whereHas() works basically the same as has() but allows you to specify additional filters for the related model to check.

Example:

User > hasMany > Post

$users = User::whereHas('posts', function($q){
    $q->where('created_at', '>=', '2015-01-01 00:00:00');
})->get();
// only users that have posts from 2015 on forward are returned

More Related Contents:

  1. Laravel Eloquent vs DB facade: Why use Eloquent and decrease performance? [closed]
  2. Getting just the latest value on a joined table with Eloquent
  3. How to select specific columns in laravel eloquent
  4. Laravel save / update many to many relationship
  5. Get Specific Columns Using “With()” Function in Laravel Eloquent
  6. Migration: Cannot add foreign key constraint
  7. Laravel Eloquent groupBy() AND also return count of each group
  8. Eloquent Collection: Counting and Detect Empty
  9. Add a custom attribute to a Laravel / Eloquent model on load?
  10. Get the Query Executed in Laravel 3/4
  11. Eloquent eager load Order by
  12. Laravel. Use scope() in models with relation
  13. Laravel Eloquent “WHERE NOT IN”
  14. Laravel Migration Change to Make a Column Nullable
  15. Select Last Row in the Table
  16. How to get distinct values for non-key column fields in Laravel?
  17. How to Make Laravel Eloquent “IN” Query?
  18. Laravel Eloquent – Attach vs Sync
  19. How to access model hasMany Relation with where condition?
  20. Eloquent push() and save() difference
  21. Laravel Eloquent sort by relation table column
  22. Laravel Eloquent – distinct() and count() not working properly together
  23. First Or Create
  24. Laravel: Get pivot data for specific many to many relation
  25. Laravel: Returning the namespaced owner of a polymorphic relation
  26. How to setup conditional relationship on Eloquent
  27. Laravel Many to many self referencing table only works one way
  28. Polymorphic Eloquent relationships with namespaces
  29. Laravel Eloquent – Where In All
  30. Clone an Eloquent object including all relationships?

Leave a Comment