There are circumctances where some developers need to use multiple databases in a single web project.
If you are here then you surely want to learn that How to use multiple database in a codeigniter.
So without any further ado let’s get into the trick.
$db variable (array) like bellow, you can copy and paste the default db details as well but make sure to change the
key to database2.
NOTE : keys should be named as database2, database3 etc.
$db['database2'] = array( 'dsn' => '', 'hostname' => ''
, 'username' => '', 'password' => '', 'database' => '', '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 );
Load the newly connected database as like bellow
$db2 = $this->load->database('
you can use
$db2 object to interact with second database easily.
NOTE : instead of
$this->db you have to use
$db2 i.e (
Please help us by showing your reaction