A

$ Connection#affectedRows — Property in class Connection
DataSource::applyLimit() — Method in class DataSource

Limits number of rows.

Driver::applyLimit() — Method in class Driver

Injects LIMIT/OFFSET to the SQL query.

DummyDriver::applyLimit() — Method in class DummyDriver

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.

B

Connection::begin() — Method in class Connection

Begins a transaction (if supported).

Driver::begin() — Method in class Driver

Begins a transaction (if supported).

DummyDriver::begin() — Method in class DummyDriver

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.

DummyDriver::commit() — Method in class DummyDriver

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
clauses
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.

DummyDriver — Class in namespace Dibi\Drivers

The dummy driver for testing purposes.

DummyDriver::disconnect() — Method in class DummyDriver

Disconnects from a database.

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::delete() — 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::escapeDateInterval() — Method in class Driver
Driver::escapeLike() — Method in class Driver

Encodes string for use in a LIKE statement.

DummyDriver::escapeText() — Method in class DummyDriver

Encodes data for use in a SQL statement.

DummyDriver::escapeBinary() — Method in class DummyDriver
DummyDriver::escapeIdentifier() — Method in class DummyDriver
DummyDriver::escapeBool() — Method in class DummyDriver
DummyDriver::escapeDate() — Method in class DummyDriver
DummyDriver::escapeDateTime() — Method in class DummyDriver
DummyDriver::escapeDateInterval() — Method in class DummyDriver
DummyDriver::escapeLike() — Method in class DummyDriver

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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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::escapeDateInterval() — 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
$ dibi#elapsedTime — Property in class dibi

Elapsed time for last query

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.

DummyDriver::fetch() — Method in class DummyDriver

Fetches the row at current position and moves the internal cursor to the next position.

DummyDriver::free() — Method in class DummyDriver

Frees the resources allocated for this result set.

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

Name of the file where SQL errors should be logged

$ 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.

DummyDriver::getAffectedRows() — Method in class DummyDriver

Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.

DummyDriver::getInsertId() — Method in class DummyDriver

Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.

DummyDriver::getResource() — Method in class DummyDriver

Returns the connection resource.

DummyDriver::getReflector() — Method in class DummyDriver

Returns the connection reflector.

DummyDriver::getRowCount() — Method in class DummyDriver

Returns the number of rows in a result set.

DummyDriver::getResultResource() — Method in class DummyDriver

Returns the result set resource.

DummyDriver::getResultColumns() — Method in class DummyDriver

Returns metadata for all columns in a result set.

DummyDriver::getTables() — Method in class DummyDriver

Returns list of tables.

DummyDriver::getColumns() — Method in class DummyDriver

Returns metadata for all columns in a table.

DummyDriver::getIndexes() — Method in class DummyDriver

Returns metadata for all indexes in a table.

DummyDriver::getForeignKeys() — Method in class DummyDriver

Returns metadata for all foreign keys in a table.

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::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
Fluent::insert() — Method in class Fluent
Fluent::into() — 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::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
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

default modifiers for arrays

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

Number or queries

dibi::nativeQuery() — Method in class dibi

O

$ Connection#onEvent — Property in class Connection

function (Event $event); Occurs after query is executed

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.

MySqliDriver::ping() — Method in class MySqliDriver

Pings a server connection, or tries to reconnect if the connection has gone down.

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.

DummyDriver::query() — Method in class DummyDriver

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.

DummyDriver::rollback() — Method in class DummyDriver

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.

Connection::setObjectTranslator() — Method in class Connection
DataSource::select() — Method in class DataSource

Selects columns to query.

DummyDriver::seek() — Method in class DummyDriver

Moves cursor position without fetching row.

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

clauses separators

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
Fluent::set() — 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 type format.

Result::setFormats() — Method in class Result

Sets type formats.

ResultDriver::seek() — Method in class ResultDriver

Moves cursor position without fetching row.

$ dibi#sql — Property in class dibi

Last SQL command dibi::query()

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::transaction() — Method in class Connection
Connection::translateObject() — Method in class Connection
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

Elapsed time for all queries

dibi::test() — Method in class dibi
dibi::transaction() — Method in class dibi

U

Connection::update() — Method in class Connection
DummyDriver::unescapeBinary() — Method in class DummyDriver

Decodes data from result set.

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::union() — Method in class Fluent
Fluent::unionAll() — Method in class Fluent
Fluent::using() — Method in class Fluent
Fluent::update() — 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

