从数据库中获取国家列表，并尝试在null上读取属性"country_name“

Question

当我试图在Laravel 8上展示我的学生时，我遇到了一些错误，首先不是创建学生，然后我在/ show /页面上出现了错误

试图在null上读取属性"country_name“

index.blade.php

  <tbody id="allocate-table-body">
                                        @foreach($students as $student)
                                        <tr class="id-card">
                                            <td><a target="_blank"  href=""> {{$student->id}}</a></td>
                                            <td> {{$student->name}}</td>
                                            <td>{{$student->countries->country_name}}</td>
                                            <td>{{$student->phone}}</td>
                                            <td>{{$student->work}}</td>
                                            <td>{{$student->group}}</td>
                                            <td>{{$student->email}}</td>
                                            <td><a class="btn btn-success" href="#">edit</a></td>
                                        </tr>
                                        @endforeach
                                        </tbody>

学生模型

    class Student extends Model
{
    use HasFactory;
    public $fillable = [
        'name',
        'marital',
        'gender',
        'country',
        'city',
        'education',
        'work',
        'phone',
        'group',
        'email',
        'description'
    ];
    public function countries()
    {
        return $this->belongsTo(Country::class);
    }

}

国家模式

    class Country extends Model
{
    protected $fillable = ['id', 'phone_code', 'country_code', 'country_name'];
    use HasFactory;
    public function student()
    {
        return $this->hasMany(Student::class);
    }
}

studentController

 public function index(Request $request)
{
    $students = Student::paginate(50);
    $countries = DB::table('countries')->get();
    return view('students.index', compact( 'students','countries'));
}

Answer 1

既然foreignKey不是laravel公约，所以你必须提到foreignKey in belongsTo.I相信foreignKey is country in Student Table

public function countries()
{
    return $this->belongsTo(Country::class,'country','id');
}

和乡村模式

 public function student()
    {
        return $this->hasMany(Student::class,'country','id');
    }

然后你可以访问

 $students = Student::with('countries')->paginate(50);

BelongsTo方法描述

belongsTo($related, $foreignKey = null, $ownerKey = null, $relation = null)