phpDocumentor php-db
[ class tree: php-db ] [ index: php-db ] [ all elements ]

Class: Mysql

Source Location: /php/db/Mysql.php

Class Mysql

Descendants
Child Class Description
Mysql_i mysqli ¿¬°á Ŭ·¡½º

[ Top ]
Inherited Properties, Constants, and Methods
Inherited Properties Inherited Methods Inherited Constants

Inherited From DBClient

DBClient::$__sp_bind_list
DBClient::$__sp_execute_result
DBClient::$__sp_name
DBClient::$__sp_option
DBClient::$__sp_statement

Inherited From DBClient

DBClient::__construct()
DBClient::addSql()
sql history ±â·ÏÇϱâ
DBClient::affectedRows()
Äõ¸® ½ÇÇà¿¡ ¿µÇâÀ» ¹ÞÀº rowÀÇ ¼ö
DBClient::begin()
Æ®·£Àè¼Ç ½ÃÀÛ
DBClient::bind()
prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù.
DBClient::close()
¿¬°á´Ý±â
DBClient::commit()
commit
DBClient::connect()
¿¬°á
DBClient::createConnector()
¿¬°áÀÚ »ý¼º ÆÐÅÏ
DBClient::createData()
DBData °´Ã¼ »ý¼º
DBClient::createProc()
ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÒ °´Ã¼ ¸®ÅÏ , ÇÏÀ§¿¡¼­ ±¸ÇöÇØ¾ßÇÕ´Ï´Ù.
DBClient::deleteFrom()
DBClient::error()
¿¡·¯ ¸®ÅÏ
DBClient::escape()
°¢°¢ DBº° ¹®ÀÚ¿­ escape
DBClient::execute()
prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù.
DBClient::fetch()
·¹ÄÚµå °¡Á®¿À±â
DBClient::fetchAll()
Àüü ·¹ÄÚµå °¡Á®¿À±â
DBClient::free()
¸Þ¸ð¸® ÇØÁ¦
DBClient::freeStatement()
prepare µÈ ±¸¹® ¸Þ¸ð¸® ÇØÁ¦
DBClient::getBindData()
result set ÀÌ ¼³Á¤µÈ »óÅ¿¡¼­ ¹Ù·Î DBData °´Ã¼¸¦ ±¸ÇÔ
DBClient::getConnection()
¿¬°á resource ¹Ýȯ
DBClient::getData()
DBData ±¸ÇÔ
DBClient::getExecute()
ó¸® °á°ú ¸®ÅÏ
DBClient::getFieldCount()
ÇÊµå °³¼ö °¡Áö°í ¿À±â
DBClient::getFieldList()
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼­ Çʵ帮½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
DBClient::getFieldName()
Çʵå À̸§ °¡Áö°í ¿À±â
DBClient::getFieldType()
Çʵå ŸÀÔ °¡Áö°í ¿À±â
DBClient::getFieldTypeList()
½ÇÇàµÇ¾îÁø Äõ¸®¿¡ ´ëÇØ¼­ ÇʵåÀÇ Å¸ÀÔ ¸®½ºÆ®¸¦ °¡Áö°í ¿Â´Ù.
DBClient::getMetaData()
ÅëÇÕ ¸ÞŸ µ¥ÀÌŸ ¾ò¾î¿À±â
DBClient::getOne()
ÇѰ³Â¥¸® Record ¾ò¾î¿Ã ¶§»ç¿ë
DBClient::getPageCount()
ÆäÀÌÁö °è»ê
DBClient::getPageCountQuery()
ÀϹÝÄõ¸® ÆäÀÌÁö °è»ê
DBClient::getPageCountSubquery()
¼­ºêÄõ¸® ÆäÀÌÁö °è»ê
DBClient::getPageData()
paging µÈ DBData ¾ò¾î¿À±â
DBClient::getProperty()
¿¬°á¼Ó¼º ¼³Á¤
DBClient::getResult()
Äõ¸® ½ÇÇàÇÑ °á°ú
DBClient::getSql()
½ÇÇàµÈ sql ¾ò¾î¿À±â
DBClient::getSqlTemplate()
SQL ÅÛÇø´ »ý¼º
DBClient::getStatement()
DBClient::getTypeConstant()
Çʵå ŸÀÔ(ÀÚ·áÇü)º° php¿ë Àü¿ë »ó¼ö ¾ò¾î¿À±â
DBClient::getTypeString()
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿­ ¾ò¾î¿À±â
DBClient::is()
ÇöÀç DB È®ÀÎÇϱâ
DBClient::isConnected()
¿¬°áµÇ¾î ÀÖ´ÂÁö ¿©ºÎ¸¦ ¾Ë·ÁÁÜ
DBClient::prepare()
prepare
DBClient::printSql()
½ÇÇàµÈ sql Ãâ·ÂÇϱâ
DBClient::query()
Äõ¸® ½ÇÇàÇϱâ
DBClient::rollback()
rollback
DBClient::runOption()
¿É¼Ç ½ÇÇà
DBClient::seek()
result set À̵¿
DBClient::set()
¿¬°á¼³Á¤
DBClient::setConfig()
¿¬°á¼³Á¤, /php/db/conf/{name}.ini ÆÄÀÏ¿¡ ¼³Á¤ ÀúÀå
DBClient::setConnection()
¿¬°á resource ¼³Á¤
DBClient::setExecute()
󸮰á°ú ¼³Á¤
DBClient::setResult()
±âº» °á°ú¼ÂÀ» ¼³Á¤
DBClient::setStatement()
DBClient::spBind()
¹ÙÀεù ¸®½ºÆ® ¼³Á¤
DBClient::spExecute()
ÇÁ·Î½ÃÀú ½ÇÇà
DBClient::spGet()
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¾ò±â
DBClient::spGetParameters()
ÆÄ¶ó¹ÌÅÍ ¸®½ºÆ® ¾ò¾î¿À±â
DBClient::spName()
ÇÁ·Î½ÃÀú À̸§¼³Á¤
DBClient::spSet()
ÆÄ¶ó¹ÌÅÍ º¯¼ö ¼³Á¤
DBClient::spSetParameters()
ÆÄ¶ó¹ÌÅÍ ¸®½ºÆ® ¼³Á¤
DBClient::sql()
sql id ·Î Äõ¸® ½ÇÇà
DBClient::sqlData()
sql id ·Î DBData ¾ò¾î¿À±â
DBClient::sqlOne()
sql id ·Î DBData ¾ò¾î¿À±â
DBClient::sqlPage()
sql id ·Î ÆäÀÌ¡µÈ DBData ¾ò¾î¿À±â
DBClient::ts()
getTypeString º°Äª
DBClient::_connect()
¿¬°á ¸®¼Ò½º ¸®ÅÏ
DBClient::__destruct()
¼Ò¸êÀÚ
DBClient::__get()
¼Ó¼º Àоî¿À±â , getAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù.
DBClient::__set()
¼Ó¼º ¼³Á¤Çϱâ , setAttribute() ¿Í °°Àº ¿ªÇÒÀÔ´Ï´Ù.

