Two database connect in laravel

Question

How to connect two database in laravel-5 and how to get data from db.

I know two one thing for that

In config/database set like this.

    'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'larashop'),
        'username'  => env('DB_USERNAME', 'root'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

 'mysql2' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', 'localhost'),
            'database'  => env('DB_DATABASE', 'larashop2'),
            'username'  => env('DB_USERNAME', 'root'),
            'password'  => env('DB_PASSWORD', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

user5633496 · Accepted Answer · 2017-03-08 12:44:25Z

1

Using Query you can define a connection on the Query Builder:

$users = DB::connection('mysql2')->select('your query');

Using Eloquent You can also define which connection to use in your Eloquent models as well!

<?php

class SomeModel extends Eloquent {

    protected $connection = 'mysql2';

}

You can also define the connection at runtime via the setConnection method.

<?php

class SomeController extends BaseController {

    public function someMethod()
    {
        $someModel = new SomeModel;

        $someModel->setConnection('mysql2');

        $something = $someModel->find(1);

        return $something;
    }

}

answered Mar 8, 2017 at 12:44

user5633496

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

2 Comments

user5633496 Over a year ago

There are some tutorial for this. i get referce from that. fideloper.com/laravel-multiple-database-connections laracasts.com/discuss/channels/general-discussion/…

Kanu Over a year ago

This code is okk but Remove connection code from .evn.

Kanu · Accepted Answer · 2017-04-03 09:56:58Z

1

I have find the issue of connect 2 database in laravel.

If any body wants two work with 2 database then config as par above suggestion and remove database configuration from .env file which is located at root.

I have tried and I am working with 2 database.

answered Apr 3, 2017 at 9:56

Kanu

576 bronze badges

Collectives™ on Stack Overflow

Two database connect in laravel

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related