Laravel - How to use other table except users table for login?

Question

I have written a PHP based Web Application several years ago in Plain PHP. Now for some reason, I want to upgrade that project in Laravel. But I face a problem when I want to Laravel default authentication (which is done by php artisan make:auth).

Because, the old project uses user_account to store user info (username, password, and so on), but so far what I know, Laravel uses users table to store user information.

There is no way to rename user_account to users to solve the issue.

Is there any way to user_account in Laravel so that Laravel uses that table during login, registration, and so on..

Thanks

Jinal Somaiya · Accepted Answer · 2019-07-17 09:33:45Z

3

you can try with adding below line in your User Model(User.php).

protected $table = 'user_account';

answered Jul 17, 2019 at 9:33

Jinal Somaiya

1,99117 silver badges31 bronze badges

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

Comments

Mayank Pandeyz · Accepted Answer · 2019-07-17 09:51:31Z

1

From Laravel Eloquent Model naming convention documentation:

By convention, the "snake case", plural name of the class will be used as the table name unless another name is explicitly specified. You may specify a custom table by defining a table property on your model:

protected $table = 'table_name';

So in your case you can go to the User model and override its default (plural name case) table binding and define:

protected $table = 'user_account';

I think this will solve your issue.

answered Jul 17, 2019 at 9:51

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Comments

Jinal Somaiya · Accepted Answer · 2019-07-17 12:04:10Z

1

Simple and Sweet, Go to the User.php file (User Model)

protected $table = 'user_account';

edited Jul 17, 2019 at 12:04

Jinal Somaiya

1,99117 silver badges31 bronze badges

answered Jul 17, 2019 at 9:36

Sush Sun

212 bronze badges

Comments

nasirkhan · Accepted Answer · 2019-07-17 15:38:32Z

1

You have change in a number of places to achieve this goal.

Model

update user model from app/User.php, if you have not changed the default path

protected $table = 'users';

Controller

on the RegisterContoller you need to update the validation rules, where it checks the unique email.

answered Jul 17, 2019 at 15:38

nasirkhan

10.7k5 gold badges29 silver badges37 bronze badges

Comments

Long mom · Accepted Answer · 2019-07-17 09:31:23Z

0

I have same problem like this. My problems is transfer data from Wordpress to java spring boot and problem is users table.So my solution is force to encrypt password in old project( Plain PHP) and used it on laravel project.

answered Jul 17, 2019 at 9:31

Long mom

113 bronze badges

Comments

Josep Feixas · Accepted Answer · 2019-07-17 09:34:09Z

0

Try to go to the USER model and rename the table name to the one you want, adding this line:

protected $table = 'user_account';

This way I dont think you shouldn't need to change much of code, and you will change the default "users" name to your custom one.

You should also be able to modify the fields in the "protected $fillable" array. However I'm not sure if all of this has some issue in the core code.

answered Jul 17, 2019 at 9:34

Josep Feixas

519 bronze badges

Collectives™ on Stack Overflow

Laravel - How to use other table except users table for login?

6 Answers 6

Comments

Comments

Comments

Model

Controller

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Model

Controller

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related