Inherited From PObject

PObject::__construct()
»ý¼ºÀÚ
PObject::display()
°´Ã¼ ¹®ÀÚ¿­À» Ãâ·Â
PObject::equals()
°´Ã¼ ºñ±³ (¼öÁ¤ ÇÊ¿ä)
PObject::getClass()
PObject::getObjValue()
°´Ã¼ÀÎÁö ¾Æ´ÑÁö ÆÇº°Çؼ­ PObject Çü °´Ã¼À̸é toString() ¸Þ¼Òµå·Î ¹®ÀÚ¿­À» ¹ÝȯÇϰí ÀÏ´Ü ÀÚ·áÇüÀÌ¸é ±× ÇüÅ ±×´ë·Î ¸®ÅÏÇÑ´Ù
PObject::isObject()
°´Ã¼ È®ÀÎ
PObject::toString()
°´Ã¼ ¹®ÀÚ¿­·Î º¯È¯
PObject::__toString()
magic methods Ãß°¡ , toString() ÀÇ °ªÀ» ±×´ë·Î ¸®ÅÏÇÑ´Ù.

[ Top ]
Method Summary
Mysql   __construct()   »ý¼ºÀÚ
int   affectedRows()   ½ÇÇàµÈ row ¼ö
bool   begin()   Æ®·£Àè¼Ç ½ÃÀÛ
void   bind()   ±¸Çö¾ÈµÊ
void   close()   ¿¬°á ´Ý±â
bool   commit()   commit
string   error()   ¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ
string   escape()   ¹®ÀÚ¿­ escape
void   execute()   ±¸Çö¾ÈµÊ
array   fetch()   ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼­ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
bool   free()   ¸Þ¸ð¸® ÇØÁ¦
string   getClientEncoding()   Ŭ¶óÀÌ¾ðÆ® ÀÎÄÚµùÀ» ¾ò¾î¿Â´Ù.
int   getFieldCount()   Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ °³¼ö¸¦ ¸®ÅÏÇÑ´Ù.
string   getFieldName()   Á¤ÇØÁø À§Ä¡ÀÇ Çʵå À̸§À» ¾ò¾î¿Â´Ù.
string   getFieldType()   Á¤ÇØÁø À§Ä¡ÀÇ Çʵå ŸÀÔÀ» ¾ò¾î¿Â´Ù.
void   getInsertId()  
DBData   getPageData()   select Äõ¸®¿¡ ´ëÇØ¼­ ÆäÀÌ¡µÈ DBData¸¦ ¸®ÅÏÇÑ´Ù.
string   getTypeString()   Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿­ ¾ò¾î¿À±â
void   prepare()   ±¸Çö¾ÈµÊ
resource   query()   ÀÏ¹Ý Äõ¸® ½ÇÇà
bool   rollback()   rollback
void   runOption()   ±âº» ¼Ó¼º ÀÌ¿ÜÀÇ ´Ù¸¥¼Ó¼º ½ÇÇàÇÒ ¶§
bool   seek()   Ä¿¼­ À̵¿
void   selectDB()   DB ¼±ÅÃÇϱâ
void   setEncoding()   ¼­¹ö ÀÎÄÚµùÀ» ¼³Á¤ÇÑ´Ù.
void   spExecute()   ±¸Çö¾ÈµÊ
resource   _connect()   database ¿¬°á »ý¼º

