Multiple codeigniter database connections

Question

I’ve been investigating the use of multiple Codeigniter databases. If I know which databases are ahead of time, I can set the information in the configuration file and then call the database group I need.

In my situation, however, I need to store this database information in another database. It is a kind of master database with general information about a customer, including the database and credentials in which the customer’s data is stored. This provider can then add customers whenever he wants and have segregated the data of each customer in different databases.

How can I set up the database and credentials based on the values I receive from the master database in Codeigniter, or is there really a way to do this?

I need this because I have a unique system and each client who logs in has a unique database for it, so imagine that I can have 5 people using the system at the same time but each of them accessing their own database.

If anyone can help me, I’d appreciate it!

Abs

Answer 1

In general you only have 1 database configured in the file /application/config/database.php Codeigniter and by default the configuration is called default:

// Isto já existe
$db['default'] = array(
    'dsn'      => '',
    'hostname' => '80.45.168.49',
    'username' => 'steven.douglas',
    'password' => 'hEo&73T#@wToh',
    'database' => 'main_db',
    '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
);

You will need to set up another one right after, and name it, for example, auxiliar:

// Isto terá que ser adicionado
$db['auxiliar'] = array(
    'dsn'      => '',
    'hostname' => '80.45.168.50',
    'username' => 'john.eastwood',
    'password' => 'cEsl#$tAnw4Mh',
    'database' => 'another_bd',
    '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
);

And looking at the My_model class, which is called that precisely because it is for you to customize it, you see that the configuration default is associated with the variable $db. Then you will have to create a variable like $db2, or a name of your choice, for your auxiliar, editing the file /application/core/MY_Model.php:

class MY_Model extends CI_Model
{
    protected $active_group;
    protected $db2; // <------ ADICIONE 

    public function __construct() {
        parent::__construct();
        $this->connect();
    }

    public function __destruct() {
        $this->db->close();
    }

    public function connect($active_group = 'default'){
        $this->active_group = $active_group;
        $db = $this->load->database($active_group, TRUE);
        $this->db = $db;

        // ADICIONE ISTO ABAIXO
        $db2 = $this->load->database('auxiliar', TRUE);
        $this->db2 = $db2;
    }

}

Ready! Now you can use $this->db2 in their models:

$query = $this->db2->select('nome_pessoa, numero_cpf')->get('pessoas');

Answer 2

To function as the C. Bohok said, it is necessary for its model to extend MY_Model rather than extend the CI_Model

I’m using the codeigniter3

Originally your model must be something like this:

class Assuntos_model extends CI_Model{

Change to:

class Assuntos_model extends MY_Model{