Index | Dibi API

A

$ Connection#affectedRows — Property in class Connection
Connection::affectedRows() — Method in class Connection
DataSource::applyLimit() — Method in class DataSource: Limits number of rows.
DateTime::add() — Method in class DateTime
Driver::applyLimit() — Method in class Driver: Injects LIMIT/OFFSET to the SQL query.
FirebirdDriver::applyLimit() — Method in class FirebirdDriver: Injects LIMIT/OFFSET to the SQL query.
MySqliDriver::applyLimit() — Method in class MySqliDriver: Injects LIMIT/OFFSET to the SQL query.
OdbcDriver::applyLimit() — Method in class OdbcDriver: Injects LIMIT/OFFSET to the SQL query.
OracleDriver::applyLimit() — Method in class OracleDriver: Injects LIMIT/OFFSET to the SQL query.
PdoDriver::applyLimit() — Method in class PdoDriver: Injects LIMIT/OFFSET to the SQL query.
PostgreDriver::applyLimit() — Method in class PostgreDriver: Injects LIMIT/OFFSET to the SQL query.
SqliteDriver::applyLimit() — Method in class SqliteDriver: Injects LIMIT/OFFSET to the SQL query.
SqlsrvDriver::applyLimit() — Method in class SqlsrvDriver: Injects LIMIT/OFFSET to the SQL query.
Fluent::as() — Method in class Fluent
Fluent::and() — Method in class Fluent
Fluent::asc() — Method in class Fluent
Helpers::alias() — Method in class Helpers: Apply configuration alias or default values.
$ Column#autoIncrement — Property in class Column
Row::asDateTime() — Method in class Row: Converts value to DateTime object.
dibi::affectedRows() — Method in class dibi

B

Connection::begin() — Method in class Connection: Begins a transaction (if supported).
Driver::begin() — Method in class Driver: Begins a transaction (if supported).
FirebirdDriver::begin() — Method in class FirebirdDriver: Begins a transaction (if supported).
MySqliDriver::begin() — Method in class MySqliDriver: Begins a transaction (if supported).
OdbcDriver::begin() — Method in class OdbcDriver: Begins a transaction (if supported).
OracleDriver::begin() — Method in class OracleDriver: Begins a transaction (if supported).
PdoDriver::begin() — Method in class PdoDriver: Begins a transaction (if supported).
PostgreDriver::begin() — Method in class PostgreDriver: Begins a transaction (if supported).
SqliteDriver::begin() — Method in class SqliteDriver: Begins a transaction (if supported).
SqlsrvDriver::begin() — Method in class SqlsrvDriver: Begins a transaction (if supported).
IConnection::begin() — Method in class IConnection: Begins a transaction (if supported).
dibi::begin() — Method in class dibi

C

Connection — Class in namespace Dibi: Dibi connection.
Connection::connect() — Method in class Connection: Connects to a database.
Connection::commit() — Method in class Connection: Commits statements in a transaction.
Connection::createResultSet() — Method in class Connection: Result set factory.
Connection::command() — Method in class Connection
ConstraintViolationException — Class in namespace Dibi: Base class for all constraint violation related exceptions.
DataSource::count() — Method in class DataSource: Returns the number of rows in a given data source.
Driver::commit() — Method in class Driver: Commits statements in a transaction.
FirebirdDriver::commit() — Method in class FirebirdDriver: Commits statements in a transaction.
FirebirdDriver::createResultDriver() — Method in class FirebirdDriver: Result set driver factory.
MySqliDriver::createException() — Method in class MySqliDriver
MySqliDriver::commit() — Method in class MySqliDriver: Commits statements in a transaction.
MySqliDriver::createResultDriver() — Method in class MySqliDriver: Result set driver factory.
OdbcDriver::commit() — Method in class OdbcDriver: Commits statements in a transaction.
OdbcDriver::createResultDriver() — Method in class OdbcDriver: Result set driver factory.
OracleDriver::createException() — Method in class OracleDriver
OracleDriver::commit() — Method in class OracleDriver: Commits statements in a transaction.
OracleDriver::createResultDriver() — Method in class OracleDriver: Result set driver factory.
PdoDriver::commit() — Method in class PdoDriver: Commits statements in a transaction.
PdoDriver::createResultDriver() — Method in class PdoDriver: Result set driver factory.
PostgreDriver::createException() — Method in class PostgreDriver
PostgreDriver::commit() — Method in class PostgreDriver: Commits statements in a transaction.
PostgreDriver::createResultDriver() — Method in class PostgreDriver: Result set driver factory.
SqliteDriver::createException() — Method in class SqliteDriver
SqliteDriver::commit() — Method in class SqliteDriver: Commits statements in a transaction.
SqliteDriver::createResultDriver() — Method in class SqliteDriver: Result set driver factory.
SqlsrvDriver::commit() — Method in class SqlsrvDriver: Commits statements in a transaction.
SqlsrvDriver::createResultDriver() — Method in class SqlsrvDriver: Result set driver factory.
$ Event#connection — Property in class Event
$ Event#count — Property in class Event
$ Fluent#clauseSwitches — Property in class Fluent
Fluent::clause() — Method in class Fluent: Switch to a clause.
Fluent::count() — Method in class Fluent
IConnection::connect() — Method in class IConnection: Connects to a database.
IConnection::commit() — Method in class IConnection: Commits statements in a transaction.
Column — Class in namespace Dibi\Reflection: Reflection metadata class for a table or result set column.
$ Index#columns — Property in class Index
$ Result#columns — Property in class Result
$ Result#columnNames — Property in class Result
$ Table#columns — Property in class Table
$ Table#columnNames — Property in class Table
Result::count() — Method in class Result: Required by the Countable interface.
ResultIterator::current() — Method in class ResultIterator: Returns the current element.
ResultIterator::count() — Method in class ResultIterator: Required by the Countable interface.
Row::count() — Method in class Row
dibi::connect() — Method in class dibi: Creates a new Connection object and connects it to specified database.
dibi::commit() — Method in class dibi
dibi::command() — Method in class dibi

D

