Laravel - find info in db using request parameter

Question

I am building a API using laravel, and i am trying to create a function to find a user in data base using a email as a parameter

public function find_user(Request $request){
    try{
        $user = UserAccess::table('user_accesses')->where('email', $request->email)->first();
        return ['api_request_return'=>'ok', 'return' => $user];

    }catch(\Exception $error){
        return ['api_request_return' => 'error', 'error_details' => $error];
    }
}

The API route is ok, but its always returning error:

{
     "api_request_return": "error",
     "error_details": {}
}

Please try to use DB::table('user_accesses')->where('email', $request->email)->first(); — Ashiq Hassan
– Ashiq Hassan, Commented May 9, 2020 at 19:53
Because you are using DB and Eloquent together. Kindly use one. — Akhtar Munir
– Akhtar Munir, Commented May 9, 2020 at 19:54
Or, go with the model way i.e. UserAccess::where('email', $request->email)->first(); — kidA
– kidA, Commented May 9, 2020 at 20:31

Ashiq Hassan · Accepted Answer · 2020-05-09 20:07:43Z

1

Use the corrected one

public function find_user(Request $request){
    try{
        $user = DB::table('user_accesses')->where('email', $request->email)->first();
        return ['api_request_return'=>'ok', 'return' => $user];

    }catch(\Exception $error){
        return ['api_request_return' => 'error', 'error_details' => $error];
    }
}

answered May 9, 2020 at 20:07

Ashiq Hassan

4286 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Leonan Müller Over a year ago

When i try to use DB::table, its warning "Undefined type 'DB'.intelephense(1009)"

Leonan Müller Over a year ago

from IDE ibb.co/Rzv0TW0, but when i make request, is returning null value: { "api_request_return": "ok", "return": null }

Ashiq Hassan Over a year ago

Check whether user_accesses table have the given email record in database. Its return null when not found

Leonan Müller Over a year ago

This is the table: ibb.co/q0H2SNY and GET request: ibb.co/P5qqMZ4

Ashiq Hassan Over a year ago

Please dd the value $request->email ->>>>>>>>>>>>>> die(print_r($request->email)) and check whether variable has value in it

|

Collectives™ on Stack Overflow

Laravel - find info in db using request parameter

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related