php - "message": "Undefined property: Illuminate\Database\Query\Builder::$token"

Question

Hello I keep getting this error when trying to verify the hashed token with the unhashed token . "message": "Undefined property: IlluminateDatabaseQueryBuilder::$token", Can someone please help me since ive been stuck on this error for nearly 2 hours now.

public function verifyResetPageAccess(Request $request){
        $email = $request->email; 
        $token = $request->token;

        // $exists = password_reset::where('email', $email)->first();
        $exists = DB::table('password_resets')->where('email',$email);
        $dbToken = $exists->select('token');

        if($exists === null){
            return response(['message'=>'unauthorized'],401);
            
        }else{
          if(Hash::check($token, $dbToken->token))  {
              return response(['message'=>'authorized']);
          }else{
              return response(['message'=>'error occured'],401);
          }
         
        }

    }

Answer 1

The problem is because you are trying to get a field value directly on a Builder. you should use get() or first() to run the query and get the result before trying to get field value. You can change this line to get the result:

$dbToken = $exists->select('token');

it should become

$dbToken = $exists->select('token')->first();