DibiExtension22 — Class in namespace Dibi\Bridges\Nette: Dibi extension for Nette Framework 2.2. Creates 'connection' & 'panel' services.
Connection::disconnect() — Method in class Connection: Disconnects from a database.
Connection::dataSource() — Method in class Connection: Generates (translates) and returns SQL query as DataSource.
Connection::delete() — Method in class Connection
DataSource — Class in namespace Dibi: Default implementation of IDataSource.
DateTime — Class in namespace Dibi: DateTime.
Driver — Class in namespace Dibi: Driver interface.
Driver::disconnect() — Method in class Driver: Disconnects from a database.
DriverException — Class in namespace Dibi: database server exception.
FirebirdDriver::disconnect() — Method in class FirebirdDriver: Disconnects from a database.
MySqliDriver::disconnect() — Method in class MySqliDriver: Disconnects from a database.
OdbcDriver::disconnect() — Method in class OdbcDriver: Disconnects from a database.
OracleDriver::disconnect() — Method in class OracleDriver: Disconnects from a database.
PdoDriver::disconnect() — Method in class PdoDriver: Disconnects from a database.
PostgreDriver::disconnect() — Method in class PostgreDriver: Disconnects from a database.
SqliteDriver::disconnect() — Method in class SqliteDriver: Disconnects from a database.
SqlsrvDriver::disconnect() — Method in class SqlsrvDriver: Disconnects from a database.
Event::done() — Method in class Event
Fluent::distinct() — Method in class Fluent
Fluent::desc() — Method in class Fluent
Helpers::dump() — Method in class Helpers: Prints out a syntax highlighted version of the SQL command or Result.
Helpers::detectType() — Method in class Helpers: Heuristic type detection.
IConnection::disconnect() — Method in class IConnection: Disconnects from a database.
$ Column#default — Property in class Column
Database — Class in namespace Dibi\Reflection: Reflection metadata class for a database.
Result::dump() — Method in class Result: Displays complete result set as HTML or text table for debug purposes.
Translator::delimite() — Method in class Translator: Apply substitutions to identifier and delimites it.
dibi — Class in namespace [Global Namespace]: Static container class for Dibi connections.
dibi::dump() — Method in class dibi: Prints out a syntax highlighted version of the SQL command or Result.
dibi::disconnect() — Method in class dibi
dibi::dataSource() — Method in class dibi
dibi::delete() — Method in class dibi

E

$ Panel#explain — Property in class Panel
Connection::expression() — Method in class Connection
Driver::escapeText() — Method in class Driver: Encodes data for use in a SQL statement.
Driver::escapeBinary() — Method in class Driver
Driver::escapeIdentifier() — Method in class Driver
Driver::escapeBool() — Method in class Driver
Driver::escapeDate() — Method in class Driver
Driver::escapeDateTime() — Method in class Driver
Driver::escapeLike() — Method in class Driver: Encodes string for use in a LIKE statement.
FirebirdDriver::escapeText() — Method in class FirebirdDriver: Encodes data for use in a SQL statement.
FirebirdDriver::escapeBinary() — Method in class FirebirdDriver
FirebirdDriver::escapeIdentifier() — Method in class FirebirdDriver
FirebirdDriver::escapeBool() — Method in class FirebirdDriver
FirebirdDriver::escapeDate() — Method in class FirebirdDriver
FirebirdDriver::escapeDateTime() — Method in class FirebirdDriver
FirebirdDriver::escapeLike() — Method in class FirebirdDriver: Encodes string for use in a LIKE statement.
MySqliDriver::escapeText() — Method in class MySqliDriver: Encodes data for use in a SQL statement.
MySqliDriver::escapeBinary() — Method in class MySqliDriver
MySqliDriver::escapeIdentifier() — Method in class MySqliDriver
MySqliDriver::escapeBool() — Method in class MySqliDriver
MySqliDriver::escapeDate() — Method in class MySqliDriver
MySqliDriver::escapeDateTime() — Method in class MySqliDriver
MySqliDriver::escapeLike() — Method in class MySqliDriver: Encodes string for use in a LIKE statement.
OdbcDriver::escapeText() — Method in class OdbcDriver: Encodes data for use in a SQL statement.
OdbcDriver::escapeBinary() — Method in class OdbcDriver
OdbcDriver::escapeIdentifier() — Method in class OdbcDriver
OdbcDriver::escapeBool() — Method in class OdbcDriver
OdbcDriver::escapeDate() — Method in class OdbcDriver
OdbcDriver::escapeDateTime() — Method in class OdbcDriver
OdbcDriver::escapeLike() — Method in class OdbcDriver: Encodes string for use in a LIKE statement.
OracleDriver::escapeText() — Method in class OracleDriver: Encodes data for use in a SQL statement.
OracleDriver::escapeBinary() — Method in class OracleDriver
OracleDriver::escapeIdentifier() — Method in class OracleDriver
OracleDriver::escapeBool() — Method in class OracleDriver
OracleDriver::escapeDate() — Method in class OracleDriver
OracleDriver::escapeDateTime() — Method in class OracleDriver
OracleDriver::escapeLike() — Method in class OracleDriver: Encodes string for use in a LIKE statement.
PdoDriver::escapeText() — Method in class PdoDriver: Encodes data for use in a SQL statement.
PdoDriver::escapeBinary() — Method in class PdoDriver
PdoDriver::escapeIdentifier() — Method in class PdoDriver
PdoDriver::escapeBool() — Method in class PdoDriver
PdoDriver::escapeDate() — Method in class PdoDriver
PdoDriver::escapeDateTime() — Method in class PdoDriver
PdoDriver::escapeLike() — Method in class PdoDriver: Encodes string for use in a LIKE statement.
PostgreDriver::escapeText() — Method in class PostgreDriver: Encodes data for use in a SQL statement.
PostgreDriver::escapeBinary() — Method in class PostgreDriver
PostgreDriver::escapeIdentifier() — Method in class PostgreDriver
PostgreDriver::escapeBool() — Method in class PostgreDriver
PostgreDriver::escapeDate() — Method in class PostgreDriver
PostgreDriver::escapeDateTime() — Method in class PostgreDriver
PostgreDriver::escapeLike() — Method in class PostgreDriver: Encodes string for use in a LIKE statement.
SqliteDriver::escapeText() — Method in class SqliteDriver: Encodes data for use in a SQL statement.
SqliteDriver::escapeBinary() — Method in class SqliteDriver
SqliteDriver::escapeIdentifier() — Method in class SqliteDriver
SqliteDriver::escapeBool() — Method in class SqliteDriver
SqliteDriver::escapeDate() — Method in class SqliteDriver
SqliteDriver::escapeDateTime() — Method in class SqliteDriver
SqliteDriver::escapeLike() — Method in class SqliteDriver: Encodes string for use in a LIKE statement.
SqlsrvDriver::escapeText() — Method in class SqlsrvDriver: Encodes data for use in a SQL statement.
SqlsrvDriver::escapeBinary() — Method in class SqlsrvDriver
SqlsrvDriver::escapeIdentifier() — Method in class SqlsrvDriver
SqlsrvDriver::escapeBool() — Method in class SqlsrvDriver
SqlsrvDriver::escapeDate() — Method in class SqlsrvDriver
SqlsrvDriver::escapeDateTime() — Method in class SqlsrvDriver
SqlsrvDriver::escapeLike() — Method in class SqlsrvDriver: Encodes string for use in a LIKE statement.
Event — Class in namespace Dibi: Profiler & logger event.
Exception — Class in namespace Dibi: Dibi common exception.
Expression — Class in namespace Dibi: SQL expression.
Fluent::execute() — Method in class Fluent: Generates and executes SQL query.
Helpers::escape() — Method in class Helpers
Strict::extensionMethod() — Method in class Strict
$ dibi#elapsedTime — Property in class dibi

