Multiple databases with multiple applications

Question

I made an application with Codeigniter which uses only a database. However, I was asked to create several copies of this application that will also access several different databases. That is, I will have dozens of applications and dozens of different databases. If I make any changes to a file PHP, Soon I’ll have to do it in every application. And if there are hundreds of folders, there is some way to update this file in all applications automatically?

Otherwise I’ll have to upgrade one by one which makes it complicated and time-consuming. What I really wanted was to use only one application and have it search the requested database. Having to write all the code using $this->db1, $this->db2 ... is very complicated because the application is done and there are dozens of "models"!

Answer 1

From what I understand, you will have to use many databases, and you do not want to duplicate the application just for that. In case you were going to do it:

1. www.meusite.com/app1
2. www.meusite.com/app2
3. www.meusite.com/app3
4. www.meusite.com/app4

There is an interesting solution on the site: http://www.oficinadanet.com.br/post/10349-codeigniter-conectando-ao-banco-de-dados-automaticamente-de-acordo-com-o-ambiente

I don’t know if it’s appropriate because I’m not an expert on Codeigniter.

I’ve tested it and it works well.

What I do is to know which folder the user has entered to direct to the correct database using the SWITCH information.

I hope it helps!

UPDATING:

I don’t know if you’re okay with security. If anyone can help, I’d appreciate it!

Look for the file "index php." which is at the root of Codeigniter and change the following lines (make a copy of the original file).

Change "app1, app2, app3, app4" to the name of the folder that appears in the URL. Example: www.meusite.com/minhapasta

//Changed constant to my folder -> request_uri
$get_uri =  $_SERVER['REQUEST_URI'];

$get_uri = filter_var($get_uri, FILTER_SANITIZE_STRING);

$get_uri = explode('/',$get_uri);

$get_uri = $get_uri[1];

$redirect = $get_uri;

define('ENVIRONMENT', $redirect);

if (defined('ENVIRONMENT')) {
switch (ENVIRONMENT) {
    case 'development':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break;

    case 'app1':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break;

     case 'app2':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break; 

      case 'app3':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break;  

      case 'app4':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break;    


    case 'production':
        $db['default']['hostname'] = 'host do banco de dados';
        $db['default']['username'] = 'usuário do banco de dados';
        $db['default']['password'] = 'senha do banco de dados';
        $db['default']['database'] = 'nome do banco de dados';
        break;

   default:
        exit('Minha mensagem de erro personalizada aqui!!!');
}

}