在为变量分配ID时，尝试在Laravel中获取非对象错误的属性

Question

1. I'm getting the row in the following code :

$grpusrow = DB::table('grpusrs') 
                       ->where('group_id', $id)
                      ->where('user_id', $u_id)
                      ->get();

1. And then getting the ID in this line :

$grpusrid = $grpusrow->id;

1. I receive the following error on the line in number 2 :

Trying to get property of non-object

Answer 1

->get() will always return multiple objects at once. You're simply not telling it which index of $grpusrow to get the ID from.

$grpusrows = DB::table('grpusrs') 
                    ->where('group_id', $id)
                    ->where('user_id', $u_id)
                    ->get();

foreach ($grpusrows as $grpusrow) {
    dump($grpusrow->id);
}

// Or

$grpusrow = DB::table('grpusrs') 
                    ->where('group_id', $id)
                    ->where('user_id', $u_id)
                    ->first();

dump($grpusrow->id);