F

$ Panel#filter — Property in class Panel
Connection::fetch() — Method in class Connection: Executes SQL query and fetch result - shortcut for query() & fetch().
Connection::fetchAll() — Method in class Connection: Executes SQL query and fetch results - shortcut for query() & fetchAll().
Connection::fetchSingle() — Method in class Connection: Executes SQL query and fetch first column - shortcut for query() & fetchSingle().
Connection::fetchPairs() — Method in class Connection: Executes SQL query and fetch pairs - shortcut for query() & fetchPairs().
DataSource::fetch() — Method in class DataSource: Generates, executes SQL query and fetches the single row.
DataSource::fetchSingle() — Method in class DataSource: Like fetch(), but returns only first field.
DataSource::fetchAll() — Method in class DataSource: Fetches all records from table.
DataSource::fetchAssoc() — Method in class DataSource: Fetches all records from table and returns associative tree.
DataSource::fetchPairs() — Method in class DataSource: Fetches all records from table like $key => $value pairs.
FirebirdDriver — Class in namespace Dibi\Drivers: The driver for Firebird/InterBase database.
FirebirdReflector — Class in namespace Dibi\Drivers: The reflector for Firebird/InterBase database.
FirebirdResult — Class in namespace Dibi\Drivers: The driver for Firebird/InterBase result set.
FirebirdResult::fetch() — Method in class FirebirdResult: Fetches the row at current position and moves the internal cursor to the next position.
FirebirdResult::free() — Method in class FirebirdResult: Frees the resources allocated for this result set.
MySqliResult::fetch() — Method in class MySqliResult: Fetches the row at current position and moves the internal cursor to the next position.
MySqliResult::free() — Method in class MySqliResult: Frees the resources allocated for this result set.
NoDataResult::fetch() — Method in class NoDataResult: Fetches the row at current position and moves the internal cursor to the next position.
NoDataResult::free() — Method in class NoDataResult: Frees the resources allocated for this result set.
OdbcResult::fetch() — Method in class OdbcResult: Fetches the row at current position and moves the internal cursor to the next position.
OdbcResult::free() — Method in class OdbcResult: Frees the resources allocated for this result set.
OracleResult::fetch() — Method in class OracleResult: Fetches the row at current position and moves the internal cursor to the next position.
OracleResult::free() — Method in class OracleResult: Frees the resources allocated for this result set.
PdoResult::fetch() — Method in class PdoResult: Fetches the row at current position and moves the internal cursor to the next position.
PdoResult::free() — Method in class PdoResult: Frees the resources allocated for this result set.
PostgreResult::fetch() — Method in class PostgreResult: Fetches the row at current position and moves the internal cursor to the next position.
PostgreResult::free() — Method in class PostgreResult: Frees the resources allocated for this result set.
SqliteResult::fetch() — Method in class SqliteResult: Fetches the row at current position and moves the internal cursor to the next position.
SqliteResult::free() — Method in class SqliteResult: Frees the resources allocated for this result set.
SqlsrvResult::fetch() — Method in class SqlsrvResult: Fetches the row at current position and moves the internal cursor to the next position.
SqlsrvResult::free() — Method in class SqlsrvResult: Frees the resources allocated for this result set.
Fluent — Class in namespace Dibi: SQL builder via fluent interfaces.
Fluent::fetch() — Method in class Fluent: Generates, executes SQL query and fetches the single row.
Fluent::fetchSingle() — Method in class Fluent: Like fetch(), but returns only first field.
Fluent::fetchAll() — Method in class Fluent: Fetches all records from table.
Fluent::fetchAssoc() — Method in class Fluent: Fetches all records from table and returns associative tree.
Fluent::fetchPairs() — Method in class Fluent: Fetches all records from table like $key => $value pairs.
Fluent::from() — Method in class Fluent
ForeignKeyConstraintViolationException — Class in namespace Dibi: Exception for a foreign key constraint violation.
Helpers::false2Null() — Method in class Helpers
FileLogger — Class in namespace Dibi\Loggers: Dibi file logger.
$ FileLogger#file — Property in class FileLogger
$ FileLogger#filter — Property in class FileLogger
$ Column#fullName — Property in class Column
ForeignKey — Class in namespace Dibi\Reflection: Reflection metadata class for a foreign key.
$ Table#foreignKeys — Property in class Table
Result::free() — Method in class Result: Frees the resources allocated for this result set.
Result::fetch() — Method in class Result: Fetches the row at current position, process optional type conversion.
Result::fetchSingle() — Method in class Result: Like fetch(), but returns only first field.
Result::fetchAll() — Method in class Result: Fetches all records from table.
Result::fetchAssoc() — Method in class Result: Fetches all records from table and returns associative tree.
Result::fetchPairs() — Method in class Result: Fetches all records from table like $key => $value pairs.
ResultDriver::fetch() — Method in class ResultDriver: Fetches the row at current position and moves the internal cursor to the next position.
ResultDriver::free() — Method in class ResultDriver: Frees the resources allocated for this result set.
Translator::formatValue() — Method in class Translator: Apply modifier to single value.
dibi::fetch() — Method in class dibi
dibi::fetchAll() — Method in class dibi
dibi::fetchSingle() — Method in class dibi
dibi::fetchPairs() — Method in class dibi

