您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

laravel5 中 关联查询

2026/1/9 17:25:56发布14次查看
有这么一组数据
一个学生表users 和 学生成绩表 grades 两个表关联
在方法里面是这样的
public function index(){ $result = user::where('is_admin', 0); $users = $result->get(); $count = $result->count(); return view('admin.list', compact('count', 'users'));}

视图循环是这样的
@foreach ($users as $user) {{$user->id}} {{$user->name}} {{$user->grade->math}} {{$user->grade->english}} {{$user->grade->c}} {{$user->grade->sport}} {{$user->grade->think}} {{$user->grade->soft}}
@endforeach

得到的结果是 报错 trying to get property of non-object (view:
$user->grade->math

是找不到的 怎么做关联一起呢
回复内容: 有这么一组数据
一个学生表users 和 学生成绩表 grades 两个表关联
在方法里面是这样的
public function index(){ $result = user::where('is_admin', 0); $users = $result->get(); $count = $result->count(); return view('admin.list', compact('count', 'users'));}

视图循环是这样的
@foreach ($users as $user) {{$user->id}} {{$user->name}} {{$user->grade->math}} {{$user->grade->english}} {{$user->grade->c}} {{$user->grade->sport}} {{$user->grade->think}} {{$user->grade->soft}}
@endforeach

得到的结果是 报错 trying to get property of non-object (view:
$user->grade->math

是找不到的 怎么做关联一起呢
user.php
public function grade() { return $this->hasone('app\grade'); }
grade.php
public function user() { return $this->belongsto('app\user'); }
phpuser.php定义public function grade() { return $this->hasone(app\modules\grade, 'user_id', 'id'); }controller.phppublic function index(){ $result = user::where('is_admin', 0); $users = $result->grade()->get(); $count = $result->count(); return view('admin.list', compact('count', 'users'));}view:@foreach ($users as $user) {{$user->id}} {{$user->name}} {{$user->math}} {{$user->english}} {{$user->c}} {{$user->sport}} {{$user->think}} {{$user->soft}}
@endforeach
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product