Class: DBData
Source Location: /php/db/DBData.php
Class DBData
Class Overview
DB °ü·Ã Data¸¦ ´Ù·ç±â À§ÇÑ Å¬·¡½ºÀÔ´Ï´Ù.
$db = DB_('mssql', 'db', true);
$data = new DBData($db, 'members');
$data->userid('cyberuls'); // ³»ºÎÀûÀ¸·Î userid = 'cyberuls' ±¸¹®ÀÌ »ý¼ºÀÌ µË´Ï´Ù.
// Á¶°ÇÀý select
$data->select(" datetime is not null order by 1", false, array('ab','bc','cde'));
// Á¶°ÇÀý selectPage
$page = 1;
$limitPage = 10;
$data->selectPage(" datetime is not null order by 1", $page, $limitPage, array('ab','bc','cde'));
// count ¾ò±â
$limitPage = 10;
$limitBlock = 10;
$arr = $data->selectCount(" datetime is not null ", $limitPage, $limitBlock);
//$arr['count'] : Àüü°³¼ö , $arr['page'] : ÆäÀÌÁö °³¼ö, $arr['block'] : ºí·°°³¼ö
$db->close();
Located in /php/db/DBData.php [line 42]
PObject
|
--Data
|
--DBData
|
Properties
|
Methods
|
Descendants
CubridData |
DB °ü·Ã Data¸¦ ´Ù·ç±â À§ÇÑ Å¬·¡½ºÀÔ´Ï´Ù.
|
Inherited Properties, Constants, and Methods
Property Summary
array |
$types |
µ¥ÀÌŸ ŸÀÔ ¸®½ºÆ® |
Method Summary
bool |
delete() |
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ delete ½ÇÇà |
void |
deleteAll() |
ÇöÀç µ¥ÀÌŸ ¸ðµÎ delete ½ÇÇà |
string |
getTable() |
Å×À̺í À̸§À» ¾ò¾î¿É´Ï´Ù. |
bool |
insert() |
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ insert ½ÇÇà |
void |
insertAll() |
ÇöÀç µ¥ÀÌŸ ¸ðµÎ insert ½ÇÇà |
bool |
update() |
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ update ½ÇÇà |
void |
updateAll() |
ÇöÀç µ¥ÀÌŸ ¸ðµÎ update ½ÇÇà |
Properties
µ¥ÀÌŸ ŸÀÔ ¸®½ºÆ®
API Tags:
Methods
DBData __construct(
[IConnector
$connector = null], [string
$table = null], [string
$where = null], string
$field
)
|
|
»ý¼ºÀÚ
Parameters:
IConnector |
$connector: |
¿¬°áÀÚ |
string |
$table: |
Å×À̺í À̸§ |
string |
$where: |
Á¶°ÇÀý |
string |
$field: |
field¸®½ºÆ® |
API Tags:
Redefinition of:
- Data::__construct()
- »ý¼ºÀÚ
Redefined in descendants as:
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ delete ½ÇÇà
API Tags:
Return: | Äõ¸® ½ÇÇà ¿©ºÎ |
Access: | public |
ÇöÀç µ¥ÀÌŸ ¸ðµÎ delete ½ÇÇà
API Tags:
DBData getSubData(
string
$table, string
$field1, string
$field2, [string
$field_list = '']
)
|
|
¿ÜºÎ µ¥ÀÌŸ µé°í ¿À±â
Parameters:
string |
$table: |
ÀÚ½Ä Å×À̺í À̸§ |
string |
$field1: |
ÀÚ½Ä Çʵå |
string |
$field2: |
ºÎ¸ð Çʵå |
string |
$field_list: |
¾ò¾î¿Ã ÇÊµå ¸®½ºÆ® |
API Tags:
Return: | ÀÚ½Ä Å×À̺í DBData°´Ã¼ |
Access: | public |
Å×À̺í À̸§À» ¾ò¾î¿É´Ï´Ù.
API Tags:
ŸÀÔ ¸®½ºÆ® ¾ò±â
API Tags:
Return: | ŸÀÔ ¸®½ºÆ®¸¦ ¹è¿·Î ¾ò¾î¿É´Ï´Ù. |
Access: | public |
bool insert(
[array
$omit = array()]
)
|
|
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ insert ½ÇÇà
Parameters:
array |
$omit: |
Á¦ÇÑÇÒ ÇÊµå ¸®½ºÆ® |
API Tags:
Return: | Äõ¸® ½ÇÇà ¿©ºÎ |
Access: | public |
void insertAll(
[array
$omit = array()]
)
|
|
ÇöÀç µ¥ÀÌŸ ¸ðµÎ insert ½ÇÇà
Parameters:
array |
$omit: |
Á¦ÇÑÇÒ ÇÊµå ¸®½ºÆ® |
API Tags:
Àüü µ¥ÀÌŸ ºÒ·¯¿À±â
API Tags:
DBData select(
[string
$where = ''], [bool
$hasNext = false], [array
$field_list = array()]
)
|
|
°Ë»öÄõ¸®
echo $data->select(" a = '1' ", false, array('a', 'b', 'c'));
Parameters:
string |
$where: |
Á¶°ÇÀý |
bool |
$hasNext: |
ÇÑÄ ÀüÁø ¿©ºÎ |
array |
$field_list: |
¾ò¾î¿Ã ÇÊµå ¸®½ºÆ® |
API Tags:
array selectCount(
[string
$where = ''], [int
$pagesize = 10], [int
$blocksize = 10]
)
|
|
°Ë»ö °¹¼ö ¾ò¾î¿À±â
Parameters:
string |
$where: |
Á¶°Ç¹® |
int |
$pagesize: |
ÇÑ ÆäÀÌÁö´ç ³ªÅ¸³¾ ·¹ÄÚµå °³¼ö |
int |
$blocksize: |
ÇÑ ºí·°´ç ³ªÅ¸³¾ ÆäÀÌÁö °³¼ö |
API Tags:
DBData selectPage(
[string
$where = ''], [int
$page = 1], [int
$pagesize = 10], [array
$field_list = array()]
)
|
|
ÆäÀÌ¡ °Ë»ö Äõ¸®
echo $data->selectPage(" a = '1' ", 1, 10, array('a', 'b', 'c'));
Parameters:
string |
$where: |
Á¶°ÇÀý |
int |
$page: |
°Ë»öµÉ ÆäÀÌÁö |
int |
$pagesize: |
ÇÑÆäÀÌÁö´ç ·¹ÄÚµå °³¼ö |
array |
$field_list: |
ÇÊµå ¸®½ºÆ® |
API Tags:
void setTable(
string
$table
)
|
|
Å×À̺í À̸§ ¼³Á¤
Parameters:
string |
$table: |
Å×À̺íÀ̸§ |
API Tags:
void setTypeList(
array
$arr
)
|
|
ŸÀÔ ¸®½ºÆ®¸¦ ¼³Á¤ÇÕ´Ï´Ù.
$dbdata->setTypeList(array('field1' => 'varchar', .... ));
Parameters:
API Tags:
bool update(
[array
$omit = array()], [bool
$is_update_field = false]
)
|
|
ÇöÀç À妽º¿¡ ÀÖ´Â µ¥ÀÌŸ update ½ÇÇà
Parameters:
array |
$omit: |
Á¦ÇÑÇÒ ÇÊµå ¸®½ºÆ® |
bool |
$is_update_field: |
false Á¦¿ÜÇÒ Çʵå, true Àû¿ëÇÒ Çʵå |
API Tags:
Return: | Äõ¸® ½ÇÇà ¿©ºÎ |
Access: | public |
void updateAll(
[array
$omit = array()]
)
|
|
ÇöÀç µ¥ÀÌŸ ¸ðµÎ update ½ÇÇà
Parameters:
array |
$omit: |
Á¦ÇÑÇÒ ÇÊµå ¸®½ºÆ® |
API Tags:
DBData __call(
$field,
$args, string|array
$values, string
$type, string
$column
)
|
|
ÇÊµå °ªÀ¸·Î °Ë»öÇÑ´Ù.
// num ÇÊµå °ªÀÌ 9 ÀÎ ·¹ÄÚµåÀÇ ¸ðµç Çʵå
echo $data->num(9, 'int', '*');
//str ÇÊµå °ªÀÌ Y,N ÀÎ ·¹ÄÚµåÀÇ A,B,C Çʵå
echo $data->str(array('Y','N'), 'string', 'A,B,C');
Parameters:
string|array |
$values: |
Çʵ尪 ¸®½ºÆ® |
string |
$type: |
ŸÀÔ |
string |
$column: |
³ªÅ¸³¯ Ä÷³ ¸®½ºÆ® |
|
$field: |
|
|
$args: |
|
API Tags:
Method: | DBData any_field(): any_field(string|array $values, string $type, string $column) |
Access: | public |
|
|