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_MYSQL

Source Location: /EDB/EDB/EDB_MYSQL.php

Class Overview

EDB_Common
   |
   --EDB_MYSQL

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

This class support abstracttion DB layer for MySQLi Engine




[ Top ]

Class Methods

constructor __construct [line 71]

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

Instantiates an EDB_MYSQL object and opens an mysql database

For examples:

  1.  $db = new EDB_MYSQL ('mysql://localhost', 'user', 'host', 'database');
  2.  $db = new EDB_MYSQL ('mysql://localhost:3306', 'user', 'host', 'database');
  3.  $db = new EDB_MYSQL ('mysql://localhost:/var/run/mysqld/mysql.sock', 'user', 'host', 'database');

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

For Examples:

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




Tags:

access:  public


Parameters:

string   $hostname   mysql host
string   $user   mysql user
string   $password   mysql password
string   $database   mysql database

[ Top ]

destructor __destruct [line 501]

void __destruct( )



[ Top ]

method close [line 420]

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



Tags:

access:  public


Parameters:

string   $string   The string that is to be escaped.

[ Top ]

method fetch [line 252]

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 277]

array fetch_all( [boolean $true = true])

Fetch all result rows as an associative object



Tags:

return:  The fetched result rows
access:  public


Parameters:

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

[ Top ]

method field_name [line 325]

string|false field_name( integer $index)

Get the name of the specified field in a result



Tags:

see:  http://php.net/manual/en/function.mysql-field-name.php mysql_field_name()
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 349]

string|false field_type( integer $index)

Get the type of the specified field in a result



Tags:

see:  http://php.net/manual/en/function.mysql-field-type.php mysql_field_type()
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 298]

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 115]

string get_charset( )

Get character set of current database

MySQL extension don't support this function




Tags:

return:  Current character set name on DB
access:  public


[ Top ]

method lastId [line 217]

integer|false lastId( )

마지막 실행한 쿼리에서 자동으로 생성된 ID(auto increment)값을 반환



Tags:

since:  2.0.4
access:  public


[ Top ]

method num_fields [line 370]

integer|false num_fields( )

Get number of fields in result



Tags:

see:  http://php.net/manual/en/function.mysql-num-fields.php mysql_num_fields()
access:  public


[ Top ]

method query [line 181]

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 mysqli_stmt::bind_param.
  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 230]

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 133]

bool set_charset( string $char)

Set character set of current database



Tags:

return:  The name of character set that is supported on database
access:  public


Parameters:

string   $char   name of character set that supported from database

[ Top ]

method trend [line 404]

void trend( [bool $v = true])

DB transaction 을 종료한다.



Tags:

access:  public


Parameters:

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

[ Top ]

method trstart [line 391]

void trstart( )

DB transaction 을 시작한다.



Tags:

access:  public


[ Top ]

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