How to use 2 or multiple connections in Cakephp 3.x?

Question

I’m making a system where it takes information from 2 different databases, how can I take the data and differentiate it into the controller and view of Cakephp 3.x? Thanks for the help.

Answer 1

Inside your Appcontroller, insert the two forms of connection (don’t forget to keep the standard format of cake there in the app.php with the database you will use the most - to make your life easier right?!), then just make the connections using the classes

protected function conectarBancoCliente() {
        $configuration = [
            'className' => 'Cake\Database\Connection',
            'driver' => 'Cake\Database\Driver\Mysql',
            'persistent' => false,
            'host' => 'localhost',
            'username' => 'SEUUSERNEME',
            'password' => 'SUASENHA',
            'database' => 'SEUBANCO',
            'encoding' => 'utf8',
            'timezone' => 'UTC',
            'cacheMetadata' => true,
            'quoteIdentifiers' => false,
            'log' => false,
            'url' => env('DATABASE_TEST_URL', null),
        ];
        ConnectionManager::config('default', $configuration);

        $conn = ConnectionManager::get('default');

        return $conn;
    }

protected function conectarBancoAdm() {
    $configuration = [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'persistent' => false,
        'host' => 'localhost',
        'username' => 'SEUUSERNAME',
        'password' => 'SUASENHA',
        'database' => 'SEUBANCO',
        'encoding' => 'utf8',
        'timezone' => 'UTC',
        'cacheMetadata' => true,
        'quoteIdentifiers' => false,
        'log' => false,
        'url' => env('DATABASE_TEST_URL', null),
    ];
    ConnectionManager::config('adminitrador', $configuration);

    $conn = ConnectionManager::get('administrador');

    return $conn;
}