Breaking News: Grepper is joining You.com. Read the official announcement!

how can we use multiple database in laravel

Add Answer

Tyagi420 answered on November 30, 2020 Popularity 9/10 Helpfulness 2/10

answer how can we use multiple database in laravel

related connect multiple database in laravel

related use multiple database in laravel

how can we use multiple database in laravel

Comment

## config/database.php
$mysql = [
    'driver' => 'mysql',
    'url' => env('DATABASE_URL'),
    'host' => env('DB_HOST', '127.0.0.1'),
    'port' => env('DB_PORT', '3306'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'unix_socket' => env('DB_SOCKET', ''),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'prefix_indexes' => true,
    'strict' => true,
    'engine' => null,
    'options' => extension_loaded('pdo_mysql') ? array_filter([
        PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
    ]) : [],
];

return [
    'default' => 'laravelEcommerce',
    'connections' => [
        'laravelEcommerce' => array_merge($mysql, [
            'database' => 'laravelEcommerce',
        ]),
        'demohrm' => array_merge($mysql, [
            'database' => 'demohrm',
        ]),
    ],
  ]
  
 ## Define code in model
class Employee extends Model
{
    protected $connection = 'demohrm';
    protected $table = 'employees';
    protected $primaryKey = 'id';
    public $timestamps = false;
  
    public function __construct()
    {
        parent::__construct(...func_get_args());
    }
}

Popularity 9/10 Helpfulness 2/10 Language php

Source: Grepper

Tags: database laravel php

Link to this answer
Share Copy Link

Contributed on Mar 28 2023

Tyagi420

0 Answers Avg Quality 2/10

Closely Related Answers

connect multiple database in laravel

Comment

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db_crm
DB_USERNAME=root
DB_PASSWORD=secret

DB_CONNECTION_SECOND=mysql_customer
DB_HOST_SECOND=127.0.0.1
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=db_customer
DB_USERNAME_SECOND=root
DB_PASSWORD_SECOND=secret

//config/database.php

 'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

 'mysql_customer' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST_SECOND', '127.0.0.1'),
            'port' => env('DB_PORT_SECOND', '3306'),
            'database' => env('DB_DATABASE_SECOND', 'forge'),
            'username' => env('DB_USERNAME_SECOND', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_PASSWORD_SECOND', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],
		
		
// eg: from CustomerController.php

return DB::table('customers')->get();


return DB::connection('mysql_customer')->table('crm_customers')->get();	
//or	
return Customers::all();


// eg: from Customers.php

class Customers extends Model
{
	use HasFactory;
	protected $connection = 'mysql_customer';
}

Popularity 7/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: connect database

Link to this answer
Share Copy Link

Contributed on Jun 25 2024

@CodeGrepperManu

0 Answers Avg Quality 2/10

use multiple database in laravel

Comment

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database1
DB_USERNAME=root
DB_PASSWORD=secret

DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=127.0.0.1
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=database2
DB_USERNAME_SECOND=root
DB_PASSWORD_SECOND=secret

Popularity 10/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Nov 30 2020

@codebraker

0 Answers Avg Quality 2/10

use multiple database in laravel

Comment

return array(

    'default' => 'mysql',

    'connections' => array(

        # Primary/Default database connection
        'mysql' => array(
            'driver'    => 'mysql',
            'host'      => '127.0.0.1',
            'database'  => 'database1',
            'username'  => 'root',
            'password'  => 'secret'
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),

        # Secondary database connection
        'mysql2' => array(
            'driver'    => 'mysql',
            'host'      => '127.0.0.1',
            'database'  => 'database2',
            'username'  => 'root',
            'password'  => 'secret'
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
    ),
);

Popularity 10/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Nov 30 2020

@codebraker

0 Answers Avg Quality 2/10

how can we use multiple database in laravel

Contents

More Related Answers

how can we use multiple database in laravel

Closely Related Answers

connect multiple database in laravel

use multiple database in laravel

use multiple database in laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.