EDB
[ class tree: EDB ] [ index: EDB ] [ all elements ]
Packages:
ActiveDirectory
EDB
eFilesystem
eSystem
HTTPRelay
IPCALC
KSC5601
MTA
myException
mysqlAES
NAVER
oGetopt
oops-KASI-Lunar
oops-Lunar
oops-OAUTH2
sThread
WebAPI
WHOIS


Files:
edb.php

subpackage EDB_ABSTRACT
EDB_CUBRID.php
EDB_MSSQL.php
EDB_MYSQL.php
EDB_MYSQLI.php
EDB_PGSQL.php
EDB_SQLITE2.php
EDB_SQLITE3.php
EDB_SQLRELAY.php

subpackage EDB_Common
EDB_Common.php

Classes:
EDB_Common
   EDB
   EDB_Common
   EDB_CUBRID
   EDB_MSSQL
   EDB_MYSQL
   EDB_MYSQLI
   EDB_PGSQL
   EDB_SQLITE2
   EDB_SQLITE3
   EDB_SQLRELAY

Class: EDB_SQLITE3

Source Location: /EDB/EDB/EDB_SQLITE3.php

Class Overview

EDB_Common
   |
   --EDB_SQLITE3

SQLite3 engine for EDB API

Methods

Inherited Variables

Class: EDB_Common

EDB_Common::$free
EDB_Common::$queryLog
EDB_Common::$result

Inherited Methods

Class: EDB_Common

EDB_Common::bind_param()
replace bind parameters to parameter's value
EDB_Common::check_param()
Check parameter type and parameters
EDB_Common::file_exists()
Checks whether a file or directory exists
EDB_Common::get_param_number()
Get number of query parameters
EDB_Common::switch_freemark()
Change free marking

Class Details

[line 27]
SQLite3 engine for EDB API

This class support abstracttion DB layer for SQLite3 Engine




[ Top ]

Class Methods

constructor __construct [line 76]

EDB_SQLITE3 __construct( string $path, int $flags)

Instantiates an EDB_SQLITE3 object and opens an SQLite 3 database

For examples:

  1.  $db = new EDB_SQLITE3 ('sqlite3:///path/file.db');
  2.  $db = new EDB_SQLITE3 ('sqlite3:///path/file.db', SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);
  3.  $db = new EDB_SQLITE3 ('sqlite3://:memory:', SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);




Tags:

access:  public


Parameters:

string   $path   sqlite3 database file
int   $flags   (optinal) open flags of sqlite3. See also SQLite3::__construct.

[ Top ]

destructor __destruct [line 585]

void __destruct( )



[ Top ]

method close [line 436]

void close( )

Close the db handle



Tags:

access:  public


[ Top ]

method escape [line 143]

string escape( string $string)

Escape special characters in a string for use in an SQL statement



Tags:

access:  public


Parameters:

string   $string   The string that is to be escaped.

[ Top ]

method fetch [line 260]

object The fetch( [boolean $free = false])

Fetch a result row as an associative object



Tags:

return:  object of fetched a result row or false
access:  public


Parameters:

boolean   $free   (optional) fetch 수행 후 result를 free한다. (기본값: false) EDB >= 2.0.3

[ Top ]

method fetch_all [line 282]

array fetch_all( [boolean $free = true])

Fetch all result rows as an associative object



Tags:

return:  The fetched result rows
access:  public


Parameters:

boolean   $free   (optional) free result set after fetch. Defaluts is true.

[ Top ]

method field_name [line 333]

string|false field_name( integer $index)

Returns the name of the column specified by the column_number.



Tags:

access:  public


Parameters:

integer   $index   The numeric zero-based index of the column.

[ Top ]

method field_type [line 353]

string|false field_type( integer $index)

Get the type of the specified field in a result



Tags:

access:  public


Parameters:

integer   $index   The numeric zero-based index of the column.

[ Top ]

method free_result [line 308]

boolean free_result( )

Frees stored result memory for the given statement handle



Tags:

return:  always returns true
access:  public


[ Top ]

method get_charset [line 112]

string get_charset( )

Get character set of current database

This method is not allow on SQLite3 Engine




Tags:

return:  Current character set name
access:  public


[ Top ]

method lastId [line 209]

int|false lastId( )

가장 마지막 입력 row ID를 반환한다.



Tags:

since:  2.0.4
access:  public


[ Top ]

method num_fields [line 390]

integer|false num_fields( )

Get number of fields in result



Tags:

access:  public


[ Top ]

method query [line 170]

integer query( string $query, string $type, mixed $param1, mixed $param2,...)

Performs a query on the database

Executes an SQL query, returning number of affected rows




Tags:

return:  The number of affected rows or false. If is not delete/insert/update query, always returns 0.
access:  public


Parameters:

string   $query   The query strings
string   $type   (optional) Bind parameter type. See also SQLite3Stmt::bindparam().
  1.  i => integer SQLITE3_INTEGER
  2.  d => double  SQLITE3_FLOAT
  3.  s => string  SQLITE3_TEXT
  4.  b => blob    SQLITE3_BLOB
  5.  n => null    SQLITE3_NULL
mixed   $param1   (optional) Bind parameter 1
mixed   $param2,...   (optional) Bind parameter 2 ..

[ Top ]

method seek [line 222]

boolean seek( integer $offset)

Adjusts the result pointer to an arbitrary row in the result



Tags:

access:  public


Parameters:

integer   $offset   Must be between zero and the total number of rows minus one

[ Top ]

method set_charset [line 129]

bool set_charset( string $char)

Set character set of current database

This method is not allow on SQLite3 Engine, and always returns true.




Tags:

return:  always retuns true
access:  public


Parameters:

string   $char   name of character set that supported from database

[ Top ]

method trend [line 423]

void trend( [bool $v = true])

DB transaction 을 종료한다.



Tags:

access:  public


Parameters:

bool   $v   false일경우 rollback을 수행한다.

[ Top ]

method trstart [line 410]

void trstart( )

DB transaction 을 시작한다.



Tags:

access:  public


[ Top ]

Documentation generated on Fri, 30 Aug 2024 06:10:20 +0900 by phpDocumentor 1.4.4