G

Panel::getTab() — Method in class Panel: Returns HTML code for custom tab. (Tracy\IBarPanel)
Panel::getPanel() — Method in class Panel: Returns HTML code for custom panel. (Tracy\IBarPanel)
Connection::getConfig() — Method in class Connection: Returns configuration variable. If no $key is passed, returns the entire array.
Connection::getDriver() — Method in class Connection: Returns the driver and connects to a database in lazy mode.
Connection::getAffectedRows() — Method in class Connection: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Connection::getInsertId() — Method in class Connection: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Connection::getSubstitutes() — Method in class Connection: Returns substitution hashmap.
Connection::getDatabaseInfo() — Method in class Connection: Gets a information about the current database.
DataSource::getConnection() — Method in class DataSource
DataSource::getResult() — Method in class DataSource: Returns (and queries) Result.
DataSource::getIterator() — Method in class DataSource
DataSource::getTotalCount() — Method in class DataSource: Returns the number of rows in a given data source.
Driver::getAffectedRows() — Method in class Driver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Driver::getInsertId() — Method in class Driver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Driver::getResource() — Method in class Driver: Returns the connection resource.
Driver::getReflector() — Method in class Driver: Returns the connection reflector.
FirebirdDriver::getAffectedRows() — Method in class FirebirdDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
FirebirdDriver::getInsertId() — Method in class FirebirdDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
FirebirdDriver::getResource() — Method in class FirebirdDriver: Returns the connection resource.
FirebirdDriver::getReflector() — Method in class FirebirdDriver: Returns the connection reflector.
FirebirdReflector::getTables() — Method in class FirebirdReflector: Returns list of tables.
FirebirdReflector::getColumns() — Method in class FirebirdReflector: Returns metadata for all columns in a table.
FirebirdReflector::getIndexes() — Method in class FirebirdReflector: Returns metadata for all indexes in a table (the constraints are included).
FirebirdReflector::getForeignKeys() — Method in class FirebirdReflector: Returns metadata for all foreign keys in a table.
FirebirdReflector::getIndices() — Method in class FirebirdReflector: Returns list of indices in given table (the constraints are not listed).
FirebirdReflector::getConstraints() — Method in class FirebirdReflector: Returns list of constraints in given table.
FirebirdReflector::getTriggersMeta() — Method in class FirebirdReflector: Returns metadata for all triggers in a table or database.
FirebirdReflector::getTriggers() — Method in class FirebirdReflector: Returns list of triggers for given table.
FirebirdReflector::getProceduresMeta() — Method in class FirebirdReflector: Returns metadata from stored procedures and their input and output parameters.
FirebirdReflector::getProcedures() — Method in class FirebirdReflector: Returns list of stored procedures.
FirebirdReflector::getGenerators() — Method in class FirebirdReflector: Returns list of generators.
FirebirdReflector::getFunctions() — Method in class FirebirdReflector: Returns list of user defined functions (UDF).
FirebirdResult::getRowCount() — Method in class FirebirdResult: Returns the number of rows in a result set.
FirebirdResult::getResultResource() — Method in class FirebirdResult: Returns the result set resource.
FirebirdResult::getResultColumns() — Method in class FirebirdResult: Returns metadata for all columns in a result set.
MySqlReflector::getTables() — Method in class MySqlReflector: Returns list of tables.
MySqlReflector::getColumns() — Method in class MySqlReflector: Returns metadata for all columns in a table.
MySqlReflector::getIndexes() — Method in class MySqlReflector: Returns metadata for all indexes in a table.
MySqlReflector::getForeignKeys() — Method in class MySqlReflector: Returns metadata for all foreign keys in a table.
MySqliDriver::getInfo() — Method in class MySqliDriver: Retrieves information about the most recently executed query.
MySqliDriver::getAffectedRows() — Method in class MySqliDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
MySqliDriver::getInsertId() — Method in class MySqliDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
MySqliDriver::getResource() — Method in class MySqliDriver: Returns the connection resource.
MySqliDriver::getReflector() — Method in class MySqliDriver: Returns the connection reflector.
MySqliResult::getRowCount() — Method in class MySqliResult: Returns the number of rows in a result set.
MySqliResult::getResultColumns() — Method in class MySqliResult: Returns metadata for all columns in a result set.
MySqliResult::getResultResource() — Method in class MySqliResult: Returns the result set resource.
NoDataResult::getRowCount() — Method in class NoDataResult: Returns the number of affected rows.
NoDataResult::getResultColumns() — Method in class NoDataResult: Returns metadata for all columns in a result set.
NoDataResult::getResultResource() — Method in class NoDataResult: Returns the result set resource.
OdbcDriver::getAffectedRows() — Method in class OdbcDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
OdbcDriver::getInsertId() — Method in class OdbcDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
OdbcDriver::getResource() — Method in class OdbcDriver: Returns the connection resource.
OdbcDriver::getReflector() — Method in class OdbcDriver: Returns the connection reflector.
OdbcReflector::getTables() — Method in class OdbcReflector: Returns list of tables.
OdbcReflector::getColumns() — Method in class OdbcReflector: Returns metadata for all columns in a table.
OdbcReflector::getIndexes() — Method in class OdbcReflector: Returns metadata for all indexes in a table.
OdbcReflector::getForeignKeys() — Method in class OdbcReflector: Returns metadata for all foreign keys in a table.
OdbcResult::getRowCount() — Method in class OdbcResult: Returns the number of rows in a result set.
OdbcResult::getResultColumns() — Method in class OdbcResult: Returns metadata for all columns in a result set.
OdbcResult::getResultResource() — Method in class OdbcResult: Returns the result set resource.
OracleDriver::getAffectedRows() — Method in class OracleDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
OracleDriver::getInsertId() — Method in class OracleDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
OracleDriver::getResource() — Method in class OracleDriver: Returns the connection resource.
OracleDriver::getReflector() — Method in class OracleDriver: Returns the connection reflector.
OracleReflector::getTables() — Method in class OracleReflector: Returns list of tables.
OracleReflector::getColumns() — Method in class OracleReflector: Returns metadata for all columns in a table.
OracleReflector::getIndexes() — Method in class OracleReflector: Returns metadata for all indexes in a table.
OracleReflector::getForeignKeys() — Method in class OracleReflector: Returns metadata for all foreign keys in a table.
OracleResult::getRowCount() — Method in class OracleResult: Returns the number of rows in a result set.
OracleResult::getResultColumns() — Method in class OracleResult: Returns metadata for all columns in a result set.
OracleResult::getResultResource() — Method in class OracleResult: Returns the result set resource.
PdoDriver::getAffectedRows() — Method in class PdoDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
PdoDriver::getInsertId() — Method in class PdoDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
PdoDriver::getResource() — Method in class PdoDriver: Returns the connection resource.
PdoDriver::getReflector() — Method in class PdoDriver: Returns the connection reflector.
PdoResult::getRowCount() — Method in class PdoResult: Returns the number of rows in a result set.
PdoResult::getResultColumns() — Method in class PdoResult: Returns metadata for all columns in a result set.
PdoResult::getResultResource() — Method in class PdoResult: Returns the result set resource.
PostgreDriver::getAffectedRows() — Method in class PostgreDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
PostgreDriver::getInsertId() — Method in class PostgreDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
PostgreDriver::getResource() — Method in class PostgreDriver: Returns the connection resource.
PostgreDriver::getReflector() — Method in class PostgreDriver: Returns the connection reflector.
PostgreReflector::getTables() — Method in class PostgreReflector: Returns list of tables.
PostgreReflector::getColumns() — Method in class PostgreReflector: Returns metadata for all columns in a table.
PostgreReflector::getIndexes() — Method in class PostgreReflector: Returns metadata for all indexes in a table.
PostgreReflector::getForeignKeys() — Method in class PostgreReflector: Returns metadata for all foreign keys in a table.
PostgreResult::getRowCount() — Method in class PostgreResult: Returns the number of rows in a result set.
PostgreResult::getResultColumns() — Method in class PostgreResult: Returns metadata for all columns in a result set.
PostgreResult::getResultResource() — Method in class PostgreResult: Returns the result set resource.
SqliteDriver::getAffectedRows() — Method in class SqliteDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
SqliteDriver::getInsertId() — Method in class SqliteDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
SqliteDriver::getResource() — Method in class SqliteDriver: Returns the connection resource.
SqliteDriver::getReflector() — Method in class SqliteDriver: Returns the connection reflector.
SqliteReflector::getTables() — Method in class SqliteReflector: Returns list of tables.
SqliteReflector::getColumns() — Method in class SqliteReflector: Returns metadata for all columns in a table.
SqliteReflector::getIndexes() — Method in class SqliteReflector: Returns metadata for all indexes in a table.
SqliteReflector::getForeignKeys() — Method in class SqliteReflector: Returns metadata for all foreign keys in a table.
SqliteResult::getRowCount() — Method in class SqliteResult: Returns the number of rows in a result set.
SqliteResult::getResultColumns() — Method in class SqliteResult: Returns metadata for all columns in a result set.
SqliteResult::getResultResource() — Method in class SqliteResult: Returns the result set resource.
SqlsrvDriver::getAffectedRows() — Method in class SqlsrvDriver: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
SqlsrvDriver::getInsertId() — Method in class SqlsrvDriver: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
SqlsrvDriver::getResource() — Method in class SqlsrvDriver: Returns the connection resource.
SqlsrvDriver::getReflector() — Method in class SqlsrvDriver: Returns the connection reflector.
SqlsrvReflector::getTables() — Method in class SqlsrvReflector: Returns list of tables.
SqlsrvReflector::getColumns() — Method in class SqlsrvReflector: Returns metadata for all columns in a table.
SqlsrvReflector::getIndexes() — Method in class SqlsrvReflector: Returns metadata for all indexes in a table.
SqlsrvReflector::getForeignKeys() — Method in class SqlsrvReflector: Returns metadata for all foreign keys in a table.
SqlsrvResult::getRowCount() — Method in class SqlsrvResult: Returns the number of rows in a result set.
SqlsrvResult::getResultColumns() — Method in class SqlsrvResult: Returns metadata for all columns in a result set.
SqlsrvResult::getResultResource() — Method in class SqlsrvResult: Returns the result set resource.
Exception::getSql() — Method in class Exception
Expression::getValues() — Method in class Expression
Fluent::getFlag() — Method in class Fluent: Is a flag set?
Fluent::getCommand() — Method in class Fluent: Returns SQL command.
Fluent::getConnection() — Method in class Fluent
Fluent::getIterator() — Method in class Fluent: Required by the IteratorAggregate interface.
Fluent::groupBy() — Method in class Fluent
HashMapBase::getCallback() — Method in class HashMapBase
Helpers::getSuggestion() — Method in class Helpers: Finds the best suggestion.
Helpers::getTypeCache() — Method in class Helpers
IConnection::getDriver() — Method in class IConnection: Returns the driver and connects to a database in lazy mode.
IConnection::getAffectedRows() — Method in class IConnection: Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
IConnection::getInsertId() — Method in class IConnection: Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
ProcedureException::getSeverity() — Method in class ProcedureException: Gets the exception severity.
Column::getName() — Method in class Column
Column::getFullName() — Method in class Column
Column::getTable() — Method in class Column
Column::getTableName() — Method in class Column
Column::getType() — Method in class Column
Column::getNativeType() — Method in class Column
Column::getSize() — Method in class Column
Column::getDefault() — Method in class Column
Column::getVendorInfo() — Method in class Column
Database::getName() — Method in class Database
Database::getTables() — Method in class Database
Database::getTableNames() — Method in class Database
Database::getTable() — Method in class Database
ForeignKey::getName() — Method in class ForeignKey
ForeignKey::getReferences() — Method in class ForeignKey
Index::getName() — Method in class Index
Index::getColumns() — Method in class Index
Result::getColumns() — Method in class Result
Result::getColumnNames() — Method in class Result
Result::getColumn() — Method in class Result
Table::getName() — Method in class Table
Table::getColumns() — Method in class Table
Table::getColumnNames() — Method in class Table
Table::getColumn() — Method in class Table
Table::getForeignKeys() — Method in class Table
Table::getIndexes() — Method in class Table
Table::getPrimaryKey() — Method in class Table
Reflector::getTables() — Method in class Reflector: Returns list of tables.
Reflector::getColumns() — Method in class Reflector: Returns metadata for all columns in a table.
Reflector::getIndexes() — Method in class Reflector: Returns metadata for all indexes in a table.
Reflector::getForeignKeys() — Method in class Reflector: Returns metadata for all foreign keys in a table.
Result::getResultDriver() — Method in class Result: Safe access to property $driver.
Result::getRowCount() — Method in class Result: Returns the number of rows in a result set.
Result::getIterator() — Method in class Result: Required by the IteratorAggregate interface.
Result::getColumnCount() — Method in class Result: Returns the number of columns in a result set.
Result::getRowClass() — Method in class Result: Returns fetched object class name.
Result::getType() — Method in class Result: Returns column type.
Result::getTypes() — Method in class Result: Returns columns type.
Result::getFormat() — Method in class Result: Returns data format.
Result::getInfo() — Method in class Result: Returns a meta information about the current result set.
Result::getColumns() — Method in class Result
ResultDriver::getRowCount() — Method in class ResultDriver: Returns the number of rows in a result set.
ResultDriver::getResultColumns() — Method in class ResultDriver: Returns metadata for all columns in a result set.
ResultDriver::getResultResource() — Method in class ResultDriver: Returns the result set resource.
Row::getIterator() — Method in class Row
dibi::getConnection() — Method in class dibi: Retrieve active connection.
dibi::getAffectedRows() — Method in class dibi
dibi::getInsertId() — Method in class dibi
dibi::getDatabaseInfo() — Method in class dibi
dibi::getSubstitutes() — Method in class dibi

