Laravel custom login username and password mapping

Question

I am upgrading a legacy application. I am using Laravel 8 without ORM with DB first approach since the DB is already there.

I want to use

$credentials = $request->only('email', 'password');
if (Auth::attempt($credentials)) {
        $request->session()->regenerate();
        return redirect()->intended('shop');
    }

When I am configuring auth.php I saw inside the providers 'driver' => 'database' was commented. I want to use auth.php providers like following

'providers' => [
    // 'users' => [
    //     'driver' => 'eloquent',
    //     'model' => App\Models\User::class,
    // ],

    'users' => [
        'driver' => 'database',
        'table' => 'shop_users',
    ],
]

Is there any way I can map the user name password like following

'providers' => [
    // 'users' => [
    //     'driver' => 'eloquent',
    //     'model' => App\Models\User::class,
    // ],

    'users' => [
        'driver' => 'database',
        'table' => 'shop_users',
        'username' => 'email',       //Mapping auth username to table column
        'password' => 'password'     //Mapping auth password to table password
    ],
]

Answer 1

Make sure this model call is extended Authenticatable

we need to add a new function inside app/Http/Auth/LoginController.php like below:

public function username(){ 
    return 'email'; // this string is column of shop_users table which we are going use for login 
}