Custom authentification query

@victordbu The name column should contain unique values only. Authentication mechanisms should not rely on the order rows are stored in a database table.

In my case it does (https://stackoverflow.com/questions/51222052/laravel-login-only-with-password) . Please point me in the right direction I only need to add that order by clause in the query what do I need to change? Where should I start? Please help

You would need to implement a custom authentication user provider. Have a look at Illuminate\Auth\EloquentUserProvider, you can lift most of the logic from there. Then you need to replace the provider in your auth config. Have a look at the documentation on creating custom authentication guards and providers.

That being said though, this is an indication of a very bad authentication mechanism which you should change if possible.

If I add the orderby in the return in the Illuminate\Auth\EloquentUserProvider it works. How can I create a custom user provider to override only this method?

`public function retrieveByCredentials(array $credentials) { if (empty($credentials) || (count($credentials) === 1 && array_key_exists('password', $credentials))) { return; }

// First we will add each credential element to the query as a where clause.
// Then we can execute the query and, if we found a user, return it in a
// Eloquent User "model" that will be utilized by the Guard instances.
$query = $this->createModel()->newQuery();

foreach ($credentials as $key => $value) {
    if (Str::contains($key, 'password')) {
        continue;
    }

    if (is_array($value) || $value instanceof Arrayable) {
        $query->whereIn($key, $value);
    } else {
        $query->where($key, $value);
    }
}

// return $query->first();

return $query->orderBy('id', 'desc')->first(); }`