how to view different data from same row in laravel 8

Question

Here you can see I can store two different team names in my table .

This is my database

I want to view them in my index.blade.php so I did this in my index.blade.php but it`s showing team 1 name everytime.

<table id="example1" class="table table-bordered table-striped table-sm">
<thead>
  <tr>
     <th>SL</th>
     <th>Match Name</th>
     <th>Match Slug</th>
     <th>Team 1 Name</th>
     <th>Team 2 Name</th>
     <th>Action</th>
     </tr>
</thead>
<tbody>
     @foreach ($data as $key => $row)
     <tr>
     <td>{{ $key + 1 }}</td>
     <td>{{ $row->match_name }}</td>
     <td>{{ $row->match_slug }}</td>
     <td>{{ $row->team->team_name }}</td>
     <td>{{ $row->team->team_name }}</td>
     </tr>
@endforeach
</tbody>
</table>

This is my index method

public function index()
{
   $data=Matchh::all();
   $team=Team::all();
   return view('admin.manage.matchh.index', compact('data','team'));
}

You need to fix your query, try joining the match table to your team table — VLDCNDN
– VLDCNDN, Commented Apr 10, 2022 at 3:08
I can store different team name you can see my database have different team id I just only wants to view team — Shahed Khan
– Shahed Khan, Commented Apr 10, 2022 at 3:12

Suhasini · Accepted Answer · 2022-04-10 04:02:44Z

1

 Try this apply this code
 
     $Matchh = DB::table('Matchh')
                ->join('Team', 'Matchh.team_id', '=', 'Team.team_id')
                ->join('Team', 'Matchh.team2_id', '=', 'Team.team2_id')
                ->select('Matchh.matchh_name','Matchh.matchh_slug','Team.team1_name','Team.team2_name_')
                ->get();

answered Apr 10, 2022 at 4:02

Suhasini

1011 silver badge4 bronze badges

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

Comments

Faizul Islam · Accepted Answer · 2022-04-10 08:39:52Z

0

you need a self join per reference table. Try this:

  $result = DB::select('SELECT
  m.match_name,
  m.match_slug,
  t1.team_name as team1_name,
  t2.team_name as team2_name

  FROM matchh as m
  LEFT JOIN team as t1 ON m.team_id = t1.id
  LEFT JOIN team as t2 ON m.team2_id = t2.id');
  return $result;

answered Apr 10, 2022 at 8:39

Faizul Islam

776 bronze badges

Collectives™ on Stack Overflow

how to view different data from same row in laravel 8

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related