Dynamic database connection in Laravel

Question

I know that in Laravel you can use multiple database connections by specifying them in the config/database.php file, then using DB::connection('my_conn_name'), but is there anyway to use a connection that is not specified in the config/database.php file?

I am writing an archiving application, so the user can specify what connection they would like to use for the process (host, user and password), and I am hoping that I can return the results from show databases for the supplied connection.

user2094178 · Accepted Answer · 2016-07-08 16:26:18Z

0

After the user has specified the db parameters you could store it in a session to populate a custom connection at config/database.php:

'connections' => [

    'mysql' => [
        '...'
    ],

    'testing' => [
        '...'
    ],

    'custom' => [
        'driver'    => 'mysql',
        'host'      => session()->get()->db_host,
        'database'  => session()->get()->db_database,
        'username'  => session()->get()->db_username,
        'password'  => session()->get()->db_password,
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ]

]

answered Jul 8, 2016 at 16:26

user2094178

9,47410 gold badges45 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Dynamic database connection in Laravel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related