Class: DBClient
Source Location: /php/db/DBClient.php
Class DBClient
Class Overview
DB ¿¬°áÀÚ¿¡ ´ëÇÑ Ãß»ó Ŭ·¡½ºÀÔ´Ï´Ù.
// DB ¿¬°á
$db = db_('mssql', 'test_db', true);
// ¸ÞŸ µ¥ÀÌŸ ¾ò¾î¿À±â
echo $data->top(1);
// ÇÁ·Î½ÃÀú »ç¿ë
$db->spBind('aaa', 'int', 3, $is_output);
$db->spBind('bbb', 'int', 3, 'return', $var);
// DB Á¾·á
Located in /php/db/DBClient.php [line 39]
PObject
|
--DBClient
Author(s):
API Tags:
|
Properties
|
Methods
|
Inherited Properties, Constants, and Methods
Method Summary
void |
addSql() |
sql history ±â·ÏÇϱâ |
bool |
begin() |
Æ®·£Àè¼Ç ½ÃÀÛ |
void |
bind() |
prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù. |
string |
escape() |
°¢°¢ DBº° ¹®ÀÚ¿ escape |
void |
execute() |
prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù. |
array |
fetch() |
·¹ÄÚµå °¡Á®¿À±â |
array |
getFieldList() |
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ Çʵ帮½ºÆ®¸¦ °¡Áö°í ¿Â´Ù. |
array |
getFieldTypeList() |
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ ÇʵåÀÇ Å¸ÀÔ ¸®½ºÆ®¸¦ °¡Áö°í ¿Â´Ù. |
string |
getSql() |
½ÇÇàµÈ sql ¾ò¾î¿À±â |
string |
getTypeString() |
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â |
boolean |
is() |
ÇöÀç DB È®ÀÎÇϱâ |
resource |
query() |
Äõ¸® ½ÇÇàÇϱâ |
void |
seek() |
result set À̵¿ |
void |
setConfig() |
¿¬°á¼³Á¤, /php/db/conf/{name}.ini ÆÄÀÏ¿¡ ¼³Á¤ ÀúÀå |
void |
spBind() |
¹ÙÀεù ¸®½ºÆ® ¼³Á¤ |
mixed |
spGet() |
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¾ò±â |
void |
spName() |
ÇÁ·Î½ÃÀú À̸§¼³Á¤ |
void |
spSet() |
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¼³Á¤ |
int |
sql() |
sql id ·Î Äõ¸® ½ÇÇà |
string |
ts() |
getTypeString º°Äª |
mixed |
__get() |
¼Ó¼º Àоî¿À±â , getAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù. |
mixed |
__set() |
¼Ó¼º ¼³Á¤Çϱâ , setAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù. |
Properties
ÇÁ·Î½ÃÀú º¯¼ö ¸®½ºÆ®
API Tags:
ÇÁ·Î½ÃÀú ½ÇÇà°á°ú resource
API Tags:
¹ÙÀεù °ü·ÃµÈ ¿É¼Ç
type : ¹ÙÀεùµÉ ŸÀÔ, proc, sql, insert, delete, update API Tags:
ÇÁ·Î½ÃÀú ½ÇÇà resource
API Tags:
Methods
static DBClient createConnector(
string
$dbClass, string|array
$db, [bool
$isConnect = false]
)
|
|
¿¬°áÀÚ »ý¼º ÆÐÅÏ
Parameters:
string |
$dbClass: |
database Á¾·ù (mysql, mssql, oracle, progres, cubrid, sqlite) |
string|array |
$db: |
db¼³Á¤ ÆÄÀÏ¸í ¶Ç´Â db¿¬°áȯ°æ ¹è¿ |
bool |
$isConnect: |
database ¿¬°á ¿©ºÎ , ¿¬°áÀ̸é true , ±âº»°ª false |
API Tags:
Return: | DBClient »ó¼Ó Ŭ·¡½º |
Access: | public |
DBClient __construct(
[
$option = '']
)
|
|
Parameters:
API Tags:
Redefinition of:
- PObject::__construct()
- »ý¼ºÀÚ
Redefined in descendants as:
void addSql(
string
$sql
)
|
|
sql history ±â·ÏÇϱâ
Parameters:
API Tags:
Äõ¸® ½ÇÇà¿¡ ¿µÇâÀ» ¹ÞÀº rowÀÇ ¼ö
API Tags:
Redefined in descendants as:
Æ®·£Àè¼Ç ½ÃÀÛ
API Tags:
Return: | ½ÃÀ۵ǾúÀ¸¸é true, ¾Æ´Ï¸é false |
Access: | public |
Redefined in descendants as:
void bind(
string
$name, [string
$type = ''], [string
$output = 'in'], [int
$length = -1], [
&$value = null], mixed
$value
)
|
|
prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù.
»ó¼Ó¹ÞÀº Ŭ·¡½º¿¡¼ ±¸Çö
Parameters:
string |
$name: |
¹ÙÀεù À̸§ |
string |
$type: |
¹ÙÀεùµÉ ŸÀÔ, µ¥ÀÌŸº£À̽º ¸¶´Ù Ʋ¸² |
string |
$output: |
output ÇüÅÂ, in, out, inout, return |
int |
$length: |
µ¥ÀÌŸ±æÀÌ, -1Àº ±æÀÌÁ¦ÇÑ ¾øÀ½ |
mixed |
$value: |
ÀúÀåµÉ µ¥ÀÌŸ ¶Ç´Â output º¯¼ö¿¡ ÀúÀåµÉ µ¥ÀÌŸ |
|
&$value: |
|
API Tags:
Redefined in descendants as:
¿¬°á´Ý±â
API Tags:
Redefined in descendants as:
commit
API Tags:
Redefined in descendants as:
¿¬°á
API Tags:
Return: | ¿¬°áÀÚ °´Ã¼ |
Access: | public |
DBData createData(
$result, resource
$resource
)
|
|
DBData °´Ã¼ »ý¼º
Parameters:
resource |
$resource: |
°á°ú ¸®¼Ò½º |
|
$result: |
|
API Tags:
DBProc createProc(
string
$name, [mixed
$option = '']
)
|
|
ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼ ¸®ÅÏ , ÇÏÀ§¿¡¼ ±¸ÇöÇØ¾ßÇÕ´Ï´Ù.
Parameters:
string |
$name: |
|
mixed |
$option: |
|
API Tags:
Redefined in descendants as:
unknown_type deleteFrom(
unknown_type
$table
)
|
|
Parameters:
API Tags:
Deprecated: | |
Access: | public |
¿¡·¯ ¸®ÅÏ
API Tags:
Redefined in descendants as:
string escape(
string
$str
)
|
|
°¢°¢ DBº° ¹®ÀÚ¿ escape
Parameters:
string |
$str: |
escape µÉ ¹®ÀÚ¿ |
API Tags:
Return: | escape µÈ ¹®ÀÚ¿ |
Access: | public |
Redefined in descendants as:
prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù.
»ó¼Ó¹ÞÀº Ŭ·¡½º¿¡¼ ±¸Çö
API Tags:
Redefined in descendants as:
array fetch(
resource
$result
)
|
|
·¹ÄÚµå °¡Á®¿À±â
Parameters:
resource |
$result: |
°á°ú ¼Â |
API Tags:
Redefined in descendants as:
-
Cubrid::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Mssql::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Mysql::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Mysql_i::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Oracle::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Postgres::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
-
Sqlite::fetch()
: ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
array fetchAll(
resource
$result
)
|
|
Àüü ·¹ÄÚµå °¡Á®¿À±â
Parameters:
resource |
$result: |
°á°ú ¼Â |
API Tags:
Return: | ·¹ÄÚµå¹è¿ |
Access: | public |
Redefined in descendants as:
void free(
resource
$result
)
|
|
¸Þ¸ð¸® ÇØÁ¦
Parameters:
resource |
$result: |
°á°ú ¼Â |
API Tags:
Redefined in descendants as:
void freeStatement(
$stmt
)
|
|
prepare µÈ ±¸¹® ¸Þ¸ð¸® ÇØÁ¦
»ó¼Ó¹ÞÀº Ŭ·¡½º¿¡¼ ±¸Çö
Parameters:
API Tags:
Redefined in descendants as:
DBData getBindData(
[bool
$isOne = false], string
$baseClass
)
|
|
result set ÀÌ ¼³Á¤µÈ »óÅ¿¡¼ ¹Ù·Î DBData °´Ã¼¸¦ ±¸ÇÔ
Parameters:
bool |
$isOne: |
true : ÇÑÄÀüÁø |
string |
$baseClass: |
Ŭ·¡½º À̸§ |
API Tags:
resource getConnection(
)
|
|
¿¬°á resource ¹Ýȯ
API Tags:
DBData getData(
string
$query, [boolean
$isOne = false]
)
|
|
DBData ±¸ÇÔ
Parameters:
string |
$query: |
DB query |
boolean |
$isOne: |
À妽º ÇÑÄ ¿Å±â±â |
API Tags:
Redefined in descendants as:
int getFieldCount(
resource
$result
)
|
|
ÇÊµå °³¼ö °¡Áö°í ¿À±â
Parameters:
resource |
$result: |
°á°ú ¼Â |
API Tags:
Redefined in descendants as:
array getFieldList(
resource
$result
)
|
|
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ Çʵ帮½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
DBData°´Ã¼¸¦ ¸¸µé ¶§ »ç¿ëµÇ¾îÁü
Parameters:
resource |
$result: |
Äõ¸® ½ÇÇà °á°ú |
API Tags:
Redefined in descendants as:
string getFieldName(
resource
$result, int
$i
)
|
|
Çʵå À̸§ °¡Áö°í ¿À±â
Parameters:
resource |
$result: |
°á°ú ¼Â |
int |
$i: |
Çʵå offset, 0-based number |
API Tags:
Return: | Çʵå À̸§ |
Abstract: | |
Access: | public |
Redefined in descendants as:
string getFieldType(
resource
$result, int
$i
)
|
|
Çʵå ŸÀÔ °¡Áö°í ¿À±â
Parameters:
resource |
$result: |
°á°ú ¼Â |
int |
$i: |
Çʵå offset, 0-based number |
API Tags:
Return: | Çʵå ŸÀÔ À̸§ |
Abstract: | |
Access: | public |
Redefined in descendants as:
array getFieldTypeList(
resource
$result
)
|
|
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼ ÇʵåÀÇ Å¸ÀÔ ¸®½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
DBData°´Ã¼¸¦ ¸¸µé ¶§ »ç¿ëµÇ¾îÁü
Parameters:
resource |
$result: |
Äõ¸® ½ÇÇà °á°ú |
API Tags:
Redefined in descendants as:
DBData getMetaData(
[string
$meta_type = 'table'], [string
$object = ''], [array
$option = array()]
)
|
|
ÅëÇÕ ¸ÞŸ µ¥ÀÌŸ ¾ò¾î¿À±â
ÆÄÀÏ °æ·Î : php/db/meta/
ÆÄÀÏ Çü½Ä : {¸ÞŸŸÀÔ}Data_{program}{version}.php // ÇöÀç ¿¬°áµÈ dbÀÇ »ç¿ëÀÚ Å×ÀÌºí ¸®½ºÆ®¸¦ Data°´Ã¼·Î ¹Ýȯ
// ÁÖ¾îÁø Å×ÀÌºí¿¡ ´ëÇØ¼ À妽º ¸®½ºÆ®¸¦ Data°´Ã¼·Î ¹Ýȯ
// ÁÖ¾îÁø Å×ÀÌºí¿¡ ´ëÇØ¼ Ä÷³ ¸®½ºÆ®¸¦ Data°´Ã¼·Î ¹Ýȯ
Parameters:
string |
$meta_type: |
¾ò¾î¿Ã ¸ÞŸµ¥ÀÌŸ ŸÀÔ ÇüÅ (table, database, column, index, job, param, proc, view, serial, etc) |
string |
$object: |
°´Ã¼ À̸§ |
array |
$option: |
±× ¿Ü ¿É¼Ç, DB¸¶´Ù Ʋ¸² |
API Tags:
DBData getOne(
string
$query, string
$baseClass
)
|
|
ÇѰ³Â¥¸® Record ¾ò¾î¿Ã ¶§»ç¿ë
Parameters:
string |
$query: |
|
string |
$baseClass: |
|
API Tags:
array getPageCount(
int
$total, int
$limitPage, int
$limitBlock
)
|
|
ÆäÀÌÁö °è»ê
Parameters:
int |
$total: |
Àüü °³¼ö |
int |
$limitPage: |
ÆäÀÌÁö ´ç ¸®½ºÆ® ¼ýÀÚ |
int |
$limitBlock: |
ºí·°´ç ÆäÀÌÁö ¼ýÀÚ |
API Tags:
Return: | count : Àüü¼ýÀÚ, page : ÆäÀÌÁö ¼ö, block : ºí·° ¼ö |
Access: | public |
array getPageCountQuery(
string
$sql, int
$limitPage, int
$limitBlock
)
|
|
ÀϹÝÄõ¸® ÆäÀÌÁö °è»ê
count(*) ÀÇ alias·Î cnt ¸¦ ÁöÁ¤ÇØ¾ß ÇÔ .
Parameters:
string |
$sql: |
ÀϹÝÄõ¸® ´ë»ó |
int |
$limitPage: |
ÆäÀÌÁö ´ç ¸®½ºÆ® ¼ýÀÚ |
int |
$limitBlock: |
ºí·°´ç ÆäÀÌÁö ¼ýÀÚ |
API Tags:
Return: | count : Àüü¼ýÀÚ, page : ÆäÀÌÁö ¼ö, block : ºí·° ¼ö |
Access: | public |
array getPageCountSubquery(
string
$sql, int
$limitPage, int
$limitBlock
)
|
|
¼ºêÄõ¸® ÆäÀÌÁö °è»ê
Parameters:
string |
$sql: |
¼ºêÄõ¸® ´ë»ó |
int |
$limitPage: |
ÆäÀÌÁö ´ç ¸®½ºÆ® ¼ýÀÚ |
int |
$limitBlock: |
ºí·°´ç ÆäÀÌÁö ¼ýÀÚ |
API Tags:
Return: | count : Àüü¼ýÀÚ, page : ÆäÀÌÁö ¼ö, block : ºí·° ¼ö |
Access: | public |
DBData getPageData(
string
$query, int
$page, [int
$count = 10]
)
|
|
paging µÈ DBData ¾ò¾î¿À±â
Parameters:
string |
$query: |
|
int |
$page: |
default 1 |
int |
$count: |
default 10 |
API Tags:
Redefined in descendants as:
array getProperty(
array
$arr
)
|
|
¿¬°á¼Ó¼º ¼³Á¤
Parameters:
API Tags:
Return: | º¯¼ö °ªÀ» ÇÊÅ͸µ ÇÏ°í ³Ñ°ÜÁØ´Ù. |
Access: | public |
resource getResult(
[
$result = null]
)
|
|
Äõ¸® ½ÇÇàÇÑ °á°ú
Parameters:
API Tags:
Redefined in descendants as:
string getSql(
[int
$num = '']
)
|
|
½ÇÇàµÈ sql ¾ò¾î¿À±â
Parameters:
int |
$num: |
½ÇÇàµÈ sql À妽º ¹øÈ£ |
API Tags:
Return: | sql |
Access: | public |
void getSqlTemplate(
string
$id, [
$param = array()], array
$data
)
|
|
SQL ÅÛÇø´ »ý¼º
Parameters:
string |
$id: |
sql ÆÄÀÏ ¾ÆÀ̵ð |
array |
$data: |
sql ÅÛÇø´À» »ý¼ºÇÒ ¶§ ÇÊ¿äÇÑ µ¥ÀÌŸ |
|
$param: |
|
API Tags:
int|string getTypeConstant(
string
$type
)
|
|
Çʵå ŸÀÔ(ÀÚ·áÇü)º° php¿ë Àü¿ë »ó¼ö ¾ò¾î¿À±â
Parameters:
API Tags:
Return: | PHP»ó¼ö |
Access: | public |
Redefined in descendants as:
string getTypeString(
string
$type, mixed
$value, [boolean
$is_null = false]
)
|
|
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿ ¾ò¾î¿À±â
Parameters:
string |
$type: |
ŸÀÔ¹®ÀÚ¿ |
mixed |
$value: |
ÀԷ°ª |
boolean |
$is_null: |
³ÎÀ» üũÇÒ °ÍÀÎÁö ¿©ºÎ , true ³Îüũ, false ³Î üũ ¾ÈÇÔ |
API Tags:
Return: | º¯È¯µÈ ¹®ÀÚ¿ |
Access: | public |
Redefined in descendants as:
boolean is(
string
$db_name, [string
$version = '']
)
|
|
ÇöÀç DB È®ÀÎÇϱâ
if ($dbclient->is('mssql')) {
echo "database is mssql";
}
if ($dbclient->is('mysql', '5')) {
echo "current version : mysql 5" ;
}
Parameters:
string |
$db_name: |
µ¥ÀÌŸº£À̽º Á¾·ù (mysql, mssql, oracle, postgres, cubrid, sqlite) |
string |
$version: |
¼Ó¼º°ª |
API Tags:
¿¬°áµÇ¾î ÀÖ´ÂÁö ¿©ºÎ¸¦ ¾Ë·ÁÁÜ
API Tags:
Return: | ¿¬°áµÇ¾î ÀÖÀ¸¸é true, ¾Æ´Ï¸é false |
Access: | public |
prepare
»ó¼Ó¹ÞÀº Ŭ·¡½º¿¡¼ ±¸Çö
Parameters:
API Tags:
Redefined in descendants as:
½ÇÇàµÈ sql Ãâ·ÂÇϱâ
API Tags:
resource query(
string
$sql
)
|
|
Äõ¸® ½ÇÇàÇϱâ
Parameters:
API Tags:
Return: | °á°ú ¼Â, ¾øÀ» °æ¿ì´Â false |
Abstract: | |
Access: | public |
Redefined in descendants as:
rollback
API Tags:
Redefined in descendants as:
¿É¼Ç ½ÇÇà
¿¬°áÀÚ ±¸¼ºÀÌ¿ÜÀÇ ¼³Á¤µÈ ¿É¼ÇÀ» ÀÚµ¿À¸·Î ½ÇÇàÇÑ´Ù. DB¿¡ ¸Â°Ô ±¸¼ºÇØÁÖ¼¼¿ä.
API Tags:
Redefined in descendants as:
result set À̵¿
Parameters:
int |
$count: |
À̵¿ÇÒ rowÀÇ ¼ö |
API Tags:
Redefined in descendants as:
void set(
[array
$option = array()]
)
|
|
¿¬°á¼³Á¤
Parameters:
array |
$option: |
¿¬°áÀÚ º¯¼ö À̸§ |
API Tags:
void setConfig(
string
$name, [string
$type = 'default']
)
|
|
¿¬°á¼³Á¤, /php/db/conf/{name}.ini ÆÄÀÏ¿¡ ¼³Á¤ ÀúÀå
program : dbÇÁ·Î±×·¥ host : db ÁÖ¼Ò port : Æ÷Æ® id : ¾ÆÀ̵ð pass : ºñ¹Ð¹øÈ£ db : db À̸§ version : ¹öÀü schema : ½ºÅ°¸¶
db ¸¶´Ù Á¶±Ý¾¿ Ʋ¸³´Ï´Ù.
Parameters:
string |
$name: |
¿¬°áÀÚ º¯¼ö À̸§ |
string |
$type: |
$type ¿¡ ¸Â´Â ¿¬°áÀÚ ¼³Á¤ |
API Tags:
void setConnection(
$con
)
|
|
¿¬°á resource ¼³Á¤
Parameters:
API Tags:
󸮰á°ú ¼³Á¤
Parameters:
API Tags:
void setResult(
resource
$result
)
|
|
±âº» °á°ú¼ÂÀ» ¼³Á¤
Parameters:
API Tags:
void setStatement(
$stmt
)
|
|
Parameters:
API Tags:
void spBind(
string
$name, [string
$type = ''], [string
$output = 'in'], [int
$length = -1], [mixed
&$value = null], [array
$option = array()]
)
|
|
¹ÙÀεù ¸®½ºÆ® ¼³Á¤
Parameters:
string |
$name: |
¹ÙÀεù À̸§ |
string |
$type: |
¹ÙÀεùµÉ ŸÀÔ, µ¥ÀÌŸº£À̽º ¸¶´Ù Ʋ¸² |
string |
$output: |
output ÇüÅÂ, in, out, inout, return |
int |
$length: |
µ¥ÀÌŸ±æÀÌ, -1Àº ±æÀÌÁ¦ÇÑ ¾øÀ½ |
mixed |
&$value: |
ÀúÀåµÉ µ¥ÀÌŸ ¶Ç´Â output º¯¼ö¿¡ ÀúÀåµÉ µ¥ÀÌŸ |
array |
$option: |
¹ÙÀεù µÉ¶§ ±âŸ ¿É¼Ç update : bool, ¾÷µ¥ÀÌÆ® Çʵå op : Á¶°ÇÁ¦¾î , "and", "or" |
API Tags:
ÇÁ·Î½ÃÀú ½ÇÇà
ÀÌ Å¬·¡½º¸¦ »ó¼ÓÇϴ Ŭ·¡½º´Â spExecute ¸Þ¼Òµå¸¦ ÅëÇØ¼ ÀúÀåÇÁ·Î½ÃÀúÀÇ ½ÇÇàÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
API Tags:
Redefined in descendants as:
mixed spGet(
string
$name
)
|
|
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¾ò±â
Parameters:
string |
$name: |
ÆÄ¶ó¹ÌÅÍ À̸§ |
API Tags:
Return: | spBind¿¡¼ ¼³Á¤Çß´ø $value °ªÀ» °¡Áö°í ¿É´Ï´Ù. |
See: | DBProc::get() |
Deprecated: | |
Access: | public |
ÆÄ¶ó¹ÌÅÍ ¸®½ºÆ® ¾ò¾î¿À±â
API Tags:
Return: | ¹ÙÀεù À̸§¿¡ ÀúÀåµÈ value °ªÀ» ¹è¿·Î ¸®ÅÏÇÕ´Ï´Ù. |
See: | DBProc::gets() |
Deprecated: | |
Access: | public |
void spName(
string
$str, [string|array
$option = 'proc']
)
|
|
ÇÁ·Î½ÃÀú À̸§¼³Á¤
Parameters:
string |
$str: |
±¸¹® or ÇÁ·Î½ÃÀú À̸§ |
string|array |
$option: |
¹ÙÀεùÀ» »ý¼ºÇÒ ¿É¼ÇÀ» ¼³Á¤ÇÑ´Ù. type : ¹ÙÀεùÇÒ ±¸¹® ŸÀÔ, proc,sql,insert,update,delete µîÀ¸·Î Áö¿øµÉ ¿¹Á¤ÀÌ´Ù. |
API Tags:
void spSet(
string
$name, mixed
$value
)
|
|
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¼³Á¤
Parameters:
string |
$name: |
¹ÙÀεù À̸§ |
mixed |
$value: |
¹ÙÀεù À̸§¿¡ ÀúÀåµÉ µ¥ÀÌŸ |
API Tags:
void spSetParameters(
array
$arr
)
|
|
ÆÄ¶ó¹ÌÅÍ ¸®½ºÆ® ¼³Á¤
Parameters:
array |
$arr: |
¹ÙÀεù¿¡ ÀúÀåµÉ °ªÀ» ¼³Á¤ ÇÕ´Ï´Ù. |
API Tags:
int sql(
string
$id, [array
$param = array()]
)
|
|
sql id ·Î Äõ¸® ½ÇÇà
Parameters:
string |
$id: |
|
array |
$param: |
|
API Tags:
DBData sqlData(
string
$id, [array
$param = array()]
)
|
|
sql id ·Î DBData ¾ò¾î¿À±â
Parameters:
string |
$id: |
|
array |
$param: |
|
API Tags:
DBData sqlOne(
string
$id, [array
$param = array()]
)
|
|
sql id ·Î DBData ¾ò¾î¿À±â
Parameters:
string |
$id: |
|
array |
$param: |
|
API Tags:
DBData sqlPage(
string
$id, [array
$param = array()]
)
|
|
sql id ·Î ÆäÀÌ¡µÈ DBData ¾ò¾î¿À±â
Parameters:
string |
$id: |
|
array |
$param: |
|
API Tags:
string ts(
string
$type, mixed
&$value, [boolean
$is_null = false]
)
|
|
getTypeString º°Äª
Parameters:
string |
$type: |
ŸÀÔ¹®ÀÚ¿ |
mixed |
&$value: |
ÀԷ°ª |
boolean |
$is_null: |
³ÎÀ» üũÇÒ °ÍÀÎÁö ¿©ºÎ , true ³Îüũ, false ³Î üũ ¾ÈÇÔ |
API Tags:
Return: | º¯È¯µÈ ¹®ÀÚ¿ |
Access: | public |
¿¬°á ¸®¼Ò½º ¸®ÅÏ
API Tags:
Return: | ¿¬°á ¸®¼Ò½º |
Abstract: | |
Access: | protected |
Redefined in descendants as:
mixed __get(
string
$key
)
|
|
¼Ó¼º Àоî¿À±â , getAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù.
ex) echo $dbclient->program;
Parameters:
string |
$key: |
¿¬°áÀÚ º¯¼ö À̸§ |
API Tags:
mixed __set(
string
$key, mixed
$value
)
|
|
¼Ó¼º ¼³Á¤Çϱâ , setAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù.
ex) $dbclient->program = "mssql";
Parameters:
string |
$key: |
¼Ó¼º À̸§ |
mixed |
$value: |
¼Ó¼º°ª |
API Tags:
|
|