Using foreach in Laravel 5.1

Question

I'm new in Laravel. I'm storing 3 types of user in my users table:

admin : user_type_id = 1
agent : user_type_id = 2
farmer : user_type_id = 3

user_type_id column is in the users table.

In one of my Blade files, I want to only show the names of the agents. Here is my foreach loop, which is importing all 3 types of the user (it's showing the names of admins, agents and farmers).

@foreach($farmerPoint->user as $agent)
<tr>
  <td>{{ $agent->name }}</td>
  <td>{{ $agent->phone }}</td>
</tr>
@endforeach

I believe you just want to wrap your <tr>...</tr> contents in something like this: @if ($agent->user_type_id === 2) <tr> ... </tr> @endif - see the Laravel Templates docs section titled If Statements — random_user_name
– random_user_name, Commented Dec 10, 2015 at 21:16
Can @cale_b's answer be accepted, Noob? Answer acceptance is not mandatory on Stack Overflow, but it is encouraged, because it is helpful both to the answerer and to other readers. — halfer
– halfer, Commented Jan 26, 2018 at 0:07

random_user_name · Accepted Answer · 2015-12-10 21:24:39Z

1

This is probably more of a logic issue than a Laravel issue. NOTE that I would suggest you limit the $agents instead using your query (where) rather than this way, BUT:

@foreach($farmerPoint->user as $agent)
    @if ($agent->user_type_id === 2) 
            <tr>
                  <td>{{ $agent->name }}</td>
                  <td>{{ $agent->phone }}</td>

            </tr>
    @endif
@endforeach

answered Dec 10, 2015 at 21:24

random_user_name

26.3k7 gold badges81 silver badges119 bronze badges

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

Comments

Steve Bauman · Accepted Answer · 2015-12-10 21:28:50Z

1

You can use a simple blade @if() statement like so:

@foreach($farmerPoint->user as $agent)
    @if ($agent->user_type_id === 2)
    <tr>
        <td>{{ $agent->name }}</td>
        <td>{{ $agent->phone }}</td>

    </tr>
    @endif
@endforeach

Or you can use a collection where() since all eager / lazy loaded relations are returned in collections:

http://laravel.com/docs/5.1/collections#method-where

@foreach($farmerPoint->user->where('user_type_id', 2) as $agent)
     <tr>
        <td>{{ $agent->name }}</td>
        <td>{{ $agent->phone }}</td>

    </tr>
@endforeach

edited Dec 10, 2015 at 21:28

answered Dec 10, 2015 at 21:23

Steve Bauman

8,7688 gold badges45 silver badges56 bronze badges

1 Comment

random_user_name Over a year ago

Nice. Didn't know about where being available at this level. Cool!

Collectives™ on Stack Overflow

Using foreach in Laravel 5.1

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related