Docs For Class PdoConnector

PdoConnector

Description

Implements interfaces:

IConnector

IConnector implementation for the PHP Data Objects.

BaseConnector
   |
   --PdoConnector

Method Summary

PdoConnector PdoConnector (array $connection, [array $options = array()])

void bindStatement (PDOStatement $stmt, array $stack, [array $options = array()])

string build (string $query, [array $options = array()])

bool commit ([array $options = array()])

int delete (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

array fetch (resource $stmt, [array $options = array()])

int insert (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

bool open (array $connection)

bool rollback ([array $options = array()])

array select (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

bool transaction ([array $options = array()])

int update (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

Variables

Inherited Variables

Inherited from BaseConnector

BaseConnector::$cache
BaseConnector::$conn
BaseConnector::$options

Methods

Constructor PdoConnector (line 54)

Open a PDO connection and set global options.

access: public

PdoConnector PdoConnector (array $connection, [array $options = array()])

array $connection: An associated array of connection settings, like host and user name.
array $options: An associated array of global options for the resulting instance.

bindStatement (line 498)

Bind values to a prepared statement using named or numeric parameters.

access: protected

void bindStatement (PDOStatement $stmt, array $stack, [array $options = array()])

PDOStatement $stmt: The prepared statement.
array $stack: A numeric or associated array of parameter values.
array $options: An associated array of options.

build (line 462)

Add a TOP x statement to a SQL SELECT query when the IConnector::RESULT_LENGTH is set.

return: A modified SQL query.
access: protected

string build (string $query, [array $options = array()])

string $query: A SQL query to execute on a database.
array $options: An associated array of options.

commit (line 402)

Commits the current transaction on the current connection.

The current transaction includes all statements on the connection that were executed after the call to transaction() and before any calls to rollback() or commit().

return: true if the transaction was successfully committed, false otherwise.
see: IConnector::commit().
access: public

bool commit ([array $options = array()])

array $options: An associated array of options, see the Option elements.

Redefinition of:

BaseConnector::commit(): Commits the current transaction on the current connection.

Implementation of:

IConnector::commit(): Commits the current transaction on the current connection.

delete (line 323)

Send a SQL DELETE query to the database and get the number of rows deleted by the query.

return: The number of rows deleted by the query.
see: IConnector::delete().
throws: Exception when $param doesn't match the type definition $map.
access: public

int delete (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

string $query: A SQL query to execute on a database.
array $param: An associated array of values to be used in the $query.
array $map: An array of type definitions for the $param values.
array $options: An associated array of options, see the Option elements.

Implementation of:

IConnector::delete(): Send a SQL DELETE query to the database and get the number of rows deleted by the query.

fetch (line 532)

Fetch multiple rows of a query result.

If the IConnector::RESULT_LENGTH or IConnector::RESULT_OFFSET options are set, some rows are omitted from the beginning and/or the end of the query result. If the IConnector::RESULT_KEY_FIELD option is set, the resulting table is an associated array of rows.

return: The query result as a table (array of associated arrays).
access: protected

array fetch (resource $stmt, [array $options = array()])

resource $stmt: A statement resource corresponding to an executed statement.
array $options: An associated array of options.

insert (line 203)

Send a SQL INSERT query to the database and get the IDENTITY ID generated from the last INSERT operation (if any).

return: The IDENTITY ID of the last inserted row.
see: IConnector::insert().
throws: Exception when $param doesn't match the type definition $map.
access: public

int insert (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

string $query: A SQL query to execute on a database.
array $param: An associated array of values to be used in the $query.
array $map: An array of type definitions for the $param values.
array $options: An associated array of options, see the Option elements.

Implementation of:

IConnector::insert(): Send a SQL INSERT query to the database and get the IDENTITY ID generated from the last INSERT operation (if any).

open (line 92)

Open a database connection.

return: true, if a database connection was successfully opened, false otherwise.
access: protected

bool open (array $connection)

array $connection: An associated array of connection settings, like host and user name.

rollback (line 433)

Rolls back the current transaction on the current connection.

The current transaction includes all statements on the connection that were executed after the call to transaction() and before any calls to rollback() or commit().

return: true if the transaction was successfully rolled back, false otherwise.
see: IConnector::rollback().
access: public

bool rollback ([array $options = array()])

array $options: An associated array of options, see the Option elements.

Redefinition of:

BaseConnector::rollback(): Rolls back the current transaction on the current connection.

Implementation of:

IConnector::rollback(): Rolls back the current transaction on the current connection.

select (line 141)

Send a SQL SELECT query to the database and get the query result.

return: The query result as a table (array of associated arrays).
see: IConnector::select().
throws: Exception when $param doesn't match the type definition $map.
access: public

array select (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

string $query: A SQL query to execute on a database.
array $param: An associated array of values to be used in the $query.
array $map: An array of type definitions for the $param values.
array $options: An associated array of options, see the Option elements.

Implementation of:

IConnector::select(): Send a SQL SELECT query to the database and get the query result.

transaction (line 371)

Begins a transaction on the current connection.

The current transaction includes all statements on the connection that were executed after the call to transaction() and before any calls to rollback() or commit().

return: true if the transaction was successfully begun, false otherwise.
see: IConnector::transaction().
access: public

bool transaction ([array $options = array()])

array $options: An associated array of options, see the Option elements.

Redefinition of:

BaseConnector::transaction(): Begins a transaction on the current connection.

Implementation of:

IConnector::transaction(): Begins a transaction on the current connection.

update (line 273)

Send a SQL UPDATE query to the database and get the number of rows updates by the query.

return: The number of rows updates by the query.
see: IConnector::update().
throws: Exception when $param doesn't match the type definition $map.
access: public

int update (string $query, [array $param = array()], [array $map = array()], [array $options = array()])

string $query: A SQL query to execute on a database.
array $param: An associated array of values to be used in the $query.
array $map: An array of type definitions for the $param values.
array $options: An associated array of options, see the Option elements.

Implementation of:

IConnector::update(): Send a SQL UPDATE query to the database and get the number of rows updates by the query.

Inherited Methods

Inherited From BaseConnector

BaseConnector::BaseConnector()
BaseConnector::bind()
BaseConnector::cast()
BaseConnector::castArray()
BaseConnector::castBool()
BaseConnector::castDate()
BaseConnector::castFloat()
BaseConnector::castInt()
BaseConnector::castNull()
BaseConnector::castNumeric()
BaseConnector::castObject()
BaseConnector::castString()
BaseConnector::commit()
BaseConnector::getCache()
BaseConnector::getHash()
BaseConnector::getLink()
BaseConnector::getOptions()
BaseConnector::lookup()
BaseConnector::push()
BaseConnector::rollback()
BaseConnector::setCache()
BaseConnector::setOptions()
BaseConnector::strDecode()
BaseConnector::strEncode()
BaseConnector::strEscape()
BaseConnector::strQuote()
BaseConnector::strStrip()
BaseConnector::transaction()

Documentation generated on Wed, 03 Jun 2009 12:41:55 +0200 by phpDocumentor 1.4.1