Database Connection From Session in Laravel

Question

I have multiple database connection, but for perusahaan db connection I want set database_name from session. how to resolve it?

.

online Thomas · Accepted Answer · 2019-01-11 12:51:53Z

2

You could do this:

config(['database.connections.perusahaan.database' => session('db_key')]);

You set a config variable runtime with the config helper by passing a value to it from the session helper. The way you do it fails, because session is not yet available while reading config.

I would like to add a warning that you might trust data that should not be trusted, however I do not know enough about your app to be certain.

answered Jan 11, 2019 at 12:51

online Thomas

9,4887 gold badges52 silver badges94 bronze badges

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

Comments

Vincent Mimoun-Prat · Accepted Answer · 2019-01-11 13:53:29Z

0

You need to do that at runtime, it cannot be done directly from the configuration file.

config(['database.connections.perusahaan.database' => session('db_key')]);

You may also need to purge the connection as it may be cached

app(DatabaseManager::class)->purge('perusahaan');

answered Jan 11, 2019 at 13:53

Vincent Mimoun-Prat

28.6k16 gold badges85 silver badges126 bronze badges

Collectives™ on Stack Overflow

Database Connection From Session in Laravel

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