Laravel

When working with database query results, it is often useful to obtain only the total number of rows in a result set, instead of pulling the full dataset content with a regular query. Eloquent offers a few different aggregate methods that return a scalar value instead of an Eloquent object, such as count(), max(), and sum(). In this part of the series, you’ll update the main application view to show the total number of links in each list, using the count() method.

In a previous part of this series, you learned how to obtain database records using the all() method from within an Eloquent model, sorting the resulting collection with the sortDesc() method. In this guide, you’ll learn how to use the orderBy() method to sort results in the database query itself, which offers more flexibility and performance to order query results at the database level.