Eloquent Collection Counting and Detect Empty

Question

This may be a trivial question but I am wondering if Laravel recommends a certain way to check whether an Eloquent collection returned from  result   Model  where     - gt get   is empty  as well as counting the number of elements   We are currently using   result to detect empty result  is that sufficient  As for count  result   does it actually cover all cases  including empty result

User · Accepted Answer

When using - gt 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- gt first         if    result- gt isEmpty        if   result- gt count        if  count  result         You could also use - gt first   instead of - gt 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     - gt first    if   result            Notes   References   - gt first   http   laravel com api 4 2 Illuminate Database Eloquent Collection html method first isEmpty   http   laravel com api 4 2 Illuminate Database Eloquent Collection html method isEmpty - gt count   http   laravel com api 4 2 Illuminate Database Eloquent Collection html method count count  result  works because the Collection implements Countable and an internal count   method  http   laravel com api 4 2 Illuminate Database Eloquent Collection html method count   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 - gt all   - gt first   - gt 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    Laravel 5 2 Collection Class Laravel 5 2 Query Builder

User · Answer

You can do    result   Model  where     - gt count       to count the results    You can also use   if   result- gt isEmpty        to check whether or not the result is empty

User · Answer

According to Laravel Documentation states you can use this way     result- gt isEmpty      The isEmpty method returns true if the collection is empty  otherwise  false is returned

User · Answer

so Laravel actually returns a collection when just using Model  all    you don t want a collection you want an array so you can type set it   array Model  all    then you can use array filter to return the results   models    array Model  all    models   array filter  models   if empty  models      do something     this will also allow you to do things like count

User · Answer

I agree the above approved answer  But usually I use  results- gt isNotEmpty   method as given below   if  results- gt isNotEmpty        do something     It s more verbose than if  results- gt isEmpty    because sometimes we forget to add      in front which may result in unwanted error   Note that this method exists from version 5 3 onwards

User · Answer

I think you are looking for    result- gt isEmpty     This is different from empty  result   which will not be true because the result will be an empty collection  Your suggestion of count  result  is also a good solution  I cannot find any reference in the docs

User · Answer

There are several methods given in Laravel for checking results count check empty not empty    result- gt isNotEmpty       True if result is not empty   result- gt isEmpty       True if result is empty   result- gt count       Return count of records in result

User · Answer

I think better to used   result- gt isEmpty         The isEmpty method returns true if the collection is empty  otherwise    false is returned

User · Answer

You can use   counter   count  datas

User · Answer

I think you try something like       if   result- gt isEmpty                 result is not empty      else             result is empty      endif   or also use  if    result      if   result

User · Answer

------SOLVED------ in this case you want to check two type of count for two cace case 1  if result contain only one record other word select single row from database using - gt first    if count  result                    record is exist true         case 2  if result contain set of multiple row other word using - gt get   or - gt all     if  result- gt count                       record is exist true

[laravel] Eloquent Collection: Counting and Detect Empty

Bonus Information

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent

Examples related to laravel-collection