How to connect more than two databases in codeigniter?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'database1',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

$db['database2'] = array(
    // Configuration settings for second database
);

$db['database3'] = array(
    // Configuration settings for third database
);

1
2
3

$DB1 = $this->load->database('default', TRUE);
$DB2 = $this->load->database('database2', TRUE);
$DB3 = $this->load->database('database3', TRUE);

1
2
3

$query1 = $DB1->query('SELECT * FROM table1');
$query2 = $DB2->query('SELECT * FROM table2');
$query3 = $DB3->query('SELECT * FROM table3');