Eloquent Collection: Counting and Detect Empty

by

When using ->get() you cannot simply use any of the below:

if (empty($result)) { }
if (!$result) { }
if ($result) { }

Because if you dd($result); you’ll notice an instance of Illuminate\Support\Collection is always returned, even when there are no results. Essentially what you’re checking is $a = new stdClass; if ($a) { ... } which will always return true.

To determine if there are any results you can do any of the following:

if ($result->first()) { } 
if (!$result->isEmpty()) { }
if ($result->count()) { }
if (count($result)) { }

You could also use ->first() instead of ->get() on the query builder which will return an instance of the first found model, or null otherwise. This is useful if you need or are expecting only one result from the database.

$result = Model::where(...)->first();
if ($result) { ... }

Notes / References

Bonus Information

The Collection and the Query Builder differences can be a bit confusing to newcomers of Laravel because the method names are often the same between the two. For that reason it can be confusing to know what one you’re working on. The Query Builder essentially builds a query until you call a method where it will execute the query and hit the database (e.g. when you call certain methods like ->all() ->first() ->lists() and others). Those methods also exist on the Collection object, which can get returned from the Query Builder if there are multiple results. If you’re not sure what class you’re actually working with, try doing var_dump(User::all()) and experimenting to see what classes it’s actually returning (with help of get_class(...)). I highly recommend you check out the source code for the Collection class, it’s pretty simple. Then check out the Query Builder and see the similarities in function names and find out when it actually hits the database.

More Related Contents:

  1. Migration: Cannot add foreign key constraint
  2. Laravel Eloquent groupBy() AND also return count of each group
  3. Eloquent eager load Order by
  4. Laravel. Use scope() in models with relation
  5. Laravel Eloquent “WHERE NOT IN”
  6. How to access model hasMany Relation with where condition?
  7. Eloquent push() and save() difference
  8. Laravel save / update many to many relationship
  9. First Or Create
  10. Laravel: Returning the namespaced owner of a polymorphic relation
  11. Polymorphic Eloquent relationships with namespaces
  12. Clone an Eloquent object including all relationships?
  13. How to select from subquery using Laravel Query Builder?
  14. Laravel 4 All Routes Except Home Result in 404 Error
  15. global variable for all controller and views
  16. How can I remove a package from Laravel using PHP Composer?
  17. Laravel Eloquent vs DB facade: Why use Eloquent and decrease performance? [closed]
  18. multiple mail configurations
  19. Laravel – Forbidden You don’t have permission to access / on this server
  20. Getting just the latest value on a joined table with Eloquent
  21. Rollback one specific migration in Laravel
  22. Laravel Eloquent – Attach vs Sync
  23. How to create a subquery using Laravel Eloquent?
  24. Validation of array form fields in laravel 4 error
  25. Laravel 4: Failed to open stream: Permission denied
  26. Natural ORDER in Laravel Eloquent ORM
  27. Find or Create with Eloquent
  28. Laravel: Change base URL?
  29. How to setup conditional relationship on Eloquent
  30. Laravel Eloquent – Where In All

Leave a Comment