Laravel, how to append new connection in config/database.php file?

Question

My goal is to append/generate new connection in config/database.php file right after I created new database trough DB::statement

There is a similar question here, but the problem is that it is pre-defined in config/database.php.

web.php (route)

Route::get('test', function(){

    DB::statement('CREATE DATABASE testDB;'); //create database

    //append/generate new connection in config/database.php logic here

    DB::connection('testDB')->table('some_tables'); //would like to connect this newly created database but config/database.php havent setup yet
});

config/database.php

Would like to see it is edited on the fly like this below. But I don't have any idea how to do it without manually editing the actual file. Assume the driver, host, port, username and password are the same.

'testDB' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'port'      => '1234',
        'database'  => 'testDB',
        'username'  => 'root',
        'password'  => '',
    ],

Can you clarify - should the new database connection be permanently saved in config/database.php? — ceejayoz
– ceejayoz, Commented Jan 30, 2019 at 14:15
How often are new databases created? How many do you anticipate winding up with? — ceejayoz
– ceejayoz, Commented Jan 30, 2019 at 14:18
depends on the admin...maybe 10 database/month...or maybe more — LearnProgramming
– LearnProgramming, Commented Jan 30, 2019 at 14:19
You may want to consider other approaches, like a multi-tenant database structure. — ceejayoz
– ceejayoz, Commented Jan 30, 2019 at 14:22

Tudor · Accepted Answer · 2019-01-30 18:20:27Z

2

This should work

Route::get('test', function(){
    DB::statement('CREATE DATABASE testDB;'); //create database

    config(['database.testDB' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'port'      => '1234',
        'database'  => 'testDB',
        'username'  => 'root',
        'password'  => '',
    ]]);

    DB::connection('testDB')->table('some_tables'); //would like to connect this newly created database but config/database.php havent setup yet
});

edited Jan 30, 2019 at 18:20

answered Jan 30, 2019 at 14:10

Tudor

1,8983 gold badges13 silver badges24 bronze badges

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

3 Comments

ceejayoz Over a year ago

Note, however, that this won't persist - it doesn't update the config file. Subsequent pageviews won't have the new connection.

LearnProgramming Over a year ago

hmm...it does not update the database.php file...it stay the same...btw, you have some typo there should be closing ]]);

Tudor Over a year ago

Right, sorry about that, fixed the typo. Good point @ceejayoz, this doesn't actually write to database.php, it just sets a new config option for the duration of the process.

Collectives™ on Stack Overflow

Laravel, how to append new connection in config/database.php file?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related