如何使用Laravel显示与用户相关的记录int配置文件

Question

我想将记录显示到与用户相关的用户配置文件中。我正在尝试这样做，不幸的是，它并没有显示和用户相关的记录。如何做到这一点？

数据库

digitizing_orders table has user_id      

数字化订单

class Digitizingorder extends Model
{
protected $table="digitizing_orders";
public function user()
{
return $this->belongsTo('AppUser');
}
}

用户模型

class User extends Authenticatable
{
public function digitizing()
{
return $this->hasMany('AppDigitizingorder','user_id');
}
}

控制器

public function index()
{
$data=
[
'digitizings'=>Digitizingorder::with('user')->where('id','=',Auth::id())->get()
];
return view('front_end.Customerprofile.digitizing_view_order',$data);
}

@foreach($digitizings  as   $digitizing)
<tr>
<td>1</td>
<td>DPO-{{$digitizing->id}}</td>
<td>{{$digitizing->order_name}}</td>
<td>{{$digitizing->created_at}}</td>
<td>-</td>
<td>$0.00</td>           
</tr>
@endforeach

Answer 1

由于您有hasMany关系，您可以获得如下的数字化：

public function index()
{
$data=
[
'digitizings'=>Auth::user()->digitizing()->get()
];
return view('front_end.Customerprofile.digitizing_view_order',$data);
}

这将获得经过身份验证的用户的订单。