eloquent laravel How to get a row count from a - get

Question

I m having a lot of trouble figuring out how to use this collection to count rows     wordlist    DB  table  wordlist  - gt where  id     lt      correctedComparisons                  - gt get      I have tried adding- gt count   but didn t work  I have tried doing count  wordlist   I m not really sure what to do without needing a second request as a- gt count   method

User · Answer

also  you can fetch all data and count in the blade file  for example   your code in the controller   posts   Post  all    return view  post   compact  posts       your code in the blade file       posts- gt count        finally  you can see the total of your posts

User · Answer

Direct get a count of row   Using Eloquent     Useing Eloquent   count   Model  count            example               count1   Wordlist  count      Using query builder     Using query builder   count    DB  table  table name  - gt count        example   count2    DB  table  wordlist  - gt where  id     lt      correctedComparisons - gt count

User · Answer

Answer has been updated  count is a Collection method  The query builder returns an array  So in order to get the count  you would just count it like you normally would with an array    wordCount   count  wordlist     If you have a wordlist model  then you can use Eloquent to get a Collection and then use the Collection s count method  Example    wordlist   Wordlist  where  id     lt      correctedComparisons - gt get     wordCount    wordlist- gt count      There is was a discussion on having the query builder return a collection here  https   github com laravel framework issues 10478  However as of now  the query builder always returns an array   Edit  As linked above  the query builder now returns a collection  not an array   As a result  what JP Foster was trying to do initially will work    wordlist    DB  table  wordlist  - gt where  id     lt      correctedComparisons              - gt get     wordCount    wordlist- gt count      However  as indicated by Leon in the comments  if all you want is the count  then querying for it directly is much faster than fetching an entire collection and then getting the count  In other words  you can do this      Query builder  wordCount    DB  table  wordlist  - gt where  id     lt      correctedComparisons              - gt count        Eloquent  wordCount   Wordlist  where  id     lt      correctedComparisons - gt count

User · Answer

Its better to access the count with the laravels count method    count   Model  where  status       1  - gt count      or   count   Model  count

[php] eloquent laravel: How to get a row count from a ->get()

Examples related to php

Examples related to sql

Examples related to laravel

Examples related to eloquent