Forum Getting all records from a collection

scc-lee

posted 9 years ago

Database Eloquent

Last updated 2 years ago.

rickshawhobo

replied 9 years ago

$users = User::with('roles')->all();

scc-lee

replied 9 years ago

Solution

Thanks the full solution I ended up with was this.

User::with('roles')->get();

Then pass that to the view with

return view('admin.users.index')->with('users', $users);

And loop through the results like so:

@foreach ($users as $user)
	<tr>
		<td>{!! $user->id !!}</td>
		<td>{!! $user->name !!}</td>
		<td>{!! $user->email !!}</td>
		<td>{!! $user->created_at !!}</td>
		<td>{!! $user->updated_at !!}</td>
		<td>
		
			@foreach ($user->roles as $role)
			{!! $role->name !!}<br />
			@endforeach
		
		</td>
	</tr>
	@endforeach