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

Question

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 I've 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);
        }
    }
}

question from:https://stackoverflow.com/questions/65854800/message-undefined-property-illuminate-database-query-buildertoken

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();