CODEWITHSUNDEEP
phpmysqllaravellaravel-5
Joshua Belarmino
Joshua Belarmino

Reputation: 546

How can I list the database connections in Laravel 5?

How can I get the list of database connections in Laravel. I'm planning to load the connection names into a select box.

'connections' => [
    'sqlsrv_auth' => [
        'driver'   => 'sqlsrv',
        'host'     => env('DB_HOST', 'SQLEXPRESS'),
        'database' => env('DB_DATABASE', 'auth_db'),
        'username' => env('DB_USERNAME', 'sa'),
        'password' => env('DB_PASSWORD', '1234'),
        'charset'  => 'utf8',
        'prefix'   => '',
    ],
    'sqlsrv' => [
        'driver'   => 'sqlsrv',
        'host'     => env('DB_HOST', 'SQLEXPRESS'),
        'database' => env('DB_DATABASE', 'main_db'),
        'username' => env('DB_USERNAME', 'sa'),
        'password' => env('DB_PASSWORD', '1234'),
        'charset'  => 'utf8',
        'prefix'   => '',
    ],
    'sqlsrv_bpb' => [
        'driver'   => 'sqlsrv',
        'host'     => env('DB_HOST', '192.168.1.1'),
        'database' => env('DB_DATABASE', 'mirror'),
        'username' => env('DB_USERNAME', 'sa'),
        'password' => env('DB_PASSWORD', '1234'),
        'charest'  => 'utf8',
        'prefix'   => '',
    ]

],

Upvotes: 3

Views: 6584

Answers (2)

Joshua Belarmino
Joshua Belarmino

Reputation: 546

Got it..

use Config;

public function test() {
    print_r(Config::get('database'));
}

Upvotes: 8

shalini
shalini

Reputation: 1300

secondDb variable now hold connection of 'sqlsrv_bpb' (Name of connection) 

$secondDb =  DB::connection('sqlsrv_bpb');

Upvotes: 0

Related Questions