dynamic database when user login

That my friend is a really bad idea.

You only need one database, just make sure that you have a user_id in each of your tables then you will have the same end result as a database per user.

The only reason that I can see to keep them in seperate databases is if you have absurdly large data in the tables and lots of traffic but then maybe you shouldn't use a single app but rather one for each user/set of users.

Seems like a really weird idea, since you are a beginner maybe explain why you think this is neccessary

thanks for reply

my boss let me do this i'm not clearly purpose of him but i think it should be can just change database connection when user login if anyone know help please i trying so long time

if you want create table after login or after registration ? Or you want to create new database? @nithapple

i have database already but i just want to switch database connection and use the same modal in laravel

'mysql2' => array( 'driver' => 'mysql', 'host' => 'host2', 'database' => 'database2', 'username' => 'user2', 'password' => 'pass2' 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ),

addthis this in the app/config/database.php

$users = DB::connection('mysql2')->select(...); use this in the model

@nithapple

also you can reffer this https://fideloper.com/laravel-multiple-database-connections

yes i know but i need dynamic when login i'm using auth

currently you are using laravel auth or custom login

now i'm using auth

can i connect with you?

@nithapple can you try storing the connection name in session data and use the variable.

You can refer to https://laravel.com/docs/6.x/session.

@nithapple you can edit and asign the database in /controller/auth/LoginController.php

@nithapple is that solved or what ?