H

Fluent::having() — Method in class Fluent
HashMap — Class in namespace Dibi: Lazy cached storage.
HashMapBase — Class in namespace Dibi: Lazy cached storage.
Helpers — Class in namespace Dibi
Column::hasTable() — Method in class Column
Database::hasTable() — Method in class Database
Result::hasColumn() — Method in class Result
Table::hasColumn() — Method in class Table

I

$ Connection#insertId — Property in class Connection
Connection::isConnected() — Method in class Connection: Returns true when connection was established.
Connection::insertId() — Method in class Connection
Connection::insert() — Method in class Connection
FirebirdDriver::inTransaction() — Method in class FirebirdDriver: Is in transaction?
OdbcDriver::inTransaction() — Method in class OdbcDriver: Is in transaction?
PostgreDriver::inTransaction() — Method in class PostgreDriver: Is in transaction?
Fluent::innerJoin() — Method in class Fluent
Helpers::intVal() — Method in class Helpers
IConnection — Class in namespace Dibi: Dibi connection.
IConnection::isConnected() — Method in class IConnection: Returns true when connection was established.
IDataSource — Class in namespace Dibi: Provides an interface between a dataset and data-aware components.
Column::isNullable() — Method in class Column
Column::isAutoIncrement() — Method in class Column
Database::init() — Method in class Database
Index — Class in namespace Dibi\Reflection: Reflection metadata class for a index or primary key.
Index::isUnique() — Method in class Index
Index::isPrimary() — Method in class Index
Result::initColumns() — Method in class Result
$ Table#indexes — Property in class Table
Table::isView() — Method in class Table
Table::initColumns() — Method in class Table
Table::initIndexes() — Method in class Table
Table::initForeignKeys() — Method in class Table
dibi::isConnected() — Method in class dibi: Returns true when connection was established.
dibi::insertId() — Method in class dibi
dibi::insert() — Method in class dibi

