Switch Database

Option 2:

Similar initiation, just instead passing an array which you can change while running your model:

PHP Code:

$custom = [
            'DSN'      => '',
            'hostname' => 'localhost',
            'username' => '',
            'password' => '',
            'database' => '',
            'DBDriver' => 'MySQLi',
            'DBPrefix' => '',
            'pConnect' => false,
            'DBDebug'  => (ENVIRONMENT !== 'production'),
            'cacheOn'  => false,
            'cacheDir' => '',
            'charset'  => 'utf8',
            'DBCollat' => 'utf8_general_ci',
            'swapPre'  => '',
            'encrypt'  => false,
            'compress' => false,
            'strictOn' => false,
            'failover' => [],
            'port'     => 3306,
    ];

// Wrap in IF with your logic for database connections
    $custom['database'] = 'DB3';
// End if

$db = \Config\Database::connect($custom); 


sorry but i don't understand very well

Do I have to enter this code in each model?

Can't I use config/database.php and just pass the database parameter?


Thanks a lot for your help