Fluent::values() — Method in class Fluent
$ 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
    • normalize => normalizes result fields (default: true)
    • formatDateTime => date-time format empty for decoding as Dibi\DateTime (default) "..." formatted according to given format, see https://www.php.net/manual/en/datetime.format.php "native" for leaving value as is
    • formatTimeInterval => time-interval format empty for decoding as DateInterval (default) "..." formatted according to given format, see https://www.php.net/manual/en/dateinterval.format.php "native" for leaving value as is
    • formatJson => json format "array" for decoding json as an array (default) "object" for decoding json as \stdClass "native" for leaving value as is
  • profiler (array)
    • run (bool) => enable profiler?
    • file => file to log
    • errorsOnly (bool) => log only errors
  • 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

Automatically frees the resources allocated for this result set.

Connection::__wakeup() — Method in class Connection

Prevents unserialization.

Connection::__sleep() — Method in class Connection

Prevents serialization.

DataSource::__construct() — Method in class DataSource
DataSource::__toString() — Method in class DataSource

Returns SQL query.

DateTime::__construct() — Method in class DateTime
DateTime::__toString() — Method in class DateTime
FirebirdDriver::__construct() — Method in class FirebirdDriver
FirebirdReflector::__construct() — Method in class FirebirdReflector
FirebirdResult::__construct() — Method in class FirebirdResult
MySqlReflector::__construct() — Method in class MySqlReflector
MySqliDriver::__construct() — Method in class MySqliDriver
MySqliResult::__construct() — Method in class MySqliResult
NoDataResult::__construct() — Method in class NoDataResult
OdbcDriver::__construct() — Method in class OdbcDriver
OdbcReflector::__construct() — Method in class OdbcReflector
OdbcResult::__construct() — Method in class OdbcResult
OracleDriver::__construct() — Method in class OracleDriver
OracleReflector::__construct() — Method in class OracleReflector
OracleResult::__construct() — Method in class OracleResult
PdoDriver::__construct() — Method in class PdoDriver
PdoResult::__construct() — Method in class PdoResult
PostgreDriver::__construct() — Method in class PostgreDriver
PostgreReflector::__construct() — Method in class PostgreReflector
PostgreResult::__construct() — Method in class PostgreResult
SqliteDriver::__construct() — Method in class SqliteDriver
SqliteReflector::__construct() — Method in class SqliteReflector
SqliteResult::__construct() — Method in class SqliteResult
SqlsrvDriver::__construct() — Method in class SqlsrvDriver
SqlsrvReflector::__construct() — Method in class SqlsrvReflector
SqlsrvResult::__construct() — Method in class SqlsrvResult
Event::__construct() — Method in class Event
Exception::__construct() — Method in class Exception
Exception::__toString() — Method in class Exception
Expression::__construct() — Method in class Expression
Fluent::__construct() — Method in class Fluent
Fluent::__call() — Method in class Fluent

Appends new argument to the clause.

Fluent::__toString() — Method in class Fluent

Returns SQL query.

Fluent::_export() — Method in class Fluent

Generates parameters for Translator.

Fluent::_formatClause() — Method in class Fluent

Format camelCase clause name to UPPER CASE.

Fluent::__clone() — Method in class Fluent
HashMap::__set() — Method in class HashMap
HashMap::__get() — Method in class HashMap
HashMapBase::__construct() — Method in class HashMapBase
Literal::__construct() — Method in class Literal
Literal::__toString() — Method in class Literal
FileLogger::__construct() — Method in class FileLogger
PcreException::__construct() — Method in class PcreException
ProcedureException::__construct() — Method in class ProcedureException

Construct the exception.

Column::__construct() — Method in class Column
Database::__construct() — Method in class Database
ForeignKey::__construct() — Method in class ForeignKey
Index::__construct() — Method in class Index
Result::__construct() — Method in class Result
Table::__construct() — Method in class Table
Result::__construct() — Method in class Result
ResultIterator::__construct() — Method in class ResultIterator
Row::__construct() — Method in class Row
Row::__get() — Method in class Row
Row::__isset() — Method in class Row
Translator::__construct() — Method in class Translator
Type::__construct() — Method in class Type
dibi::__construct() — Method in class dibi

Static class - cannot be instantiated.

dibi::__callStatic() — Method in class dibi

Monostate for Dibi\Connection.