Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

david2000's avatar

Question about the connection for a user

I have for my table 'Student' 5 fields id, name, firstname, email, phone.

My question: I would like the user to connect by putting his name what should I change?

    public function index(Request $request)
        {   
            $user = $request->user();
            $students= Student::query()
            ->when($user->hasRole('admin') !== true, function (Builder $query) use ($user) {
                $query->where('email', $user->email);
            })
            ->when($request->has('search'), function (Builder $query) use ($request) {
                $query->where('name', 'like', '%'.$request->input('search').'%');
            })
            ->paginate(5);
    
            
    
        return view('admin.students.index', compact('students'))
            ->with('display_search', $user->hasRole('admin'));
        }

Here:

    $query->where('email', $user->email);

I have to put this?

      $query->where('name', $user->name);

Thank you for your help.

0 likes
1 reply
Ashraam's avatar

I don't understand why you are trying to achieve here. Is there any errors ?

Please or to participate in this conversation.