J

Fluent::join() — Method in class Fluent

K

ResultIterator::key() — Method in class ResultIterator: Returns the key of the current element.

L

DibiExtension22::loadConfiguration() — Method in class DibiExtension22
Panel::logEvent() — Method in class Panel: After event notification.
Connection::literal() — Method in class Connection
Connection::loadFile() — Method in class Connection: Import SQL dump from file.
Fluent::limit() — Method in class Fluent
Fluent::leftJoin() — Method in class Fluent
Helpers::loadFromFile() — Method in class Helpers: Import SQL dump from file.
Literal — Class in namespace Dibi: SQL literal value.
FileLogger::logEvent() — Method in class FileLogger: After event notification.
dibi::loadFile() — Method in class dibi

M

$ Panel#maxLength — Property in class Panel
DateTime::modifyClone() — Method in class DateTime
DateTime::modify() — Method in class DateTime
MySqlReflector — Class in namespace Dibi\Drivers: The reflector for MySQL databases.
MySqliDriver — Class in namespace Dibi\Drivers: The driver for MySQL database.
MySqliResult — Class in namespace Dibi\Drivers: The driver for MySQL result set.
$ Fluent#masks — Property in class Fluent
$ Fluent#modifiers — Property in class Fluent

N

Connection::nativeQuery() — Method in class Connection: Executes the SQL query.
NoDataResult — Class in namespace Dibi\Drivers: The driver for no result set.
NotImplementedException — Class in namespace Dibi
NotNullConstraintViolationException — Class in namespace Dibi: Exception for a NOT NULL constraint violation.
NotSupportedException — Class in namespace Dibi
$ Column#name — Property in class Column
$ Column#nativeType — Property in class Column
$ Column#nullable — Property in class Column
$ Database#name — Property in class Database
$ ForeignKey#name — Property in class ForeignKey
$ Index#name — Property in class Index
$ Table#name — Property in class Table
ResultIterator::next() — Method in class ResultIterator: Moves forward to next element.
$ dibi#numOfQueries — Property in class dibi
dibi::nativeQuery() — Method in class dibi

