I want to make a query that gets all the users from table "users" and i need to have only user.id.
$users = User::all();
this will get the whole model User but this is a real performance issue for my app. There is too much data going through.
I need to append some data for each user so i can calculate the working hours.
So the question is how to fetch all users without any other data except $user->id?
$name = DB::table('users')->select('id')->get();
For the certain columns, I think this is best:
$users = User::select('id')->get();
See Documentation.
how to fetch all users without any other data except $user->id, your code returns collection of User objects, test it.
$user->id?. It does not mean that Object/Array...Use the pluck() method:
$users = User::pluck('id');
The pluck method retrieves all of the values for a given key
pluck() method too.Getting all User objects with id only:
$users = User::select('id')->get();
Getting all id as straight int value
According to documentation: https://laravel.com/docs/5.3/queries#selects
Specifying A Select Clause (most efficient)
$users = DB::table('users')->select('id')->get();
Retrieving A Single Column From A Row (but this will process all columns)
$name = DB::table('users')->where('name', 'John')->pluck('name');
