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_SQLRELAY

Source Location: /EDB/EDB/EDB_SQLRELAY.php

Class Overview

EDB_Common
   |
   --EDB_SQLRELAY

SQLRELAY 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]
SQLRELAY engine for EDB API

This class support abstracttion DB layer for SQLRELAY Engine




[ Top ]

Class Methods

constructor __construct [line 81]

EDB_SQLRELAY __construct( string $hostname, string $user, string $password, string $database)

Instantiates an EDB_SQLRELAY object and opens an SQLRELAY database

For examples:

  1.  $db = new EDB_SQLRELAY ('sqlrelay://localhost', 'user', 'host');
  2.  $db = new EDB_SQLRELAY ('sqlrelay://localhost:9000', 'user', 'host');
  3.  $db = new EDB_SQLRELAY ('sqlrelay://localhost:/path/sock', 'user', 'host');

If you add prefix 'p~' before host, you can connect with persistent connection.

For Examples:

  1.  $db = new EDB_SQLRELAY ('sqlrelay://p~localhost', 'user', 'host', 'database');




Tags:

access:  public


Parameters:

string   $hostname   SQLRELAY host
string   $user   SQLRELAY user
string   $password   SQLRELAY password
string   $database   SQLRELAY database

[ Top ]

destructor __destruct [line 543]

void __destruct( )



[ Top ]

method close [line 435]

void close( void 0)

Close the db handle



Tags:

access:  public


Parameters:

void   0  

[ Top ]

method escape [line 158]

string escape( string $string)

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

Attention! This method always returns original string.




Tags:

access:  public


Parameters:

string   $string   The string that is to be escaped.

[ Top ]

method fetch [line 260]

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

Fetch a result row as an associative object



Tags:

return:  The 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 284]

array fetch_all( [boolean $free = true])

Fetch all result rows as an associative object



Tags:

return:  The fetched object result rows
access:  public


Parameters:

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

[ Top ]

method field_name [line 343]

string|false field_name( integer $index)

Return the name of the specified field index



Tags:

access:  public


Parameters:

integer   $index   The numerical field offset. The field_offset starts at 0. If field_offset does not exist, return false and an error of level E_WARNING is also issued.

[ Top ]

method field_type [line 365]

string|false field_type( integer $index)

Get the type of the specified field in a result



Tags:

access:  public


Parameters:

integer   $index   The numerical field offset. The field_offset starts at 0. If field_offset does not exist, return false and an error of level E_WARNING is also issued.

[ Top ]

method free_result [line 307]

boolean free_result( void 0)

Frees stored result memory for the given statement handle



Tags:

access:  public


Parameters:

void   0  

[ Top ]

method get_charset [line 127]

string get_charset( )

Get character set of current database

SQLRELAY extension don't support this function




Tags:

return:  Current character set name on DB
access:  public


[ Top ]

method lastId [line 232]

int|false lastId( )

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



Tags:

since:  2.0.4
access:  public


[ Top ]

method num_fields [line 385]

integer|false num_fields( )

Return the number of columns in the result set



Tags:

return:  return -1 if SQL sentence is not SELECT.
access:  public


[ Top ]

method query [line 180]

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

Performs a query on the database



Tags:

return:  The number of affected rows or false
access:  public


Parameters:

string   $query   The query strings
string   $type   (optional) Bind parameter type. See also
  1.  i => integer
  2.  d => double
  3.  s => string
  4.  b => blob
mixed   $param1   (optional) Bind parameter 1
mixed   $param2,...   (optional) Bind parameter 2 ..

[ Top ]

method seek [line 245]

boolean seek( Number $offset)

Move the cursor in the result



Tags:

access:  public


Parameters:

Number   $offset   of units you want to move the cursor.

[ Top ]

method set_charset [line 143]

bool set_charset( string $char)

Set character set of current database

This method is always returned true because SQLRELAY don't support charset settings.




Tags:

return:  always return true
access:  public


Parameters:

string   $char   name of character set that supported from database

[ Top ]

method trend [line 417]

void trend( [bool $v = true])

DB transaction 을 종료한다.



Tags:

access:  public


Parameters:

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

[ Top ]

method trstart [line 404]

void trstart( )

DB transaction 을 시작한다.



Tags:

access:  public


[ Top ]

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