How to Use Multiple Database Connections in Laravel Application

Posted 8 years ago By Ajay Gupta 39329

When you need multiple database connection in Laravel PHP then you can use DB facade via connection method.

In other way you can simply setup another database connection in config/database.php and then you create protected variable for connection like this protected $connection = 'mysql_2';

Here is a simple step to use multiple database connection in Laravel.

Setup multiple database

Create another database connection by this way :

        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'database'  => 'xyz',
            'username'  => 'root',
            'password'  => '',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
        'mysql1' => array(
            'driver'    => 'mysql',
            'host'      => 'localhost',
            'database'  => 'abc',
            'username'  => 'root',
            'password'  => '',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),

		'mysql' => array(			'driver'    => 'mysql',			'host'      => 'localhost',			'database'  => 'xyz',			'username'  => 'root',			'password'  => '',			'charset'   => 'utf8',			'collation' => 'utf8_unicode_ci',			'prefix'    => '',		),		'mysql1' => array(			'driver'    => 'mysql',			'host'      => 'localhost',			'database'  => 'abc',			'username'  => 'root',			'password'  => '',			'charset'   => 'utf8',			'collation' => 'utf8_unicode_ci',			'prefix'    => '',		),

Now as per need create database connection variable in your model.

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
{
 protected $connection = 'mysql1';
}

<?phpnamespace App;use Illuminate\Database\Eloquent\Model;class Product extends Model{ protected $connection = 'mysql1';}

As i create connection variable in Product model then it tells that product model is using second database connection.

Here you can also use config helper function to set dynamically database connection or change database config at runtime.

Click here to know more How to set and get config variable in Laravel 5

How to Use Multiple Database Connections in Laravel Application

How to Use Multiple Database Connections in Laravel Application

Tags :

Related Posts