Class: Cubrid
Source Location: /php/db/Cubrid.php
Class Cubrid
Inherited Properties, Constants, and Methods
Method Summary
bool |
addSeq() |
seq ¸¶Áö¸·¿¡ Ãß°¡ |
bool |
addSet() |
set ŸÀÔ ¼Ó¼º¿¡ °ª Ãß°¡ |
bool |
drop() |
oid ÇØ´çµÇ´Â instance »èÁ¦ |
bool |
dropSet() |
set ŸÀÔ ¼Ó¼º¿¡ °ª »èÁ¦ |
string |
error() |
¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ |
resource |
execute() |
prepare µÈ statement ½ÇÇà |
array |
fetch() |
½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù. |
bool |
free() |
result ¸Þ¸ð¸® ÇØÁ¦ |
mixed|array |
get() |
oid ƯÁ¤ ¼Ó¼º °¡Áö°í ¿À±â |
array |
getCollection() |
collection ŸÀÔÀ» ¹è¿ ÇüÅ·Π¾ò¾î¿È (set, multiset, sequence) |
array |
getFieldList() |
Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ À̸§ ¸®½ºÆ®¸¦ ¹è¿·Î ¸®ÅÏÇÑ´Ù. |
string |
getOID() |
oid ¼³Á¤ ¾ò¾î¿À±â |
DBData |
getOIDData() |
µ¿ÀÏÇÑ Å¸ÀÔÀÇ set, multiset, sequence ÀÇ °æ¿ì Data °´Ã¼·Î ¾ò¾î¿Â´Ù. |
array |
gets() |
oid ¼Ó¼º°ª ¹è¿·Î °¡Áö°í ¿À±â |
string |
getTypeString() |
°¢°¢ÀÇ µ¥ÀÌŸ¸¦ Äõ¸®±¸¹®¿¡ ¸Â´Â ¹®ÀÚ¿·Î Ç¥½Ã ÇØÁØ´Ù. |
bool |
loadGLO() |
glo ÀνºÅϽº¸¦ ¿øÇÏ´Â file_nameÀ¸·Î ÀúÀå |
resource|bool |
newGLO() |
»õ·Î¿î glo Ŭ·¡½º¸¦ ¸¸µé°í oid ¸®ÅÏ |
resource |
prepare() |
¹ÙÀεù º¯¼ö »ç¿ë °¡´ÉÇÏ°Ô ÇÏ´Â ¸Þ¼Òµå |
bool |
printGLO() |
glo ÀνºÅϽº¸¦ Ç¥ÁØÃâ·ÂÀ¸·Î º¸³¿ |
bool |
puts() |
¿©·¯ ¼Ó¼º°ª µ¿½Ã¿¡ ¼³Á¤ |
bool |
putSeq() |
seq ƯÁ¤ ¿µ¿ª º¯°æÇϱâ (update) |
resource |
query() |
ÀÏ¹Ý Äõ¸® ½ÇÇà |
bool |
saveGLO() |
glo ÀνºÅϽº¿¡ file_name¿¡ ÀÖ´Â µ¥ÀÌŸ·Î ¼öÁ¤Çϱâ |
Methods
bool addSeq(
string
$attr, mixed
$value, [string
$oid = '']
)
|
|
seq ¸¶Áö¸·¿¡ Ãß°¡
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
mixed |
$value: |
¼Ó¼º°ª |
string |
$oid: |
oid |
API Tags:
bool addSet(
string
$attr, mixed
$value, [string
$oid = '']
)
|
|
set ŸÀÔ ¼Ó¼º¿¡ °ª Ãß°¡
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
mixed |
$value: |
¼Ó¼º°ª |
string |
$oid: |
oid |
API Tags:
bool bind(
[int
$index = 1], mixed
$bind_value, [
$bind_value_type = ''], resource
$stmt, string
3
)
|
|
bind ¸Þ¼Òµå
Parameters:
resource |
$stmt: |
prepare() °á°ú resource |
int |
$index: |
¹ÙÀεùµÉ º¯¼ö À§Ä¡, ±âº»°ª 1 |
mixed |
$bind_value: |
¹ÙÀεùµÉ °ª |
string |
3: |
bind_vlaue_type ¹ÙÀεùµÉ ŸÀÔ, Å¥ºê¸®µå¿¡¼ »ç¿ëµÇ´Â ŸÀÔ¸íÀ» ±×´ë·Î »ç¿ëÇÑ´Ù. |
|
$bind_value_type: |
|
API Tags:
Redefinition of:
- DBClient::bind()
- prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù.
commit
cubrid ´Â ±âº»ÀûÀ¸·Î Æ®·£Àè¼ÇÀ» ½ÃÀÛÇϱ⠶§¹®¿¡ insert, update, delete´Â ÇÊÈ÷ commit À» ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. select µµ commitÀ» ÇØÁÖ¸é ÁÁ½À´Ï´Ù.
API Tags:
Redefinition of:
- DBClient::commit()
- commit
CubridProc createProc(
$str, [
$option = 'proc']
)
|
|
ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼¸¦ ¾ò´Â´Ù.
Parameters:
API Tags:
See: | createProc($name) |
Access: | public |
Redefinition of:
- DBClient::createProc()
- ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼ ¸®ÅÏ , ÇÏÀ§¿¡¼ ±¸ÇöÇØ¾ßÇÕ´Ï´Ù.
bool drop(
[string
$oid = '']
)
|
|
oid ÇØ´çµÇ´Â instance »èÁ¦
½ÇÁ¦·Î´Â µ¥ÀÌŸº£À̽ºÀÇ ·¹Äڵ尡 »èÁ¦°¡ µË´Ï´Ù.
Parameters:
API Tags:
bool dropSeq(
string
$attr, int
$index, [string
$oid = '']
)
|
|
seq ƯÁ¤¿µ¿ª »èÁ¦
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
int |
$index: |
sequence index , óÀ½ À§Ä¡´Â 1 |
string |
$oid: |
oid |
API Tags:
bool dropSet(
string
$attr, mixed
$value, [string
$oid = '']
)
|
|
set ŸÀÔ ¼Ó¼º¿¡ °ª »èÁ¦
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
mixed |
$value: |
¼Ó¼º°ª |
string |
$oid: |
oid |
API Tags:
¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ
API Tags:
Return: | ¿¡·¯ ¸Þ¼¼Áö |
Access: | public |
Redefinition of:
- DBClient::error()
- ¿¡·¯ ¸®ÅÏ
resource execute(
[string
$option = ''], string|resource
$query
)
|
|
prepare µÈ statement ½ÇÇà
Parameters:
string|resource |
$query: |
½ÇÇàµÉ Äõ¸®¹®À̳ª prepare·Î ½ÇÇàµÈ °á°ú resource |
string |
$option: |
½ÇÇàµÉ Äõ¸® ¿É¼Ç, oid, async, all |
API Tags:
Return: | ½ÇÇà resource, ½ÇÆÐÇϸé false |
Access: | public |
Redefinition of:
- DBClient::execute()
- prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù.
array fetch(
resource
$result
)
|
|
½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
¸®ÅϵǴ °ªÀº array('Çʵå' => '¤±¤±¤±', ...); ÇüŸ¦ °¡Áø´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | row µ¥ÀÌŸ |
Access: | public |
Redefinition of:
- DBClient::fetch()
- ·¹ÄÚµå °¡Á®¿À±â
bool free(
resource
$result
)
|
|
result ¸Þ¸ð¸® ÇØÁ¦
Parameters:
resource |
$result: |
selectÀÇ °á°úÀÎ result |
API Tags:
Redefinition of:
- DBClient::free()
- ¸Þ¸ð¸® ÇØÁ¦
mixed|array get(
string|array
$attr, [string
$oid = '']
)
|
|
oid ƯÁ¤ ¼Ó¼º °¡Áö°í ¿À±â
Parameters:
string|array |
$attr: |
¼Ó¼º(Çʵå) À̸§ |
string |
$oid: |
¼Ó¼º(Çʵå) °ªÀ» °¡Áö°í ÀÖ´Â oid |
API Tags:
Return: | oid ¼Ó¼º °ª |
Access: | public |
array getCollection(
string
$attr, [string
$oid = '']
)
|
|
collection ŸÀÔÀ» ¹è¿ ÇüÅ·Π¾ò¾î¿È (set, multiset, sequence)
¼Ó¼ºÀÌ collection ŸÀÔÀÏ ¶§ °ªÀ» ¹è¿·Î ¾ò¾î¿É´Ï´Ù.
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
string |
$oid: |
oid |
API Tags:
int getCollectionSize(
string
$attr, [string
$oid = '']
)
|
|
collection °³¼ö ¾ò¾î¿À±â
¼Ó¼ºÀÌ collection ŸÀÔÀÏ ¶§ °³¼ö¸¦ ¾ò¾î¿Â´Ù.
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
string |
$oid: |
oid |
API Tags:
string getCurrentOID(
resource
$result
)
|
|
ÇöÀç oid ¾ò¾î¿À±â
Parameters:
resource |
$result: |
Äõ¸® °á°ú¹®À¸·Î ³ª¿Â result |
API Tags:
Return: | result¿¡ °Ë»öµÈ oid |
Access: | public |
int getFieldCount(
resource
$result
)
|
|
Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ °³¼ö¸¦ ¸®ÅÏÇÑ´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | Çʵ尳¼ö |
Access: | public |
Redefinition of:
- DBClient::getFieldCount()
- ÇÊµå °³¼ö °¡Áö°í ¿À±â
array getFieldList(
resource
$result
)
|
|
Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ À̸§ ¸®½ºÆ®¸¦ ¹è¿·Î ¸®ÅÏÇÑ´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | ÇʵåÀ̸§ ¸®½ºÆ® |
Access: | public |
Redefinition of:
- DBClient::getFieldList()
- ½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ Çʵ帮½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
string getFieldName(
resource
$result, int
$i
)
|
|
Á¤ÇØÁø À§Ä¡ÀÇ Çʵå À̸§À» ¾ò¾î¿Â´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
int |
$i: |
Çʵå À§Ä¡, óÀ½Àº 0 |
API Tags:
Return: | ÇʵåÀ̸§ |
Access: | public |
Redefinition of:
- DBClient::getFieldName()
- Çʵå À̸§ °¡Áö°í ¿À±â
string getFieldType(
resource
$result, int
$i
)
|
|
Á¤ÇØÁø À§Ä¡ÀÇ Çʵå ŸÀÔÀ» ¾ò¾î¿Â´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
int |
$i: |
Çʵå À§Ä¡, óÀ½Àº 0 |
API Tags:
Return: | ÇʵåŸÀÔ |
Access: | public |
Redefinition of:
- DBClient::getFieldType()
- Çʵå ŸÀÔ °¡Áö°í ¿À±â
array getFieldTypeList(
resource
$result
)
|
|
Á¤ÇØÁø À§Ä¡ÀÇ ÇʵåŸÀÔ ¸®½ºÆ®À» ¾ò¾î¿Â´Ù.
Parameters:
resource |
$result: |
select °á°ú·Î ³ª¿Â resource |
API Tags:
Return: | ÇʵåŸÀÔ ¸®½ºÆ® |
Access: | public |
Redefinition of:
- DBClient::getFieldTypeList()
- ½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ ÇʵåÀÇ Å¸ÀÔ ¸®½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
string getOID(
[string
$oid = '']
)
|
|
oid ¼³Á¤ ¾ò¾î¿À±â
±âº»ÀûÀ¸·Î ¼³Á¤µÈ oid°¡ ¾øÀ¸¸é parameter·Î µé¾î°£ oid¸¦ ¹ÝȯÇÑ´Ù.
Parameters:
API Tags:
DBData getOIDData(
string
$attr, [bool
$isOne = false], [string
$oid = '']
)
|
|
µ¿ÀÏÇÑ Å¸ÀÔÀÇ set, multiset, sequence ÀÇ °æ¿ì Data °´Ã¼·Î ¾ò¾î¿Â´Ù.
collection ŸÀÔÁß¿¡ »ç¿ëÀÚÁ¤ÀÇ Å¬·¡½º(Å×À̺í) ÇüÅ·ΠÀúÀåµÇ¾î ÀÖ´Â °ÍÀÌ ÀÖÀ¸¸é ±×°Í¿¡ ´ëÇÑ µ¥ÀÌŸ¸¦ DBData °´Ã¼·Î ¹ÝÈ¯ÇØÁÝ´Ï´Ù.
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
bool |
$isOne: |
ÇÑÄ ÀüÁø ¿©ºÎ |
string |
$oid: |
oid |
API Tags:
DBData getPageData(
string
$query, [int
$page = 1], [int
$count = 10], [string
$order_type = 'order']
)
|
|
select Äõ¸®¿¡ ´ëÇØ¼ ÆäÀÌ¡µÈ DBData¸¦ ¸®ÅÏÇÑ´Ù.
Parameters:
string |
$query: |
select Äõ¸® |
int |
$page: |
ÇöÀç ÆäÀÌÁö |
int |
$count: |
ÆäÀÌÁö´ç ¸®½ºÆ® °³¼ö |
string |
$order_type: |
Á¤·Ä ÇüÅ , order : order by ·Î ÆäÀÌ¡, group : group by ·Î ÆäÀÌ¡, ¾øÀ¸¸é rownumÀ¸·Î ÆäÀÌ¡ |
API Tags:
Redefinition of:
- DBClient::getPageData()
- paging µÈ DBData ¾ò¾î¿À±â
array gets(
[string
$oid = '']
)
|
|
oid ¼Ó¼º°ª ¹è¿·Î °¡Áö°í ¿À±â
Parameters:
API Tags:
string getTypeString(
string
$type, mixed
$value, [boolean
$is_null = false]
)
|
|
°¢°¢ÀÇ µ¥ÀÌŸ¸¦ Äõ¸®±¸¹®¿¡ ¸Â´Â ¹®ÀÚ¿·Î Ç¥½Ã ÇØÁØ´Ù.
// '123' À¸·Î Ç¥½Ã
// 123 À¸·Î Ç¥½Ã
Parameters:
string |
$type: |
ŸÀÔ À̸§ |
mixed |
$value: |
º¯È¯µÉ °ª |
boolean |
$is_null: |
³ÎÀ» üũÇÒ °ÍÀÎÁö ¿©ºÎ , true ³Îüũ, false ³Î üũ ¾ÈÇÔ |
API Tags:
Redefinition of:
- DBClient::getTypeString()
- Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â
bool insertSeq(
string
$attr, int
$index, mixed
$value, [string
$oid = '']
)
|
|
seq ƯÁ¤ ¿µ¿ª¿¡ ³Ö±â
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
int |
$index: |
sequence index , óÀ½ À§Ä¡´Â 1 |
mixed |
$value: |
¼Ó¼º°ª |
string |
$oid: |
oid |
API Tags:
bool isInstance(
[string
$oid = '']
)
|
|
oid Á¸Àç ¿©ºÎ È®ÀÎ
Parameters:
API Tags:
Return: | oid Á¸ÀçÇϸé true, ¾Æ´Ï¸é false |
Access: | public |
bool loadGLO(
string
$file_name, [resource
$oid = '']
)
|
|
glo ÀνºÅϽº¸¦ ¿øÇÏ´Â file_nameÀ¸·Î ÀúÀå
Parameters:
string |
$file_name: |
ÀúÀåµÉ ÆÄÀÏ À̸§ |
resource |
$oid: |
glo ÀνºÅϽº |
API Tags:
resource|bool newGLO(
string
$class_name, string
$file_name
)
|
|
»õ·Î¿î glo Ŭ·¡½º¸¦ ¸¸µé°í oid ¸®ÅÏ
Parameters:
string |
$class_name: |
»ý¼ºµÉ cubrid Ŭ·¡½º À̸§ , ÀϹÝÀûÀ¸·Î glo ¸¦ ¾¹´Ï´Ù. |
string |
$file_name: |
ÀúÀåµÉ ÆÄÀÏ À̸§ |
API Tags:
resource prepare(
string
$query, [string
$option = '']
)
|
|
¹ÙÀεù º¯¼ö »ç¿ë °¡´ÉÇÏ°Ô ÇÏ´Â ¸Þ¼Òµå
¹ÙÀεùµÉ º¯¼ö´Â ? ·Î Ç¥½ÃÇÑ´Ù. //prepare ±âº» »ç¿ë ¿¹Á¦
$sql = "select * from board where title = ?";
$number = "³»¿ë";
$cubrid->bind($stmt, 1, $number);
Parameters:
string |
$query: |
½ÇÇàµÉ Äõ¸®¹® |
string |
$option: |
½ÇÇàµÉ¶§ oid¸¦ ¸®ÅÏÇÒ °ÍÀÎÁö ¿©ºÎ ÁöÁ¤ , 'oid' oid¸®ÅÏ |
API Tags:
Return: | prepare ¸Þ¼Òµå °á°ú resource |
See: | Cubrid::bind() |
Access: | public |
Redefinition of:
- DBClient::prepare()
- prepare
bool printGLO(
[resource
$oid = ''], [string
$content_type = '']
)
|
|
glo ÀνºÅϽº¸¦ Ç¥ÁØÃâ·ÂÀ¸·Î º¸³¿
// ¹ÙÀ̳ʸ® ±×´ë·Î ȸ鿡 Ãâ·Â
// gif À̹ÌÁö ȸ鿡 Ãâ·Â
Parameters:
resource |
$oid: |
glo ÀνºÅϽº |
string |
$content_type: |
header·Î ÁöÁ¤µÉ content-type °ª |
API Tags:
bool put(
string
$attr, mixed
$value, [string
$oid = '']
)
|
|
oid ¼Ó¼º º¯°æ
Parameters:
string |
$attr: |
¼Ó¼º(Çʵå) |
mixed |
$value: |
¼Ó¼º°ª |
string |
$oid: |
oid |
API Tags:
Return: | ¼º°ø ÇßÀ¸¸é true, ¾Æ´Ï¸é false |
Access: | public |
bool puts(
array
$attr_list, [string
$oid = '']
)
|
|
¿©·¯ ¼Ó¼º°ª µ¿½Ã¿¡ ¼³Á¤
$cubrid->puts(array('aa' => 1, 'bb' => 2, 'cc' => 3), $oid);
Parameters:
array |
$attr_list: |
¼Ó¼º¸®½ºÆ® |
string |
$oid: |
oid |
API Tags:
bool putSeq(
string
$attr, int
$index, mixed
$value, [string
$oid = '']
)
|
|
seq ƯÁ¤ ¿µ¿ª º¯°æÇϱâ (update)
Parameters:
string |
$attr: |
¼Ó¼ºÀ̸§ |
int |
$index: |
sequence index , óÀ½ À§Ä¡´Â 1 |
mixed |
$value: |
º¯°æµÉ °ª |
string |
$oid: |
oid |
API Tags:
resource query(
string|resource
$query, [string
$option = '']
)
|
|
ÀÏ¹Ý Äõ¸® ½ÇÇà
$cubrid->query("insert into tclass values ('a')");
Parameters:
string|resource |
$query: |
½ÇÇàµÉ Äõ¸®¹®À̳ª prepare·Î ½ÇÇàµÈ °á°ú resource |
string |
$option: |
½ÇÇàµÉ Äõ¸® ¿É¼Ç, oid, async, all |
API Tags:
Return: | ½ÇÇà resource, ½ÇÆÐÇϸé false |
Access: | public |
Redefinition of:
- DBClient::query()
- Äõ¸® ½ÇÇàÇϱâ
bool saveGLO(
string
$file_name, [resource
$oid = '']
)
|
|
glo ÀνºÅϽº¿¡ file_name¿¡ ÀÖ´Â µ¥ÀÌŸ·Î ¼öÁ¤Çϱâ
ÀνºÅϽº ³»¿ëÀ» ¹Ù²ß´Ï´Ù.
Parameters:
string |
$file_name: |
glo·Î ÀúÀåµÉ ÆÄÀϸí |
resource |
$oid: |
glo ÀνºÅϽº |
API Tags:
bool seek(
int
$count, [string
$origin = 'current']
)
|
|
Ä¿¼ À̵¿
Parameters:
int |
$count: |
À̵¿½Ãų »ó´ëÀ§Ä¡ |
string |
$origin: |
first, current, last, ±âº»°ªÀº current |
API Tags:
Redefinition of:
- DBClient::seek()
- result set À̵¿
void setOID(
string
$oid
)
|
|
oid ¼³Á¤
Parameters:
API Tags:
bool setReadLock(
[string
$oid = '']
)
|
|
Àбâ lock ¼³Á¤
Parameters:
API Tags:
bool setWriteLock(
[string
$oid = '']
)
|
|
¾²±â lock ¼³Á¤
Parameters:
API Tags:
|
|