Laravel retrieve data from multiple tables

Question

Its my Db structure I have a student table as

students 
+-------+--------+----------+
|id     |  name  | group_id | 
+-------+--------+----------+                
|1      |  ali   |     1    |
|2      |  ahmad |     2    |
+-------+--------+----------+

groups
+------+-------------+
|id    |  group_name |
+------+-------------+                
|1     |     A       |
|2     |     B       |
+------+-------------+

Now I have to show Name from student table and group_name from Groups

StudentController

{
        $students = Student::orderBy('id', 'desc')->get();
        return view('student.index')->with(compact('students'));
    }

My View

@foreach($students as $student)

<td>{{ $student->name }}</td>
<td {{ $student->group_name }} </td>

Please help me to retrieve record from both tables I try with different methods but failed

Filip Koblański · Accepted Answer · 2016-10-27 11:27:55Z

2

You need to add relation method to the Student class:

public function group()
{
    return $this->belongsTo(Group::class);
}

where Group is a model's class of a groups table.

Then in the controller:

{
    $students = Student::orderBy('id', 'desc')->with('group')->get();
    return view('student.index')->with(compact('students'));
}

and in the view:

@foreach($students as $student)

<td>{{ $student->name }}</td>
<td {{ $student->group->name }} </td>

answered Oct 27, 2016 at 11:27

Filip Koblański

10k4 gold badges33 silver badges37 bronze badges

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

6 Comments

Ramzan Mahmood Over a year ago

what do you mean by student class where i have to add relation ?@Fillip Koblariski

Filip Koblański Over a year ago

Here: Student::orderBy('id', 'desc')->get(); <- Student is a class that extends the eloquent model's

Ramzan Mahmood Over a year ago

it says public undefined syntax error, unexpected 'public' (T_PUBLIC) @Fillip Koblariski

Filip Koblański Over a year ago

Show your Student class

Ramzan Mahmood Over a year ago

'<?php namespace App; use Illuminate\Database\Eloquent\Model; class Student extends Model { protected $fillable = ['name', 'group_id']; } public function group() { return $this->belongsTo(Groups::class); }'

|

Balraj Allam · Accepted Answer · 2016-10-27 12:08:20Z

0

One student belongs to only one group. so, relationship between the student and group is one to one.

In Students.php Model

public function group(){
   return $this->hasOne(Group::class,'id','group_id');
}

and in view you can get group name as

@foreach($students as $student)
      <td>{{ $student->name }}</td>
      <td>{{ $student->group->name }}</td>
@endforeach

edited Oct 27, 2016 at 12:08

answered Oct 27, 2016 at 12:02

Balraj Allam

6116 silver badges26 bronze badges

Collectives™ on Stack Overflow

Laravel retrieve data from multiple tables

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related