[ Top ]
Methods
Constructor __construct  [line 19]

  Mysql __construct( [ $option = '']  )

»ý¼ºÀÚ

Parameters:
   $option: 

API Tags:
Access:  public


Redefinition of:
DBClient::__construct()

Redefined in descendants as:

[ Top ]
affectedRows  [line 62]

  int affectedRows( )

½ÇÇàµÈ row ¼ö


API Tags:
Access:  public


Redefinition of:
DBClient::affectedRows()
Äõ¸® ½ÇÇà¿¡ ¿µÇâÀ» ¹ÞÀº rowÀÇ ¼ö

Redefined in descendants as:

[ Top ]
begin  [line 72]

  bool begin( )

Æ®·£Àè¼Ç ½ÃÀÛ


API Tags:
See:  Mysql::commit(), Mysql::rollback();
Access:  public


Redefinition of:
DBClient::begin()
Æ®·£Àè¼Ç ½ÃÀÛ

[ Top ]
bind  [line 331]

  void bind( )

±¸Çö¾ÈµÊ


API Tags:
Access:  public

Information Tags:
Todo:  ¹Ì±¸Çö

Redefinition of:
DBClient::bind()
prepareµÈ ±¸¹®À» ¹ÙÀεù ÇÑ´Ù.

Redefined in descendants as:

[ Top ]
close  [line 79]

  void close( )

¿¬°á ´Ý±â


API Tags:
Access:  public


Redefinition of:
DBClient::close()
¿¬°á´Ý±â

Redefined in descendants as:

[ Top ]
commit  [line 92]

  bool commit( )

commit

mssqlÀº ÀÚµ¿À¸·Î commitÀ» Çϱ⠶§¹®¿¡ ÀÚµ¿commit À» ÇÏÁö ¾ÊÀ»·Á¸é ¹Ýµå½Ã begin() ¸Þ¼Òµå¸¦ ¸ÕÀú ½ÇÇàÇØ¾ßÇÑ´Ù.


