Multi connections MySQL Codeigniter

Question

Multi connections MySQL Codeigniter

Navigation

#1 by (2 votes)

3

In my database.php I created two connections:

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost'; 
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'sitejc';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
$db['default']['date_default_timezone_set'] = 'America/Sao_Paulo';

$db['parceiro']['hostname'] = 'localhost'; 
$db['parceiro']['username'] = 'root';
$db['parceiro']['password'] = '';
$db['parceiro']['database'] = 'sistema2';
$db['parceiro']['dbdriver'] = 'mysql';
$db['parceiro']['dbprefix'] = '';
$db['parceiro']['pconnect'] = TRUE;
$db['parceiro']['db_debug'] = TRUE;
$db['parceiro']['cache_on'] = FALSE;
$db['parceiro']['cachedir'] = '';
$db['parceiro']['char_set'] = 'utf8';
$db['parceiro']['dbcollat'] = 'utf8_general_ci';
$db['parceiro']['swap_pre'] = '';
$db['parceiro']['autoinit'] = TRUE;
$db['parceiro']['stricton'] = FALSE;
$db['parceiro']['date_default_timezone_set'] = 'America/Sao_Paulo';

/* End of file database.php */
/* Location: ./application/config/database.php */

Inside my controller, I gave a load like this:

$parceiro_db = $this->load->database('parceiro', TRUE);

However, when I make a request from the selected database, I get an error.

Request form:

class Cadastro extends MY_Controller {

    public function __construct() {
        parent::__construct();
        $this->load->model('model_cadastro');
        $parceiro = $this->load->database('parceiro', TRUE);
    }

    # Cadastro para Empresa
    public function empresa($metodo=NULL) {
        if($this->input->post('submit')){
            $clientes = $parceiro->get('cliente')->result();
        }

Error:

Fatal error: Call a member function get () on a non-object in /home/jcentreg/public_html/sitejc/site/modules/cadastro/controllers/cadastro.php online 21

How do I make this multi connection?

mysql codeigniter

asked by anonymous 04.10.2016 / 17:38

1 answer

Saving multiple values of an enum in the database Select a RadioButton from a RadioGroup, according to a condition

score 2 · Accepted Answer

Would not it be $parceiro_db ?

$clientes = $parceiro_db->get('clientes')->result();

Doc - Connecting to Multiple Databases

In order to work there is a problem in the configuration in $db['parceiro']['dbdriver'] is set to mysql put mysqli :

$db['parceiro']['hostname'] = 'localhost'; 
$db['parceiro']['username'] = 'root';
$db['parceiro']['password'] = '';
$db['parceiro']['database'] = 'sistema2';
$db['parceiro']['dbdriver'] = 'mysqli';
$db['parceiro']['dbprefix'] = '';
$db['parceiro']['pconnect'] = TRUE;
$db['parceiro']['db_debug'] = TRUE;
$db['parceiro']['cache_on'] = FALSE;
$db['parceiro']['cachedir'] = '';
$db['parceiro']['char_set'] = 'utf8';
$db['parceiro']['dbcollat'] = 'utf8_general_ci';
$db['parceiro']['swap_pre'] = '';
$db['parceiro']['autoinit'] = TRUE;
$db['parceiro']['stricton'] = FALSE;
$db['parceiro']['date_default_timezone_set'] = 'America/Sao_Paulo';

$db = $this->load->database("parceiro", TRUE);
var_dump(  $db->get("cliente")->result_array() );

Encryption Error:

class Cadastro extends MY_Controller 
{
    private $parceiro;
    public function __construct() 
    {
        parent::__construct();
        $this->load->model('model_cadastro');
        $this->parceiro = $this->load->database('parceiro', TRUE);
    }

    # Cadastro para Empresa
    public function empresa($metodo=NULL) 
    {
        if($this->input->post('submit'))
        {
            $clientes = $this->parceiro->get('cliente')->result();
        }

Since a variable was used to work in methods you have to use $this to assign and use.

Examples: SOEn - CodeIgniter: Multiple Databases - Accessing database config in a second database