send login information to the bank for comparison

Question

I am developing a system with login and password, using Windows. The registration part was even easy:

public function salvar(){
    $usu_email = Request()->input('usu_email');
    $usu_senha = Request()->input('usu_senha');
    $usu_tipo = Request()->input('usu_tipo');

    DB::insert('INSERT INTO usr_usuario (usu_email, usu_senha, usu_tipo) VALUES (?, md5(?), ?)', array($usu_email, $usu_senha, $usu_tipo));

    return redirect() ->action('ProjetoController@inicio');
}

But in the part of sending the information to the bank and comparing them I am a little confused. In the bank I have the following script that will make the comparison:

 select usu_codigo,usu_tipo 
 from usr_usuario
 where usu_email=:usu_email
 and usu_senha=md5(:usu_senha)

But I don’t know how I do in my Projectocontroller.php to send the information. I believe it’s something similar to sending to the bank on the record.

Answer 1

You can use the authentication itself Laravel already offers.

At the beginning of your controller give a "use Auth;" to use the class Auth inside your controller.

public function authenticate()
{
    if ( Auth::attempt(['email' => $email, 'password' => bcrypt( $password ) ])) {
        // Autenticação autorizada...
    }
}