토미앤피쉬 ::

'php'에 해당되는 글 3건

2010/02/04 PHP array to object
2010/01/29 [Codeigniter] Oracle + mysql 동시사용
2009/12/21 이클립스 SVN 설치

PHP array to object

개인적으로.. 작업을 하다보면... array 보다는 object가 좋을때가 있다..

그래서 쿼리값을 array 와 object로 선택적으로 받아서 사용하도록 구성을 한다...

array를 object로 변환하는 함수..

function bindArrayToObject($array) {
    $return = new stdClass();
    foreach ($array as $k => $v) {
        if (is_array($v)) {
            $return->$k = bindArrayToObject($v);
        }
        else {
            $return->$k = $v;
        }
    }

    return $return;
}

원글) http://snipplr.com/view.php?codeview&id=8770

Posted by Tommy Lymm

TAG array to object, php

Trackback 0 Comment 0

[Codeigniter] Oracle + mysql 동시사용

- 용도 : 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 기준으로 테스트한 전체 소스 예제 참조하시면 됩니다.

위내용은 Codeigniter 한국사요자포럼의 내용입니다.
원글) http://codeigniter-kr.org/source/view/332/page/1/q/oracle%20+%20mysql

Posted by Tommy Lymm

TAG CI, codeigniter, php

Trackback 0 Comment 0

이클립스 SVN 설치

Subversive installation instructions

Subversive can be simply installed from within Eclipse using update manager. All what the user should do is just point update manager to the remote or local update site. To install Subversive:

Start Eclipse and select menu item 'Help > Software Updates...'
Select the 'Available Software' tab group and click the 'Add Site...' button.
On the 'Add Site' dialog enter the URL to SVN Connectors update site. The proper URL can be found on http://www.eclipse.org/subversive/downloads.php. Also the update-site for Subversive integration plug-ins can be added in the same way.
- Please note that the use of the software you are about to access may be subject to third party terms and conditions and you are responsible for abiding by such terms and conditions.
Click on the 'OK' button to store update site information.
The Subversive update site provides following features list.
- SVN Team Provider - The Eclipse Team Provider for the Subversion version control system.
- Subversive Integration for the Mylyn Project - Integration with Mylyn (http://www.eclipse.org/mylyn/).
- JDT Ignore Extensions - The feature is useful for Java development because it allows to interpret output folders as ignored resources automatically.
- SVN Team Provider Sources - The sources of the Eclipse Team Provider for Subversion.
Select SVN Team Provider, Subversive SVN Connectors and other features if required and click the 'Install' button.
The update manager calculates dependencies and offers you a list of features to install. Select the needed ones and click the 'Next >' button.
Accept terms of license agreement and click the 'Finish' button in order to start the download of selected features.
To apply installation changes and restart Eclipse click on the 'Yes' button.
After Eclipse restart you are able to start using Subversive.
You can find Subversive perspective and views in correspondent dialogs, activated by menu items 'Window > Open Perspective > Other...' and 'Window > Show View > Other...'.