codeigniter get data from multiple database in controller method code example

Example: how to use more than one database in codeigniter

This is default database :

$db['default'] = array(
    ....
  	....
    'database' => 'mydatabase',
    ....
);
Add another database at the bottom of database.php file

$db['second'] = array(
    ....
  	....
    'database' => 'mysecond',
    ....
);

In autoload.php config file

$autoload['libraries'] = array('database', 'email', 'session');

The default database is worked fine by autoload the database library but second database load and connect by using constructor in model and controller...

<?php
    class Seconddb_model extends CI_Model {
        function __construct(){
            parent::__construct();
            //load our second db and put in $db2
            $this->db2 = $this->load->database('second', TRUE);
        }

        public function getsecondUsers(){
            $query = $this->db2->get('members');
            return $query->result(); 
        }

    }
?>
  
/*
I hope it will help you.
Namaste
Stay Home Stay Safe
*/