<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/*
| -------------------------------------------------------------------
| DATABASE CONNECTIVITY SETTINGS
| -------------------------------------------------------------------
| This file will contain the settings needed to access your database.
|
| For complete instructions please consult the "Database Connection"
| page of the User Guide.
|
| -------------------------------------------------------------------
| EXPLANATION OF VARIABLES
| -------------------------------------------------------------------
|
|	['hostname'] The hostname of your database server.
|	['username'] The username used to connect to the database
|	['password'] The password used to connect to the database
|	['database'] The name of the database you want to connect to
|	['dbdriver'] The database type. ie: mysql.  Currently supported:
				 mysql, mysqli, postgre, odbc, mssql, sqlite, oci8
|	['dbprefix'] You can add an optional prefix, which will be added
|				 to the table name when using the  Active Record class
|	['pconnect'] TRUE/FALSE - Whether to use a persistent connection
|	['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
|	['cache_on'] TRUE/FALSE - Enables/disables query caching
|	['cachedir'] The path to the folder where cache files should be stored
|	['char_set'] The character set used in communicating with the database
|	['dbcollat'] The character collation used in communicating with the database
|
| The $active_group variable lets you choose which connection group to
| make active.  By default there is only one group (the "default" group).
|
| The $active_record variables lets you determine whether or not to load
| the active record class
*/

$active_group = "DB1";
$active_record = FALSE;

$db['DB1']['hostname'] = "aaa";
$db['DB1']['username'] = "bbb";
$db['DB1']['password'] = "ccc";
$db['DB1']['database'] = "DB1";
$db['DB1']['dbdriver'] = "oci8";
$db['DB1']['dbprefix'] = "";
$db['DB1']['pconnect'] = TRUE;
$db['DB1']['db_debug'] = TRUE;
$db['DB1']['cache_on'] = FALSE;
$db['DB1']['cachedir'] = "";
$db['DB1']['char_set'] = "euckr";
$db['DB1']['dbcollat'] = "euckr_korean_ci";

$db['DB2']['hostname'] = "aaa";
$db['DB2']['username'] = "bbb";
$db['DB2']['password'] = "ccc";
$db['DB2']['database'] = "DB2";
$db['DB2']['dbdriver'] = "oci8";
$db['DB2']['dbprefix'] = "";
$db['DB2']['pconnect'] = TRUE;
$db['DB2']['db_debug'] = TRUE;
$db['DB2']['cache_on'] = FALSE;
$db['DB2']['cachedir'] = "";
$db['DB2']['char_set'] = "euckr";
$db['DB2']['dbcollat'] = "euckr_korean_ci";

$db['DB3']['hostname'] = "aaa";
$db['DB3']['username'] = "bbb";
$db['DB3']['password'] = "ccc";
$db['DB3']['database'] = "DB3";
$db['DB3']['dbdriver'] = "oci8";
$db['DB3']['dbprefix'] = "";
$db['DB3']['pconnect'] = TRUE;
$db['DB3']['db_debug'] = TRUE;
$db['DB3']['cache_on'] = FALSE;
$db['DB3']['cachedir'] = "";
$db['DB3']['char_set'] = "euckr";
$db['DB3']['dbcollat'] = "euckr_korean_ci";

$db['DB4']['hostname'] = "aaa";
$db['DB4']['username'] = "bbb";
$db['DB4']['password'] = "ccc";
$db['DB4']['database'] = "DB4";
$db['DB4']['dbdriver'] = "oci8";
$db['DB4']['dbprefix'] = "";
$db['DB4']['pconnect'] = TRUE;
$db['DB4']['db_debug'] = TRUE;
$db['DB4']['cache_on'] = FALSE;
$db['DB4']['cachedir'] = "";
$db['DB4']['char_set'] = "euckr";
$db['DB4']['dbcollat'] = "euckr_korean_ci";
/* End of file database.php */
/* Location: ./system/application/config/database.php */

<?php
class MY_Model extends Model
{
	function MY_Model()
	{
		parent::Model();
	}
	
	function __get($name)
	{
		$CI =& get_instance();
		
		foreach (get_object_vars($CI) as $CI_object_name => $CI_object)
		{
			if (is_object($CI_object) && is_subclass_of(get_class($CI_object), 'CI_DB') && $CI_object_name == $name)
			{
				return $CI_object;
			}
		}
		
		$CI->$name = $CI->load->database($name, TRUE);
		
		return $CI->$name;
	}
}

/* End of file */

<?php
class User_model extends MY_Model
{
	function User_model()
	{
		parent::MY_Model();
	}
	
	function test_db1()
	{
		return $this->DB1->query('select * from tbl1')->row_array();
	}
	
	function test_db2()
	{
		return $this->DB2->query('select * from tbl2')->row_array();
	}

	function test_db3()
	{
		return $this->DB3->query('select * from tbl3')->row_array();
	}

	function test_db4()
	{
		return $this->DB4->query('select * from tbl4')->row_array();
	}	
}
/* End of file */

<?php

class Main extends Controller {

	function Main()
	{
		parent::Controller();	
	}
	
	function index()
	{
		$this->output->enable_profiler(true);
		
		$this->user_model->test_db1();
		$this->user_model->test_db2();
		$this->user_model->test_db3();
		$this->user_model->test_db4();
	}
}

/* End of file welcome.php */
/* Location: ./system/application/controllers/welcome.php */