Laravel Database Query Not Returning Data

Question

The Query

$user_id = Auth::id();
$group_users = GroupUser::where('user_id', $user_id);
return view('groups.index', ['group_users' => $group_users]);

My Query has no errors

I need to list all rows from the group_users table with the the user ID that is equal to the

$user_id = Auth::id();

I am including the model with

use App\GroupUser;

And my table I am retrieving the data from has the following fields,

- group_id
- user_id
- user_role

And if I echo or print the

$user_id = Auth::id();

I get the correct user id. I'm not sure what I am missing.

u_mulder · Accepted Answer · 2018-01-07 12:44:39Z

3

GroupUser::where does not execute a query. To get results add get() chaining method:

$group_users = GroupUser::where('user_id', $user_id)->get();

answered Jan 7, 2018 at 12:44

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you it worked!!!! :D I will accept answer as soon as it lets me :D

LegoBoy · Accepted Answer · 2018-01-07 13:26:37Z

0

GroupUser::where('user_id', $user_id) just return a builder.If you want return data you can fix :

$group_users = GroupUser::where('user_id', $user_id)->first(); to return first data

or

$group_users = GroupUser::where('user_id', $user_id)->get(); to return all data of table GroupUser

answered Jan 7, 2018 at 13:26

LegoBoy

1405 bronze badges