Laravel foreach same record multiple

Question

I'm trying to take our some info from mysql with laravel. My controller:

$match->message = DB::table('log')->where('match_id', '=', $match->match_id)->get(['message']);

$match->authid = DB::table('log')->where('match_id', '=', $match->match_id)->get(['authid']);

My blade:

 @foreach ($match->authid as $username)
@foreach ($match->message as $text)
{{ $username->authid }} {{ $text->message }}<br />
@endforeach
@endforeach

But getting 4 results incorrectly. Getting:

AUTHD_ID1 log1
AUTHD_ID1 log2
AUTHD_ID2 log1
AUTHD_ID2 log2

Should be:

AUTHD_ID1 log1
AUTHD_ID2 log2

Whats wrong?

Why not get(['message', 'authid'])?

u_mulder
– u_mulder

2018-06-18 11:14:51 +00:00
Commented Jun 18, 2018 at 11:14 — u_mulder
– u_mulder, Commented Jun 18, 2018 at 11:14

u_mulder · Accepted Answer · 2018-06-18 11:17:15Z

3

It is being duplicated since you have a foreach within a foreach.

Try the code below.

$matches = DB::table('log')->where('match_id', '=', $match->match_id)->get();

@foreach ($matches as $match)
{{ $match->authid }} {{ $match->message }}<br />
@endforeach`

edited Jun 18, 2018 at 11:17

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

answered Jun 18, 2018 at 11:16

undrftd

3412 silver badges10 bronze badges

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

11 Comments

ром Макаров Over a year ago

Your code works great! U made me on the right road! Thanks! Another question: I have users table with row called 'auth_id' and 'username'. How can i convert to auth_id to username? Thanks for helping!

undrftd Over a year ago

Can you elaborate on what you mean by converting auth_id into username?

ром Макаров Over a year ago

Example: Users table has row called 'auth_id' and 'username'. My table 'log' also have row called 'auth_id'. I need to find same 'auth_id' on users table and get username by that 'auth_id'. Example: AUTH_ID1 to USERNAME5654 :) Sorry if my english is not unreadable :)

undrftd Over a year ago

For this matter, you need to use joins. You have to join the users table and log table using the auth_id column. Here's a sample query: $username = \DB::table('users')->join('log', 'users.auth_id', 'log.auth_id')->select('users.username')->get(); Try to refer to this link for more information: laravel.com/docs/5.6/queries#joins

ром Макаров Over a year ago

Oh everything works fine. But with username again i'm getting foreach not correctly.

$match->messages = DB::table('log')->where('match_id', '=', $match->match_id)->get(); $match->messages->username = DB::table('users')->join('log', 'users.steam_id', 'log.authid')->select('users.username')->get();

and foreach in my view:

@foreach ($match->messages as $message) @foreach ($match->messages->username as $username) {{ $username->username }}: {{ $message->message }}@endforeach @endforeach

|

SynapseIndia · Accepted Answer · 2018-06-18 11:19:41Z

0

Try below

$match->message = DB::table('log')->where('match_id', '=', $match->match_id)->get(['message','authid']);
@foreach ($match->message as $text)
{{ $text->authid }} {{ $text->message }}
@endforeach

answered Jun 18, 2018 at 11:19

SynapseIndia

4502 silver badges10 bronze badges

Comments

dekts · Accepted Answer · 2018-06-18 11:26:23Z

0

If you need only two field data then you don't have to build two query in multiple variable you can do like below:

$data = DB::table('log')->where('match_id', '=', $match->match_id)->get(['authid','message']);

@if ($data)
    @for ($i = 0; $i < count($data); $i++)
        {{ $data[$i]->authid }} {{ $data[$i]->message }}
    @endfor
@endif

Using above code you will never get error in foreach if you didn't get data from $data variable

edited Jun 18, 2018 at 11:26

answered Jun 18, 2018 at 11:21

dekts

8306 silver badges21 bronze badges

Collectives™ on Stack Overflow

Laravel foreach same record multiple

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related