Level 4
$activeCustomers = Customer::where('active', 1)->get(); //query builder
$activeCustomers = Customer::all()->where('active', 1); //Laravel collection
Query builder is always faster
4 likes
Jul 11, 2019
5
Level 2
all() vs get() - Laravel Eloquent
which better between these lines? and why?
$activeCustomers = Customer::all()->where('active', 1);
$activeCustomers = Customer::where('active', 1)->get();
Level 32
use 1st option, it runs on the Database side.
1 like
Level 42
User::all() and User::get() will do the exact same thing.
all() is a static method on the Eloquent\Model. All it does is create a new query object and call get() on it. With all(), you cannot modify the query performed at all (except you can choose the columns to select by passing them as parameters).
get() is a method on the Eloquent\Builder object. If you need to modify the query, such as adding a where clause, then you have to use get(). For example, User::where('name', 'David')->get();
6 likes
Level 8
Shame on me. I've learnt that just now. I thought I could use get and all interchangeably until my code failed.
1 like
Level 9
I learned it months ago, and it still trips me up at least weekly. Too much to keep in the head all the time.
Please or to participate in this conversation.