LetMeLove 의 세상보기

ADODB Acvite Record
1. 소개
 ADODB_Active_Record 는 기본적으로 잰드 프래임워크의 구현을 따르며, PHP에서
객체관계매핑(ORM)을 구현하여 개발자로 하여금 DB데이터 조작을 적은 조작으로
가능하게 하여 개발에 더욱 집중할 수 있습니다.
2. 데이터베이스 연결설정
require_once('adodb/adodb-active-record.inc.php');
$dbconn = &ADONewConnection('oci8po');
$dbconn->Connect('localhost','dbuser','dbpass','dbsid');
ADOdb_Active_Record::SetDatabaseAdepter($dbconn);
3. 테이블 클래스 생성
class person extends ADOdb_Active_Record{
}
$person = new person();
var_dump($person->getAttributeNames()); // 테이블 컬럼 가져오기
4. 레코드 삽입 및 업데이트
$person = new person();
$person->name = '홍길동';
$person->hp_num = '010-1111-2222';
$person->save();
5. 레코드 가져오기
$person = new person();
// load a single record
$person->load('id=aaa');
// use preparstatment
$arr = array('aaa');
$person->load('id=?',$arr);
// array of active record
$arrData = array('김%');
$peopleArray = $person->Find("name like ? order by idx", $arrData);

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.

APM_setup 7 기준

c:\APM_setup\server\php5

pear upgrade-all

pear channel-discover pear.phing.info
pear install phing/phing

Unknown remote channel: pear.phpunit.de
WARNING: "pear/PEAR_PackageFileManager" is deprecated in favor of "pear/PEAR_PackageFileManager2"
Unknown remote channel: pear.pdepend.org
Unknown remote channel: pear.phpmd.org
Unknown remote channel: pear.phpunit.de
Unknown remote channel: pear.docblox-project.org
Did not download optional dependencies: phing/phingdocs, pear/VersionControl_SVN, pear/VersionControl_Git, channel://pea
r.phpunit.de/PHPUnit, pear/PhpDocumentor, pecl/Xdebug, pear/PEAR_PackageFileManager, pear/Services_Amazon_S3, pear/HTTP_
Request2, channel://pear.pdepend.org/PHP_Depend, channel://pear.phpmd.org/PHP_PMD, channel://pear.phpunit.de/phpcpd, cha
nnel://pear.docblox-project.org/DocBlox, pear/PHP_CodeSniffer, use --alldeps to download automatically
phing/phing can optionally use package "phing/phingdocs" (version >= 2.4.6)
phing/phing can optionally use package "pear/VersionControl_SVN" (version >= 0.3.4)
phing/phing can optionally use package "pear/VersionControl_Git" (version >= 0.4.3)
phing/phing can optionally use package "channel://pear.phpunit.de/PHPUnit" (version >= 3.4.0)
phing/phing can optionally use package "pear/PhpDocumentor" (version >= 1.4.0)
phing/phing can optionally use package "pecl/Xdebug" (version >= 2.0.5)
phing/phing can optionally use package "pear/PEAR_PackageFileManager" (version >= 1.5.2)
phing/phing can optionally use package "pear/Services_Amazon_S3" (version >= 0.3.1)
phing/phing can optionally use package "pear/HTTP_Request2" (version >= 0.5.2)
phing/phing can optionally use package "channel://pear.pdepend.org/PHP_Depend" (version >= 0.10.0)
phing/phing can optionally use package "channel://pear.phpmd.org/PHP_PMD" (version >= 1.1.0)
phing/phing can optionally use package "channel://pear.phpunit.de/phpcpd" (version >= 1.3.2)
phing/phing can optionally use package "channel://pear.docblox-project.org/DocBlox" (version >= 0.11.0)
phing/phing can optionally use package "pear/PHP_CodeSniffer" (version >= 1.3.0)
downloading phing-2.4.6.tgz ...
Starting to download phing-2.4.6.tgz (406,970 bytes)
..................................................................................done: 406,970 bytes
install ok: channel://pear.phing.info/phing-2.4.6

pear channel-discover pear.propelorm.org
pear clear-cache
pear install -a propel/propel_generator

WARNING: "pear.propelorm.org/propel_generator" is deprecated in favor of "channel:///"
pear.propelorm.org/propel_generator requires PHP extension "pdo"
pear.propelorm.org/propel_generator requires PHP extension "xsl"
No valid packages found
install failed

----------------------------------------------------------------------------------------------
Error 슈팅 : php커멘트 실행시 php.ini파일의 내용을 가져오지 못해서 생긴문제로 C:\windows에 php.ini
파일을 복사해서 넣으면 해결됨

php --ini
Configuration File (php.ini) Path: C:\windows
Loaded Configuration File:         (none)
Scan for additional .ini files in: (none)
Additional .ini files parsed:      (none)

php --ini
Configuration File (php.ini) Path: C:\windows
Loaded Configuration File:         C:\Windows\php.ini
Scan for additional .ini files in: (none)
Additional .ini files parsed:      (none)
-----------------------------------------------------------------------------------------------

pear install -a propel/propel_generator

WARNING: "pear.propelorm.org/propel_generator" is deprecated in favor of "channel:///"
downloading propel_generator-1.6.1.tgz ...
Starting to download propel_generator-1.6.1.tgz (260,148 bytes)
.....................................................done: 260,148 bytes
install ok: channel://pear.propelorm.org/propel_generator-1.6.1

pear install -a propel/propel_runtime

WARNING: "pear.propelorm.org/propel_runtime" is deprecated in favor of "channel:///"
downloading propel_runtime-1.6.1.tgz ...
Starting to download propel_runtime-1.6.1.tgz (117,919 bytes)
..........................done: 117,919 bytes
install ok: channel://pear.propelorm.org/propel_runtime-1.6.1

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.