Laravel?? ?? ??????? ????? ??

??

?? ????????? ??? ??? ??? ???? ?? ?? ??????? ????? ?? ??? ????. . Laravel? ?? ??????? ??????? ???? ??? ? ?? ??? ??? ???? ? ????? ??????.

DB Facade ??

Laravel?? ??? ??????? ?? ??? ?????, DB Facade? ?? ??? ?????. ??? ? ??? config/database.php ??? ?? ??? ?????.

?????? ?? ??

.env ?? config/database? ???? ?????? ??? ?????. .php ??. ??? .env? ???? ????.

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

DB_CONNECTION_PGSQL=pgsql
DB_HOST_PGSQL=127.0.0.1
DB_PORT_PGSQL=5432
DB_DATABASE_PGSQL=pgsql_database
DB_USERNAME_PGSQL=root
DB_PASSWORD_PGSQL=secret

config/database.php?? ??? ?? ??? ??? ? ????.

'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST'),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD')
],

'pgsql' => [
    'driver' => 'pgsql',
    'host' => env('DB_HOST_PGSQL'),
    'database' => env('DB_DATABASE_PGSQL'),
    'username' => env('DB_USERNAME_PGSQL'),
    'password' => env('DB_PASSWORD_PGSQL')
]

?? ?????? ??

??? ??? ? ??? ?? ?? ??? ???? ???? ? ????. ?:

// Database operations on 'mysql' database
$users = DB::connection('mysql')->select(...);

// Database operations on 'pgsql' database
$orders = DB::connection('pgsql')->select(...);

???, ?????? ? ?? ??

?? ???????? ???, ?????? ?? ?? ?? ??? ????? ?? ??:

// Schema operations on 'pgsql' database
Schema::connection('pgsql')->create('some_table', function($table) {});

// Migrations on 'mysql' database
Artisan::call('migrate', ['--connection' => 'mysql']);

// Query builder operations on 'pgsql' database
$results = DB::connection('pgsql')->select(...);

?? ? Eloquent

?? ?? Eloquent ??? ?? ??????? ????? ???? $connection ??? ?????:

// Model using 'pgsql' database
class User extends Model {
    protected $connection = 'pgsql';
}

???? ??

?? ???????? ????? ????? ????? ?????. ???:

DB::transaction(function () {
    DB::connection('mysql')->table('users')->update(['name' => 'John']);
    DB::connection('pgsql')->table('orders')->update(['status' => 'shipped']);
});

??? ?? ??

setConnection ??? ?? on static ???? ???? ?????? ??? ???? ??? ?? ????.

// Runtime connection change
$someModel = new SomeModel;
$someModel->setConnection('pgsql');

// Static connection change
$something = SomeModel::on('pgsql')->find(1);

??: ?????? ???? ??? ?? ??? ??? ?? ?????. ????? ???? ??? ? ????.

? ??? Laravel?? ?? ??????? ????? ???? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!