- 용도 : codeigniter에서 oracle과 mysql을 동시에 사용하는 방법입니다.

- 환경 : apmsetup 6, oracle 10g

###### 오라클 설치 ############
http://codeigniter-kr.org/tip/view/341/page/1

###### apmsetup 에 오라클 연동 #######
php.ini에서 다음 2개 주석해제후 apm 재시작
extension=php_oci8.dll
extension=php_oracle.dll

##### codeigniter > database.php 설정 ########
 

$active_group = "mysql";
$active_record = TRUE;

$db['mysql']['hostname'] = "localhost";
$db['mysql']['username'] = "root";
$db['mysql']['password'] = "apmsetup";
$db['mysql']['database'] = "cidb";
$db['mysql']['dbdriver'] = "mysql";
$db['mysql']['dbprefix'] = "";
$db['mysql']['pconnect'] = TRUE;
$db['mysql']['db_debug'] = TRUE;
$db['mysql']['cache_on'] = FALSE;
$db['mysql']['cachedir'] = "";
$db['mysql']['char_set'] = "utf8";
$db['mysql']['dbcollat'] = "utf8_general_ci";


$dbhost = "localhost";    //IP of my host database
$dbport = "1521";    //Oracle port
$dbname= "ORCL";    //My database Name

$dbConnString = "
 (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = ".$dbhost.")(PORT = ".$dbport."))
 )  
 (CONNECT_DATA = 
     (SID = ORCL)
  (SERVICE_NAME = ".$dbname.")
 ))";

$db['oracle']['hostname'] = $dbConnString;
$db['oracle']['username'] = "combort";    
$db['oracle']['password'] = "1234";   
$db['oracle']['database'] = "";
$db['oracle']['dbdriver'] = "oci8";   
$db['oracle']['dbprefix'] = "";
$db['oracle']['pconnect'] = TRUE;
$db['oracle']['db_debug'] = TRUE;
$db['oracle']['cache_on'] = FALSE;
$db['oracle']['cachedir'] = "";
$db['oracle']['char_set'] = "utf8";
$db['oracle']['dbcollat'] = "utf8_general_ci";

##### codeigniter > 컨트롤 사용예제 ########

 

<?php

class Welcome extends Controller {

	function Welcome()
	{
		parent::Controller();	
		$this->load->dbforge();

		$this->DB1 = $this->load->database('mysql', TRUE);
		$this->DB2 = $this->load->database('oracle', TRUE);
	}
	
	function index()
	{
		  echo "mysql or oracle Test";
	}

	function mysql_select()
	{
		$query = $this->DB1->query("select * from board");
		foreach ($query->result_array() as $row) {

			echo $row['title'];

		}

		echo "출력";
	}


	function mysql_insert()
	{
		  $this->DB1->query("insert into board(title, memo) values('3','test')");
	}


	function oracle_select()
	{
		$query = $this->DB2->query("select C_NAME from customer");
		foreach ($query->result_array() as $row) {

			echo $row['C_NAME'];

		}

		echo "출력";
	}


	function oracle_insert()
	{
		  $this->DB2->query("insert into customer(C_NO, C_NAME, C_ADDR, C_PHONE, C_DIST) values('3','test','test','1234','11')");
	}

}

※ 참고 : ci에서 제공하는 데이터베이스 forge, util은 100% 구현테스트를 못해보았습니다.


첨부파일에 : 1.7.2 기준으로 테스트한 전체 소스 예제 참조하시면 됩니다.