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

Class: Sqlite

Source Location: /php/db/Sqlite.php

Class Sqlite

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
Sqlite   __construct()   »ý¼ºÀÚ
int   affectedRows()   ½ÇÇàµÈ row ¼ö
void   close()   ¿¬°á ´Ý±â
string   error()   ¿¡·¯ ¸Þ¼¼Áö ¸®ÅÏ
string   escape()   ¹®ÀÚ¿­ escape
array   fetch()   ½ÇÇàµÈ select Äõ¸®¿¡ ´ëÇØ¼­ fetch ¸¦ ÅëÇØ ÇÑ Çà(row)À» ¸®ÅÏÇÑ´Ù.
void   fetchAll()  
bool   free()   ¸Þ¸ð¸® ÇØÁ¦
int   getFieldCount()   Äõ¸®ÀÇ °á°ú·Î ³ª¿Â ÇʵåÀÇ °³¼ö¸¦ ¸®ÅÏÇÑ´Ù.
string   getFieldName()   Á¤ÇØÁø À§Ä¡ÀÇ Çʵå À̸§À» ¾ò¾î¿Â´Ù.
string   getFieldType()   Á¤ÇØÁø À§Ä¡ÀÇ Çʵå ŸÀÔÀ» ¾ò¾î¿Â´Ù.
DBData   getPageData()   select Äõ¸®¿¡ ´ëÇØ¼­ ÆäÀÌ¡µÈ DBData¸¦ ¸®ÅÏÇÑ´Ù.
resource   query()   ÀÏ¹Ý Äõ¸® ½ÇÇà
bool   seek()   Ä¿¼­ À̵¿
void   spExecute()  
resource   _connect()   database ¿¬°á »ý¼º

[ Top ]
Methods
Constructor __construct  [line 21]

  Sqlite __construct( $option  )

»ý¼ºÀÚ

Parameters:
   $option: 

API Tags:
Access:  public


Redefinition of:
DBClient::__construct()

[ Top ]
affectedRows  [line 39]

  int affectedRows( )

½ÇÇàµÈ row ¼ö


API Tags:
Access:  public


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

[ Top ]
close  [line 46]

  void close( )

¿¬°á ´Ý±â


API Tags:
Access:  public


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

[ Top ]
error  [line 58]

  string error( )

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


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


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

[ Top ]
escape  [line 68]

  string escape( string $str  )

¹®ÀÚ¿­ escape

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

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


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

[ Top ]
fetch  [line 81]

  array fetch( resource $result, [ $result_type = SQLITE_ASSOC]  )

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

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

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

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


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

[ Top ]
fetchAll  [line 85]

  void fetchAll( $result, [ $result_type = SQLITE_ASSOC], [ $decode_binary = true]  )

Parameters:
   $result: 
   $result_type: 
   $decode_binary: 

API Tags:
Access:  public


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

[ Top ]
free  [line 94]

  bool free( $result  )

¸Þ¸ð¸® ÇØÁ¦

Parameters:
   $result: 

API Tags:
Access:  public


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

[ Top ]
getFieldCount  [line 104]

  int getFieldCount( resource $result  )

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

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

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


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

[ Top ]
getFieldName  [line 115]

  string getFieldName( resource $result, int $i  )

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

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

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


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

[ Top ]
getFieldType  [line 126]

  string getFieldType( resource $result, int $i  )

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

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

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


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

[ Top ]
getPageData  [line 139]

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

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

Parameters:
string   $query:  select Äõ¸®
int   $page:  ÇöÀç ÆäÀÌÁö
int   $count:  ÆäÀÌÁö´ç ¸®½ºÆ® °³¼ö


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

[ Top ]
query  [line 155]

  resource query( string $sql  )

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

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

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


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

[ Top ]
seek  [line 166]

  bool seek( int $count  )

Ä¿¼­ À̵¿

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

API Tags:
Access:  public


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

[ Top ]
spExecute  [line 170]

  void spExecute( )


API Tags:
Access:  public


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

[ Top ]
_connect  [line 30]

  resource _connect( )

database ¿¬°á »ý¼º


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


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

[ Top ]

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