API Tags:
See:  Mysql::begin(), Mysql::rollback();
Access:  public


Redefinition of:
DBClient::commit()
commit

[ Top ]
error  [line 102]

  string error( )

¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ


API Tags:
Return:  ¿¡·¯ ¸Þ¼¼Áö
Access:  public


Redefinition of:
DBClient::error()
¿¡·¯ ¸®ÅÏ

Redefined in descendants as:

[ Top ]
escape  [line 112]

  string escape( string $str  )

¹®ÀÚ¿­ escape

Parameters:
string   $str:  escape µÉ ¹®ÀÚ¿­

API Tags:
Return:  escape µÈ ¹®ÀÚ¿­
Access:  public


Redefinition of:
DBClient::escape()
°¢°¢ DBº° ¹®ÀÚ¿­ escape

Redefined in descendants as:

[ Top ]
execute  [line 340]

  void execute( )

±¸Çö¾ÈµÊ


API Tags:
Access:  public

Information Tags:
Todo:  ¹Ì±¸Çö

Redefinition of:
DBClient::execute()
prepareµÈ ±¸¹®À» ½ÇÇàÇÑ´Ù.

Redefined in descendants as:

[ Top ]
fetch  [line 124]

  array fetch( resource $result  )

½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼­ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.

¸®ÅϵǴ °ªÀº array('Çʵå' => '¤±¤±¤±', ...); ÇüŸ¦ °¡Áø´Ù.

Parameters:
resource   $result:  select °á°ú·Î ³ª¿Â resource

API Tags:
Return:  row µ¥ÀÌŸ
Access:  public


Redefinition of:
DBClient::fetch()
·¹ÄÚµå °¡Á®¿À±â

Redefined in descendants as:
  • Mysql_i::fetch() : ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼­ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.

[ Top ]
free  [line 133]

  bool free( $result  )

¸Þ¸ð¸® ÇØÁ¦

Parameters:
   $result: 

API Tags:
Access:  public


Redefinition of:
DBClient::free()
¸Þ¸ð¸® ÇØÁ¦

Redefined in descendants as:

[ Top ]
getClientEncoding  [line 142]

  string getClientEncoding( )

Ŭ¶óÀÌ¾ðÆ® ÀÎÄÚµùÀ» ¾ò¾î¿Â´Ù.


API Tags:
Return:  ÀÎÄÚµù°ª, ex) utf8, euckr, latin1, ...
Access:  public


[ Top ]
getFieldCount  [line 153]

  int getFieldCount( resource $result  )

Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ °³¼ö¸¦ ¸®ÅÏÇÑ´Ù.

Parameters:
resource   $result:  select °á°ú·Î ³ª¿Â resource

API Tags:
Return:  Çʵ尳¼ö
Access:  public


Redefinition of:
DBClient::getFieldCount()
ÇÊµå °³¼ö °¡Áö°í ¿À±â

Redefined in descendants as:

[ Top ]
getFieldName  [line 164]

  string getFieldName( resource $result, int $i  )

Á¤ÇØÁø À§Ä¡ÀÇ Çʵå À̸§À» ¾ò¾î¿Â´Ù.

Parameters:
resource   $result:  select °á°ú·Î ³ª¿Â resource
int   $i:  Çʵå À§Ä¡, óÀ½Àº 0

API Tags:
Return:  ÇʵåÀ̸§
Access:  public


Redefinition of:
DBClient::getFieldName()
Çʵå À̸§ °¡Áö°í ¿À±â

Redefined in descendants as:

[ Top ]
getFieldType  [line 175]

  string getFieldType( resource $result, int $i  )

Á¤ÇØÁø À§Ä¡ÀÇ Çʵå ŸÀÔÀ» ¾ò¾î¿Â´Ù.

Parameters:
resource   $result:  select °á°ú·Î ³ª¿Â resource
int   $i:  Çʵå À§Ä¡, óÀ½Àº 0

API Tags:
Return:  ÇʵåŸÀÔ
Access:  public


Redefinition of:
DBClient::getFieldType()
Çʵå ŸÀÔ °¡Áö°í ¿À±â

Redefined in descendants as:

