Inherited From atkOci8Db

atkOci8Db::$m_vendor

Inherited From atkDb

atkDb::$m_affected_rows

atkDb::$m_auto_free

atkDb::$m_charset

atkDb::$m_collate

atkDb::$m_connection

atkDb::$m_database

atkDb::$m_errno

atkDb::$m_error

atkDb::$m_errorLookup

atkDb::$m_haltonerror

atkDb::$m_host

atkDb::$m_identifierQuoting

atkDb::$m_link_id

atkDb::$m_mode

atkDb::$m_password

atkDb::$m_port

atkDb::$m_query_id

atkDb::$m_record

atkDb::$m_row

atkDb::$m_tableMeta

atkDb::$m_user

atkDb::$m_user_error

Inherited From atkOci8Db

atkOci8Db::atkOci8Db()

Default constructor

atkOci8Db::affected_rows()

Retrieve the number of rows affected by the last query.

atkOci8Db::commit()

Commit the current transaction.

atkOci8Db::connect()

Connect to the database.

atkOci8Db::disconnect()

Disconnect from database.

atkOci8Db::escapeSQL()

Escape a string for use in SQL queries.

atkOci8Db::func_concat()

Retrieve this drivers' specific SQL implementation of a concat() function.

atkOci8Db::func_now()

Retrieve this drivers' specific SQL implementation of a now() function.

atkOci8Db::func_substring()

Retrieve this drivers' specific SQL implementation of a substring function.

atkOci8Db::getAtkDbErrno()

Get last error code.

atkOci8Db::lock()

Lock a table in the database.

atkOci8Db::maxIdentifierLength()

Returns the maximum length an identifier (tablename, columnname, etc) for this driver may have.

atkOci8Db::metadata()

Return the meta data of a certain table

atkOci8Db::nextid()

Get the next sequence number of a certain sequence.

atkOci8Db::next_record()

Retrieve the next record in the resultset.

atkOci8Db::num_fields()

Evaluatie the result; how many fields where affected by the query.

atkOci8Db::num_rows()

Retrieve the number of rows in the resultset.

atkOci8Db::query()

Parse and execute a query.

atkOci8Db::rollback()

Rollback the the current transaction.

atkOci8Db::savepoint()

Set savepoint with the given name.

atkOci8Db::seek()

Skip to a certain position in the result set for subsequent calls to next_record().

atkOci8Db::setSequenceValue()

Set sequence value.

atkOci8Db::tableExists()

This function checks in the database if a table exists.

atkOci8Db::table_names()

Return a list of all table names in the current connection.

atkOci8Db::toggleForeignKeys()

Enable/disable all foreign key constraints.

atkOci8Db::unlock()

Relieve all locks.

atkOci8Db::_translateError()

Translate a driver specific error to a generic ATK db error code.

Inherited From atkDb

atkDb::affected_rows()

Retrieve the number of rows affected by the last query.

atkDb::clearMapping()

Clear the current database mapping.

atkDb::cloneAll()

Clones the database structure of the given database to this database. This also means the complete database is emptied beforehand.

atkDb::commit()

Commit the current transaction.

atkDb::connect()

Connect to the database.

atkDb::createDDL()

Create an atkDDL object for constructing ddl queries.

atkDb::createQuery()

Create an atkQuery object for constructing queries.

atkDb::deleteAll()

Empty all database tables.

atkDb::disconnect()

Disconnect from database

atkDb::doConnect()

Connect to the database

atkDb::dropAll()

Drop all database tables.

atkDb::errorLookup()

Looks up the error

atkDb::escapeSQL()

escapes quotes for use in SQL: ' -> '' (and sometimes % -> %%)

atkDb::func_concat()

Get CONCAT() equivalent for the current database.

atkDb::func_concat_ws()

Get CONCAT_WS() equivalent for the current database.

atkDb::func_datetimetochar()

Get TO_CHAR() equivalent for the current database.

atkDb::func_datetochar()

Get TO_CHAR() equivalent for the current database.

atkDb::func_now()

get NOW() or SYSDATE() equivalent for the current database

atkDb::func_substring()

get SUBSTRING() equivalent for the current database.

atkDb::getAtkDbErrno()

Get generic atk errorccode

atkDb::getDbErrno()

Get vendor-dependent database error number.

atkDb::getDbError()

Get vendor-dependent database error message.

atkDb::getDbStatus()

Check if current db is present and acceptable for current user

atkDb::getErrorMsg()

Get localized error message (for display in the application)

atkDb::getErrorType()

Determine whether an error that occurred is a recoverable (user) error or a system error.

atkDb::getInstance()

Get database instance.

atkDb::getMapping()

Returns the current database mapping.

atkDb::getQueryMode()

Returns the query mode

atkDb::getrows()

Get all rows that are the result of a certain specified query

atkDb::getSearchModes()

This function indicates what searchmodes the database supports.

atkDb::getTranslatedDatabaseName()

Returns the real database name. If a mapping

atkDb::getType()

Get the database driver type.

atkDb::getValue()

Get a single value (first row, first column) from a certain specified query

atkDb::getValues()

Get an array with all the values in the (first) column.

atkDb::halt()

If haltonerror is set, this will raise an atkerror. If not, it will place the error in atkdebug and continue.

atkDb::hasError()

Has error?

atkDb::hasMode()

Check if the current instance has the given mode

atkDb::init()

(Re)Initialise a database driver with a connection

atkDb::link_id()

Get the current connection.

atkDb::lock()

Lock a table in the database.

atkDb::maxIdentifierLength()

Returns the maximum length an identifier (tablename, columnname, etc) may have

atkDb::metadata()

Return the meta data of a certain table HIE GEBLEVEN

atkDb::nextid()

Get the next sequence number of a certain sequence.

atkDb::next_record()

Retrieve the next record in the resultset.

atkDb::query()

Parse and execute a query.

atkDb::query_id()

Get the current query statement resource id.

atkDb::quoteIdentifier()

Quote Indentifier

atkDb::rollback()

Rollback the current transaction.

atkDb::savepoint()

Set savepoint with the given name.

atkDb::setHaltOnError()

Halt on error or not?

atkDb::setInstance()

Replace the current instance of a named connection at runtime with a different connection. This is useful for example for replacing a named database instance with a mock object for testing purposes.

atkDb::setSequenceValue()

Set database sequence value.

atkDb::setUserError()

Define custom user error codes.

atkDb::tableExists()

This function checks the database for a table with the provide name

atkDb::tableMeta()

Fetches table meta data from database

atkDb::table_names()

Return the available table names

atkDb::toggleForeignKeys()

Enable/disable all foreign key constraints.

atkDb::unlock()

Relieve all locks.

atkDb::useMapping()

Use the given mapping to translate database requests from one database to another database. This can be used for test purposes.

atkDb::vendorDateFormat()

Convert a php date() format specifier to a vendor specific format specifier.

atkDb::_getOrUseMapping()

Get or set the database mapping

atkDb::_getTableMetaFromCache()

If cached it'll return the table metadata from cache.

atkDb::_getTableMetaFromDb()

Returns the tablemetadata directly from db

atkDb::_translateError()

Translate database-vendor dependent error messages into an ATK generic error code.