How To Use Multiple Database In Codeigniter

June 5, 2018 XpertPhp Comments 0 Comment

In this tutorial, we will explain to you how to use multiple database in codeigniter. CodeIgniter is MVC based PHP framework, it is possible to Manual database connections in Codeigniter. so you can follow the below code.

Multiple Database Configuration

if you want to connect dynamic databases in CodeIgniter then open the database.php file. this configuration file is available in the array format so you have to do it second database in an array configuration.

see below example

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

$active_group = 'default';
$query_builder = TRUE;

// codeigniter provide default code
$db['default'] = array(
	'dsn'	=> '',
	'hostname' => 'localhost',
	'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
);

// second connectivity of database
$db['second_db'] = array(
	'dsn'	=> '',
	'hostname' => 'here add second database of hostname',
	'username' => 'here add second database of username',
	'password' => 'here add second database of password',
	'database' => 'here add second database of database name',
	'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
);

?>

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

$active_group = 'default';

$query_builder = TRUE;

// codeigniter provide default code

$db['default'] = array(

'dsn' => '',

'hostname' => 'localhost',

'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

);

// second connectivity of database

$db['second_db'] = array(

'dsn' => '',

'hostname' => 'here add second database of hostname',

'username' => 'here add second database of username',

'password' => 'here add second database of password',

'database' => 'here add second database of database name',

'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

);

Connection to New Database

//access default database
$this->load->database();
$query = $this->db->query('select * from register');

//access the second database
$second_db= $this->load->database('second_db', TRUE);
$query = $second_db->get('select * from register2');

//access default database

$this->load->database();

$query = $this->db->query('select * from register');

//access the second database

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

$query = $second_db->get('select * from register2');

Close the Connections

//Close Default database Connection
$this->db->close(); 


//Close Another database Connection
 $this->another_db->close();

//Close Default database Connection

$this->db->close();

//Close Another database Connection

$this->another_db->close();