O

$ Connection#onEvent — Property in class Connection
Connection::onEvent() — Method in class Connection
DataSource::orderBy() — Method in class DataSource: Selects columns to order by.
OdbcDriver — Class in namespace Dibi\Drivers: The driver interacting with databases via ODBC connections.
OdbcReflector — Class in namespace Dibi\Drivers: The reflector for ODBC connections.
OdbcResult — Class in namespace Dibi\Drivers: The driver interacting with result set via ODBC connections.
OracleDriver — Class in namespace Dibi\Drivers: The driver for Oracle database.
OracleReflector — Class in namespace Dibi\Drivers: The reflector for Oracle database.
OracleResult — Class in namespace Dibi\Drivers: The driver for Oracle result set.
Fluent::orderBy() — Method in class Fluent
Fluent::offset() — Method in class Fluent
Fluent::outerJoin() — Method in class Fluent
Fluent::on() — Method in class Fluent
Fluent::or() — Method in class Fluent
Row::offsetSet() — Method in class Row
Row::offsetGet() — Method in class Row
Row::offsetExists() — Method in class Row
Row::offsetUnset() — Method in class Row

P

Panel — Class in namespace Dibi\Bridges\Tracy: Dibi panel for Tracy.
PdoDriver — Class in namespace Dibi\Drivers: The driver for PDO.
PdoResult — Class in namespace Dibi\Drivers: The driver for PDO result set.
PostgreDriver — Class in namespace Dibi\Drivers: The driver for PostgreSQL database.
PostgreDriver::ping() — Method in class PostgreDriver: Pings database.
PostgreReflector — Class in namespace Dibi\Drivers: The reflector for PostgreSQL database.
PostgreResult — Class in namespace Dibi\Drivers: The driver for PostgreSQL result set.
PcreException — Class in namespace Dibi: PCRE exception.
ProcedureException — Class in namespace Dibi: Database procedure exception.
$ Index#primary — Property in class Index
$ Table#primaryKey — Property in class Table

Q

Connection::query() — Method in class Connection: Generates (translates) and executes SQL query.
Driver::query() — Method in class Driver: Internal: Executes the SQL query.
FirebirdDriver::query() — Method in class FirebirdDriver: Executes the SQL query.
MySqliDriver::query() — Method in class MySqliDriver: Executes the SQL query.
OdbcDriver::query() — Method in class OdbcDriver: Executes the SQL query.
OracleDriver::query() — Method in class OracleDriver: Executes the SQL query.
PdoDriver::query() — Method in class PdoDriver: Executes the SQL query.
PostgreDriver::query() — Method in class PostgreDriver: Executes the SQL query.
SqliteDriver::query() — Method in class SqliteDriver: Executes the SQL query.
SqlsrvDriver::query() — Method in class SqlsrvDriver: Executes the SQL query.
IConnection::query() — Method in class IConnection: Generates (translates) and executes SQL query.
dibi::query() — Method in class dibi

R

Panel::register() — Method in class Panel
Panel::renderException() — Method in class Panel: Returns blue-screen custom tab.
Connection::rollback() — Method in class Connection: Rollback changes in a transaction.
DataSource::release() — Method in class DataSource: Discards the internal cache.
Driver::rollback() — Method in class Driver: Rollback changes in a transaction.
FirebirdDriver::rollback() — Method in class FirebirdDriver: Rollback changes in a transaction.
MySqliDriver::rollback() — Method in class MySqliDriver: Rollback changes in a transaction.
OdbcDriver::rollback() — Method in class OdbcDriver: Rollback changes in a transaction.
OracleDriver::rollback() — Method in class OracleDriver: Rollback changes in a transaction.
PdoDriver::rollback() — Method in class PdoDriver: Rollback changes in a transaction.
PostgreDriver::rollback() — Method in class PostgreDriver: Rollback changes in a transaction.
SqliteDriver::rollback() — Method in class SqliteDriver: Rollback changes in a transaction.
SqliteDriver::registerFunction() — Method in class SqliteDriver: Registers an user defined function for use in SQL statements.
SqliteDriver::registerAggregateFunction() — Method in class SqliteDriver: Registers an aggregating user defined function for use in SQL statements.
SqlsrvDriver::rollback() — Method in class SqlsrvDriver: Rollback changes in a transaction.
$ Event#result — Property in class Event
Fluent::removeClause() — Method in class Fluent: Removes a clause.
Fluent::rightJoin() — Method in class Fluent
IConnection::rollback() — Method in class IConnection: Rollback changes in a transaction.
$ ForeignKey#references — Property in class ForeignKey
Result — Class in namespace Dibi\Reflection: Reflection metadata class for a result set.
Reflector — Class in namespace Dibi: Reflection driver.
Result — Class in namespace Dibi: Query result.
$ Result#rowCount — Property in class Result
ResultDriver — Class in namespace Dibi: Result set driver interface.
ResultIterator — Class in namespace Dibi: External result set iterator.
ResultIterator::rewind() — Method in class ResultIterator: Rewinds the iterator to the first element.
Row — Class in namespace Dibi: Result set single row.
dibi::rollback() — Method in class dibi

S

