Dynamic Database Connection Using Laravel

Question

I am working on a new application that must connect to several databases. The databases are dynamically created when a new company is registered in my application i.e each company have there on databases.

My question is how to establish the database connection using laravel,

If the company admin is login he needs to connect the corresponding db. How is it possible ???

I know how to establish multiple database connection if the databases are stable, like,

'mysql1' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge1'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
...

'mysql2' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge2'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
...

but if the databases are not stable how is it possible ????

If my question is not up to standard, please forgive me

N69S · Accepted Answer · 2018-11-16 10:28:21Z

You can add dynamically the database configuration like this.

if(NULL === config()->get('database.connections.company')){
        config()->set('database.connections.company', [
            'driver'    => $companyDbDriver,
            'host'      => $companyDbHost,
            'port'      => $companyDbPort,
            'database'  => $companyDbName,
            'username'  => $companyDbUser,
            'password'  => $companyDbPassword,
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false
        ]);
    }

in the model; set the connection attribute to 'company'

/**
 * Connection configuration ID.
 *
 * @var string
 */
protected $connection = 'company';

there are complication if you dont load the configuration of the database before calling the models using it, i'll leave that to you.

simonecosci · Accepted Answer · 2018-11-16 10:33:41Z

First you have to know where your database connections parameters are stored. Anyway, wherever they are, you should create a new connection on the fly. Supposing each User has it's own connection ...

<?php
use Illuminate\Support\Facades\Config;

$user = Users::find($id);
Config::set('database.connections.' . $user->username, array(
        'driver'    => 'mysql',
        'host'      => $user->db_host,
        'database'  => $user->db_name,
        'username'  => $user->db_user,
        'password'  => $user->db_pass,
            'charset'   => 'utf8',
        'collation' => 'utf8_general_ci',
        'prefix'    => '',
));
// And set the new connection to interested models
$myModel = new MyModel;
$myModel->setConnection($user->username);
$data = $myModel->where(...)->get();

Hope this help

Collectives™ on Stack Overflow

Dynamic Database Connection Using 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