Laravel / encrypt decrypt user table

Question

I want to encrypt data fields of user table and i don't want to break the the laravel default Auth functionality.

I want something like this

DB::table('client')->insertGetId(
        array(
        'name'  =>DB::raw("AES_ENCRYPT('".$data['name']."', '".env('DB_ENCRYP_KEY')."')"), 
        'email' => DB::raw("AES_ENCRYPT('".$data['email']."', '".env('DB_ENCRYP_KEY')."')"), 
        'password' => DB::raw("AES_ENCRYPT('".$data['password']."', '".env('DB_ENCRYP_KEY')."')")

        )

);

want to use ASE_ENCRYPT in query level. I just need to know where can i find the raw MySQL query for Laravel authentication module. So i can change those query like this. what is the file name ?

Joseph Silber · Accepted Answer · 2015-09-16 22:01:04Z

1

Instead of using auth()->attempt(), query for the user yourself, then use the login method.

For example, in your controller's login method:

public function login()
{
    $user = User::where(...)->first();

    if ($user) {
        auth()->login($user);

        return redirect()->intended();
    }

    return redirect()->back()->withErrors('Wrong credentials');
}

answered Sep 16, 2015 at 22:01

Joseph Silber

221k59 gold badges369 silver badges292 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Eduardo Reveles · Accepted Answer · 2015-09-16 22:28:44Z

0

If you mean using the default app created with the laravel new command, then you are looking for the create method in AuthController.php (app/Http/Controllers/Auth/AuthController.php)

The create method is called from the trait RegistersUsers.php wrapped in an Auth::login method, so just be sure to return an instance of your User model instead of just the ID (as with the insertGetId method)

answered Sep 16, 2015 at 22:28

Eduardo Reveles

2,17517 silver badges14 bronze badges

Collectives™ on Stack Overflow

Laravel / encrypt decrypt user table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related