Connection::select() — Method in class Connection
Connection::substitute() — Method in class Connection: Provides substitution.
DataSource::select() — Method in class DataSource: Selects columns to query.
DateTime::setDate() — Method in class DateTime
DateTime::setISODate() — Method in class DateTime
DateTime::setTime() — Method in class DateTime
DateTime::setTimestamp() — Method in class DateTime
DateTime::setTimezone() — Method in class DateTime
DateTime::sub() — Method in class DateTime
FirebirdResult::seek() — Method in class FirebirdResult: Moves cursor position without fetching row.
MySqliResult::seek() — Method in class MySqliResult: Moves cursor position without fetching row.
NoDataResult::seek() — Method in class NoDataResult: Moves cursor position without fetching row.
OdbcResult::seek() — Method in class OdbcResult: Moves cursor position without fetching row.
OracleResult::seek() — Method in class OracleResult: Moves cursor position without fetching row.
PdoResult::seek() — Method in class PdoResult: Moves cursor position without fetching row.
PostgreResult::seek() — Method in class PostgreResult: Moves cursor position without fetching row.
Sqlite3Driver — Class in namespace Dibi\Drivers: Alias for SqliteDriver driver.
Sqlite3Result — Class in namespace Dibi\Drivers: Alias for SqliteResult driver.
SqliteDriver — Class in namespace Dibi\Drivers: The driver for SQLite v3 database.
SqliteReflector — Class in namespace Dibi\Drivers: The reflector for SQLite database.
SqliteResult — Class in namespace Dibi\Drivers: The driver for SQLite result set.
SqliteResult::seek() — Method in class SqliteResult: Moves cursor position without fetching row.
SqlsrvDriver — Class in namespace Dibi\Drivers: The driver for Microsoft SQL Server and SQL Azure databases.
SqlsrvReflector — Class in namespace Dibi\Drivers: The reflector for Microsoft SQL Server and SQL Azure databases.
SqlsrvResult — Class in namespace Dibi\Drivers: The driver for Microsoft SQL Server and SQL Azure result set.
SqlsrvResult::seek() — Method in class SqlsrvResult: Moves cursor position without fetching row.
$ Event#sql — Property in class Event
$ Event#source — Property in class Event
$ Fluent#separators — Property in class Fluent
Fluent::setFlag() — Method in class Fluent: Change a SQL flag.
Fluent::setupResult() — Method in class Fluent: Adds Result setup.
Fluent::select() — Method in class Fluent
HashMapBase::setCallback() — Method in class HashMapBase
$ ProcedureException#severity — Property in class ProcedureException
$ Column#size — Property in class Column
Result::seek() — Method in class Result: Moves cursor position without fetching row.
Result::setRowClass() — Method in class Result: Set fetched object class. This class should extend the Row class.
Result::setRowFactory() — Method in class Result: Set a factory to create fetched object instances. These should extend the Row class.
Result::setType() — Method in class Result: Define column type.
Result::setFormat() — Method in class Result: Sets date format.
ResultDriver::seek() — Method in class ResultDriver: Moves cursor position without fetching row.
Strict — Class in namespace Dibi: Better OOP experience.
$ dibi#sql — Property in class dibi
dibi::setConnection() — Method in class dibi: Sets connection.
dibi::stripMicroseconds() — Method in class dibi: Strips microseconds part.
dibi::select() — Method in class dibi

T

Connection::translate() — Method in class Connection: Generates SQL query.
Connection::test() — Method in class Connection: Generates and prints SQL query.
Connection::translateArgs() — Method in class Connection: Generates SQL query.
DataSource::toFluent() — Method in class DataSource: Returns this data source wrapped in Fluent object.
DataSource::toDataSource() — Method in class DataSource: Returns this data source wrapped in DataSource object.
$ Event#type — Property in class Event
$ Event#time — Property in class Event
Fluent::test() — Method in class Fluent: Generates and prints SQL query or it's part.
Fluent::toDataSource() — Method in class Fluent
$ Column#table — Property in class Column
$ Column#type — Property in class Column
$ Database#tables — Property in class Database
$ Database#tableNames — Property in class Database
Table — Class in namespace Dibi\Reflection: Reflection metadata class for a database table.
Row::toArray() — Method in class Row
Translator — Class in namespace Dibi: SQL translator.
Translator::translate() — Method in class Translator: Generates SQL. Can be called only once.
Type — Class in namespace Dibi: Data types.
$ dibi#totalTime — Property in class dibi
dibi::test() — Method in class dibi

U

Connection::update() — Method in class Connection
FirebirdResult::unescapeBinary() — Method in class FirebirdResult: Decodes data from result set.
MySqliResult::unescapeBinary() — Method in class MySqliResult: Decodes data from result set.
NoDataResult::unescapeBinary() — Method in class NoDataResult: Decodes data from result set.
OdbcResult::unescapeBinary() — Method in class OdbcResult: Decodes data from result set.
OracleResult::unescapeBinary() — Method in class OracleResult: Decodes data from result set.
PdoResult::unescapeBinary() — Method in class PdoResult: Decodes data from result set.
PostgreResult::unescapeBinary() — Method in class PostgreResult: Decodes data from result set.
SqliteResult::unescapeBinary() — Method in class SqliteResult: Decodes data from result set.
SqlsrvResult::unescapeBinary() — Method in class SqlsrvResult: Decodes data from result set.
Fluent::using() — Method in class Fluent
$ Index#unique — Property in class Index
ResultDriver::unescapeBinary() — Method in class ResultDriver: Decodes data from result set.
UniqueConstraintViolationException — Class in namespace Dibi: Exception for a unique constraint violation.
dibi::update() — Method in class dibi

V

$ Table#view — Property in class Table
ResultIterator::valid() — Method in class ResultIterator: Checks if there is a current element after calls to rewind() or next().

W

DataSource::where() — Method in class DataSource: Adds conditions to query.
Fluent::where() — Method in class Fluent

_

DibiExtension22::__construct() — Method in class DibiExtension22

Panel::__construct() — Method in class Panel

Connection::__construct() — Method in class Connection

Connection options: (see driver-specific options too)

lazy (bool) => if true, connection will be established only when required
result (array) => result set options
- formatDateTime => date-time format (if empty, DateTime objects will be returned)
profiler (array)
- run (bool) => enable profiler?
- file => file to log
substitutes (array) => map of driver specific substitutes (under development)
onConnect (array) => list of SQL queries to execute (by Connection::query()) after connection is established

Connection::__destruct() — Method in class Connection