在laravel 5.5中试图获得非物体的性质

Question

我试图显示我的变量值来查看页面，但是它显示了试图获取非对象属性的错误。谁来帮帮我。这是我的财务总监-

public function myAffiliates(Request $request) {
    if ($user_id = Sentinel::getUser()->id) {
        $affiliates = DB::table('affiliate_users')
          ->where('affiliate_users.user_id', $user_id)
          ->first();
    }
    //dd($affiliates);
    return view('dashboard.affiliates.show',['affiliates' => $affiliates]);
}

我给我的视图页写了这样的信-

@foreach ($affiliates as $affiliate)
    <ul>
        <li>First Upline - {{ $affiliate->first_upline_id }} Pts,</li>
        <li>Second Upline - {{ $affiliate->second_upline_id }} Pts,</li>
        <li>Third Upline - {{ $affiliate->third_upline_id }} Pts.</li>
    </ul>
@endforeach

Answer 1

使用first()检索单个对象

使用get()检索集合并在刀片上迭代它

Answer 2

您正在尝试迭代对象的属性，尝试如下

<ul>
        <li>First Upline - {{ $affiliates->first_upline_id }} Pts,</li>
        <li>Second Upline - {{ $affiliates->second_upline_id }} Pts,</li>
        <li>Third Upline - {{ $affiliates->third_upline_id }} Pts.</li>
</ul>