[ Top ]
getInsertId  [line 179]

  void getInsertId( )



Redefined in descendants as:

[ Top ]
getPageData  [line 192]

  DBData getPageData( string $query, int $page, [int $count = 10], string $baseClass  )

select Äõ¸®¿¡ ´ëÇØ¼­ ÆäÀÌ¡µÈ DBData¸¦ ¸®ÅÏÇÑ´Ù.

Parameters:
string   $query:  select Äõ¸®
int   $page:  ÇöÀç ÆäÀÌÁö
int   $count:  ÆäÀÌÁö´ç ¸®½ºÆ® °³¼ö
string   $baseClass:  DBData ¸¦ »ó¼ÓÇÑ Å¬·¡½º , ±âº»°ª DBData


Redefinition of:
DBClient::getPageData()
paging µÈ DBData ¾ò¾î¿À±â

[ Top ]
getTypeString  [line 210]

  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


Redefinition of:
DBClient::getTypeString()
Çʵå ŸÀÔ(ÀÚ·áÇü)º° DB¿¡ ÀÔ·ÂµÉ ¼ö ÀÖ´Â ¹®ÀÚ¿­ ¾ò¾î¿À±â

[ Top ]
prepare  [line 322]

  void prepare( )

±¸Çö¾ÈµÊ


API Tags:
Access:  public

Information Tags:
Todo:  ¹Ì±¸Çö

Redefinition of:
DBClient::prepare()
prepare

Redefined in descendants as:

[ Top ]
query  [line 273]

  resource query( string $sql  )

ÀÏ¹Ý Äõ¸® ½ÇÇà

Parameters:
string   $sql:  ½ÇÇàµÉ query

API Tags:
Return:  ½ÇÇà resource
Access:  public


Redefinition of:
DBClient::query()
Äõ¸® ½ÇÇàÇϱâ

Redefined in descendants as:

[ Top ]
rollback  [line 285]

  bool rollback( )

rollback


API Tags:
Access:  public


Redefinition of:
DBClient::rollback()
rollback

[ Top ]
runOption  [line 43]

  void runOption( )

±âº» ¼Ó¼º ÀÌ¿ÜÀÇ ´Ù¸¥¼Ó¼º ½ÇÇàÇÒ ¶§


API Tags:
See:  runOption()
Access:  public


Redefinition of:
DBClient::runOption()
¿É¼Ç ½ÇÇà

[ Top ]
seek  [line 295]

  bool seek( int $count  )

Ä¿¼­ À̵¿

Parameters:
int   $count:  À̵¿½Ãų »ó´ëÀ§Ä¡, »çÁ÷ÇàÀº 0

API Tags:
Access:  public


Redefinition of:
DBClient::seek()
result set À̵¿

Redefined in descendants as:

[ Top ]
selectDB  [line 53]

  void selectDB( $db_name  )

DB ¼±ÅÃÇϱâ

Parameters:
   $db_name: 

API Tags:
Access:  public


Redefined in descendants as:

[ Top ]
setEncoding  [line 304]

  void setEncoding( [$encoding $encoding = "utf8"]  )

¼­¹ö ÀÎÄÚµùÀ» ¼³Á¤ÇÑ´Ù.

Parameters:
$encoding   $encoding:  string ÀÎÄÚµùŸÀÔ, ±âº»°ª utf8, ÇѱÛÀº euckr

API Tags:
Access:  public


[ Top ]
spExecute  [line 313]

  void spExecute( )

±¸Çö¾ÈµÊ


API Tags:
Access:  public

Information Tags:
Todo:  ¹Ì±¸Çö

Redefinition of:
DBClient::spExecute()
ÇÁ·Î½ÃÀú ½ÇÇà

Redefined in descendants as:

[ Top ]
_connect  [line 28]

  resource _connect( )

database ¿¬°á »ý¼º


API Tags:
Return:  ¿¬°á resource
Access:  protected


Redefinition of:
DBClient::_connect()
¿¬°á ¸®¼Ò½º ¸®ÅÏ

Redefined in descendants as:

[ Top ]

Documentation generated on Wed, 09 Dec 2009 10:48:37 +0900 by phpDocumentor 1.4.3