Class: Oracle
Source Location: /php/db/Oracle.php
Class Oracle
Inherited Properties, Constants, and Methods
Method Summary
string |
error() |
¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ |
array |
fetch() |
½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù. |
string |
getTypeString() |
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â |
resource |
prepare() |
sql ±¸¹® ÆÄ½ÌÇϱâ |
void |
query() |
ÀÏ¹Ý Äõ¸® ½ÇÇà |
bool |
setPrefetch() |
execute ¸Þ¼Òµå¸¦ ½ÇÇàÇßÀ» ¶§ ¹Ì¸® Àоî¿Ã ·¹ÄÚµå¼Â °³¼ö¸¦ ¼³Á¤ÇÑ´Ù. |
Methods
bool bind(
string
$name, [string
$type = ''], [string
$output = 'in'], [int
$length = -1], [
&$value = null], mixed
$value
)
|
|
bind ¸Þ¼Òµå
Parameters:
string |
$name: |
¹ÙÀεù À̸§ |
string |
$type: |
¹ÙÀεùµÉ ŸÀÔ, µ¥ÀÌŸº£À̽º ¸¶´Ù Ʋ¸² |
string |
$output: |
output ÇüÅÂ, in, out, inout, return |
int |
$length: |
µ¥ÀÌŸ±æÀÌ, -1Àº ±æÀÌÁ¦ÇÑ ¾øÀ½ |
mixed |
$value: |
ÀúÀåµÉ µ¥ÀÌŸ ¶Ç´Â output º¯¼ö¿¡ ÀúÀåµÉ µ¥ÀÌŸ |
|
&$value: |
|
API Tags:
Redefinition of:
- DBClient::bind()
- prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù.
OracleProc createProc(
$str, [
$option = 'proc']
)
|
|
ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼¸¦ ¾ò´Â´Ù.
Parameters:
API Tags:
See: | createProc($name) |
Access: | public |
Redefinition of:
- DBClient::createProc()
- ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼ ¸®ÅÏ , ÇÏÀ§¿¡¼ ±¸ÇöÇØ¾ßÇÕ´Ï´Ù.
void define(
$column,
$var,
$type
)
|
|
Parameters:
API Tags:
¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ
API Tags:
Return: | ¿¡·¯ ¸Þ¼¼Áö |
Access: | public |
Redefinition of:
- DBClient::error()
- ¿¡·¯ ¸®ÅÏ
resource execute(
[
$mode = OCI_DEFAULT]
)
|
|
Äõ¸® ½ÇÇà
$db = DB_('oracle', 'test', true);
$db->prepare("insert into test_table values ('1', '2')");
Parameters:
API Tags:
Return: | statement¸¦ ½ÇÇàÇÑ ¸®¼Ò½º |
Access: | public |
Redefinition of:
- DBClient::execute()
- prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù.
array fetch(
resource
$stmt
)
|
|
½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
¸®ÅϵǴ °ªÀº array('Çʵå' => '¤±¤±¤±', ...); ÇüŸ¦ °¡Áø´Ù.
Parameters:
resource |
$stmt: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | row µ¥ÀÌŸ |
Access: | public |
Redefinition of:
- DBClient::fetch()
- ·¹ÄÚµå °¡Á®¿À±â
void fetchAll(
resource
$stmt
)
|
|
Àüü ÆÐÄ¡
Parameters:
resource |
$stmt: |
ÆÄ½ÌµÈ Statement °´Ã¼ |
API Tags:
Redefinition of:
- DBClient::fetchAll()
- Àüü ·¹ÄÚµå °¡Á®¿À±â
bool freeStatement(
resource
$stmt
)
|
|
prepare ¸Þ¸ð¸® ÇØÁ¦
Parameters:
resource |
$stmt: |
oci_prepare() ÇÔ¼ö·Î ³ª¿Â °á°ú resource |
API Tags:
Redefinition of:
- DBClient::freeStatement()
- prepare µÈ ±¸¹® ¸Þ¸ð¸® ÇØÁ¦
DBData getCursorData(
$name, [
$isOne = false]
)
|
|
cursor ¿¡¼ DBData ¾ò±â
$db = DB_('oracle', 'test', true);
.......
echo $data;
Parameters:
DBData getData(
string
$query, [boolean
$isOne = false], string
$baseClass
)
|
|
DBData ±¸ÇÔ
$db = DB_('oracle', 'test', true);
$data = $db->getData("select 1 from dual");
echo $data;
Parameters:
string |
$query: |
DB query |
boolean |
$isOne: |
À妽º ÇÑÄ ¿Å±â±â |
string |
$baseClass: |
»ý¼ºµÉ Ŭ·¡½º À̸§ |
API Tags:
Redefinition of:
- DBClient::getData()
- DBData ±¸ÇÔ
int getFieldCount(
resource
$stmt
)
|
|
Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ °³¼ö¸¦ ¸®ÅÏÇÑ´Ù.
Parameters:
resource |
$stmt: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | Çʵ尳¼ö |
Access: | public |
Redefinition of:
- DBClient::getFieldCount()
- ÇÊµå °³¼ö °¡Áö°í ¿À±â
string getFieldName(
resource
$stmt, int
$i
)
|
|
Á¤ÇØÁø À§Ä¡ÀÇ Çʵå À̸§À» ¾ò¾î¿Â´Ù.
Parameters:
resource |
$stmt: |
select °á°ú·Î ³ª¿Â resource |
int |
$i: |
Çʵå À§Ä¡, óÀ½Àº 0 |
API Tags:
Return: | ÇʵåÀ̸§ |
Access: | public |
Redefinition of:
- DBClient::getFieldName()
- Çʵå À̸§ °¡Áö°í ¿À±â
string getFieldType(
resource
$stmt, int
$i
)
|
|
Á¤ÇØÁø À§Ä¡ÀÇ Çʵå ŸÀÔÀ» ¾ò¾î¿Â´Ù.
Parameters:
resource |
$stmt: |
select °á°ú·Î ³ª¿Â resource |
int |
$i: |
Çʵå À§Ä¡, óÀ½Àº 0 |
API Tags:
Return: | ÇʵåŸÀÔ |
Access: | public |
Redefinition of:
- DBClient::getFieldType()
- Çʵå ŸÀÔ °¡Áö°í ¿À±â
DBData getPageData(
string
$query, int
$page, [int
$count = 10], string
$baseClass
)
|
|
select Äõ¸®¿¡ ´ëÇØ¼ ÆäÀÌ¡µÈ DBData¸¦ ¸®ÅÏÇÑ´Ù.
$db = DB_('oracle', 'test', true);
echo $data;
Parameters:
string |
$query: |
select Äõ¸® |
int |
$page: |
ÇöÀç ÆäÀÌÁö |
int |
$count: |
ÆäÀÌÁö´ç ¸®½ºÆ® °³¼ö |
string |
$baseClass: |
DBData ¸¦ »ó¼ÓÇÑ Å¬·¡½º , ±âº»°ª DBData |
API Tags:
Redefinition of:
- DBClient::getPageData()
- paging µÈ DBData ¾ò¾î¿À±â
int|string getTypeConstant(
string
$type
)
|
|
Çʵå ŸÀÔ(ÀÚ·áÇü)º° php¿ë Àü¿ë »ó¼ö ¾ò¾î¿À±â
Parameters:
API Tags:
Return: | PHP»ó¼ö |
Access: | public |
Redefinition of:
- DBClient::getTypeConstant()
- Çʵå ŸÀÔ(ÀÚ·áÇü)º° php¿ë Àü¿ë »ó¼ö ¾ò¾î¿À±â
string getTypeString(
string
$type, mixed
$value, [boolean
$is_null = false], [
$option = array('date_format' => 'YYYYMMDDHH24MISS')]
)
|
|
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â
Parameters:
string |
$type: |
ŸÀÔ¹®ÀÚ¿ |
mixed |
$value: |
ÀԷ°ª |
boolean |
$is_null: |
³ÎÀ» üũÇÒ °ÍÀÎÁö ¿©ºÎ , true ³Îüũ, false ³Î üũ ¾ÈÇÔ |
|
$option: |
|
API Tags:
Return: | º¯È¯µÈ ¹®ÀÚ¿ |
Access: | public |
Redefinition of:
- DBClient::getTypeString()
- Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â
void newCursor(
string
$name
)
|
|
Ä¿¼ »ý¼ºÇϱâ
Parameters:
API Tags:
resource prepare(
string
$query
)
|
|
sql ±¸¹® ÆÄ½ÌÇϱâ
Parameters:
string |
$query: |
ÆÄ½ÌµÉ Äõ¸® |
API Tags:
Return: | ÆÄ½ÌµÈ statment resource |
Access: | public |
Redefinition of:
- DBClient::prepare()
- prepare
void query(
$query, [bool
$isCommit = true], [array
$args = array()], string
$sql
)
|
|
ÀÏ¹Ý Äõ¸® ½ÇÇà
Parameters:
string |
$sql: |
½ÇÇàµÉ query |
bool |
$isCommit: |
commit ¿©ºÎ , ¹Ù·Î commit À̸é true, ¾Æ´Ï¸é false |
array |
$args: |
¹ÙÀεùµÉ º¯¼ö ¸ñ·Ï |
|
$query: |
|
API Tags:
Redefinition of:
- DBClient::query()
- Äõ¸® ½ÇÇàÇϱâ
rollback
API Tags:
Return: | ¼º°øÀ̸é true, ½ÇÆÐÀ̸é false |
Access: | public |
Redefinition of:
- DBClient::rollback()
- rollback
bool setPrefetch(
resource
$stmt, [int
$count = 10]
)
|
|
execute ¸Þ¼Òµå¸¦ ½ÇÇàÇßÀ» ¶§ ¹Ì¸® Àоî¿Ã ·¹ÄÚµå¼Â °³¼ö¸¦ ¼³Á¤ÇÑ´Ù.
Parameters:
resource |
$stmt: |
½ÇÇàµÈ statement |
int |
$count: |
¹Ì¸® Àоî¿Ã ·¹ÄÚµå¼Â °³¼ö |
API Tags:
Return: | ¼º°øÇßÀ¸¸é true, ½ÇÆÐÇßÀ¸¸é false |
Access: | public |
ÇÁ·Î½ÃÀú ½ÇÇà
// 1. ÀϹÝÀûÀÎ ½ÇÇà¹æ¹ý
// 2. ÀÓÀÇÀÇ ±¸¹® ½ÇÇà¹æ¹ý
API Tags:
Return: | ¼º°øÀ̸é true, ½ÇÆÐÀ̸é false |
Access: | public |
Information Tags:
Todo: | insert, update ,delete ±¸¹®¿¡ ´ëÇØ¼ ÀÚµ¿À¸·Î binding ÇÒ ¼ö ÀÖ´Â ±â´É ±¸Çö |
Redefinition of:
- DBClient::spExecute()
- ÇÁ·Î½ÃÀú ½ÇÇà
database ¿¬°á »ý¼º
API Tags:
Return: | ¿¬°á resource |
Access: | public |
Redefinition of:
- DBClient::_connect()
- ¿¬°á ¸®¼Ò½º ¸®ÅÏ
|
|