A

$ Connection#affectedRowsProperty 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#autoIncrementProperty 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

ConnectionClass 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
ConstraintViolationExceptionClass 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#connectionProperty in class Event
$ Event#countProperty in class Event
$ Fluent#clauseSwitchesProperty 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.

ColumnClass in namespace Dibi\Reflection

Reflection metadata class for a table or result set column.

$ Index#columnsProperty in class Index
$ Result#columnsProperty in class Result
$ Result#columnNamesProperty in class Result
$ Table#columnsProperty in class Table
$ Table#columnNamesProperty 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

DibiExtension22Class 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
DataSourceClass in namespace Dibi

Default implementation of IDataSource.

DateTimeClass in namespace Dibi
DateTime.
DriverClass in namespace Dibi

Driver interface.

Driver::disconnect() — Method in class Driver

Disconnects from a database.

DriverExceptionClass in namespace Dibi

database server exception.

DummyDriverClass 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#defaultProperty in class Column
DatabaseClass 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.

dibiClass 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#explainProperty 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.

EventClass in namespace Dibi

Profiler & logger event.

ExceptionClass in namespace Dibi

Dibi common exception.

ExpressionClass in namespace Dibi

SQL expression.

Fluent::execute() — Method in class Fluent

Generates and executes SQL query.

Helpers::escape() — Method in class Helpers
$ dibi#elapsedTimeProperty in class dibi

Elapsed time for last query

F

$ Panel#filterProperty 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.

FirebirdDriverClass in namespace Dibi\Drivers

The driver for Firebird/InterBase database.

FirebirdReflectorClass in namespace Dibi\Drivers

The reflector for Firebird/InterBase database.

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

FluentClass 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
ForeignKeyConstraintViolationExceptionClass in namespace Dibi

Exception for a foreign key constraint violation.

Helpers::false2Null() — Method in class Helpers
FileLoggerClass in namespace Dibi\Loggers

Dibi file logger.

$ FileLogger#fileProperty in class FileLogger

Name of the file where SQL errors should be logged

$ FileLogger#filterProperty in class FileLogger
$ Column#fullNameProperty in class Column
ForeignKeyClass in namespace Dibi\Reflection

Reflection metadata class for a foreign key.

$ Table#foreignKeysProperty 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
HashMapClass in namespace Dibi

Lazy cached storage.

HashMapBaseClass in namespace Dibi

Lazy cached storage.

HelpersClass 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#insertIdProperty 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
IConnectionClass in namespace Dibi

Dibi connection.

IConnection::isConnected() — Method in class IConnection

Returns true when connection was established.

IDataSourceClass 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
IndexClass 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#indexesProperty 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.

LiteralClass in namespace Dibi

SQL literal value.

FileLogger::logEvent() — Method in class FileLogger

After event notification.

dibi::loadFile() — Method in class dibi

M

$ Panel#maxLengthProperty in class Panel
MySqlReflectorClass in namespace Dibi\Drivers

The reflector for MySQL databases.

MySqliDriverClass in namespace Dibi\Drivers

The driver for MySQL database.

MySqliResultClass in namespace Dibi\Drivers

The driver for MySQL result set.

$ Fluent#masksProperty in class Fluent
$ Fluent#modifiersProperty in class Fluent

default modifiers for arrays

N

Connection::nativeQuery() — Method in class Connection

Executes the SQL query.

NoDataResultClass in namespace Dibi\Drivers

The driver for no result set.

NotImplementedExceptionClass in namespace Dibi
NotNullConstraintViolationExceptionClass in namespace Dibi

Exception for a NOT NULL constraint violation.

NotSupportedExceptionClass in namespace Dibi
$ Column#nameProperty in class Column
$ Column#nativeTypeProperty in class Column
$ Column#nullableProperty in class Column
$ Database#nameProperty in class Database
$ ForeignKey#nameProperty in class ForeignKey
$ Index#nameProperty in class Index
$ Table#nameProperty in class Table
ResultIterator::next() — Method in class ResultIterator

Moves forward to next element.

$ dibi#numOfQueriesProperty in class dibi

Number or queries

dibi::nativeQuery() — Method in class dibi

O

$ Connection#onEventProperty 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.

OdbcDriverClass in namespace Dibi\Drivers

The driver interacting with databases via ODBC connections.

OdbcReflectorClass in namespace Dibi\Drivers

The reflector for ODBC connections.

OdbcResultClass in namespace Dibi\Drivers

The driver interacting with result set via ODBC connections.

OracleDriverClass in namespace Dibi\Drivers

The driver for Oracle database.

OracleReflectorClass in namespace Dibi\Drivers

The reflector for Oracle database.

OracleResultClass 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

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

PdoDriverClass in namespace Dibi\Drivers

The driver for PDO.

PdoResultClass in namespace Dibi\Drivers

The driver for PDO result set.

PostgreDriverClass in namespace Dibi\Drivers

The driver for PostgreSQL database.

PostgreDriver::ping() — Method in class PostgreDriver

Pings database.

PostgreReflectorClass in namespace Dibi\Drivers

The reflector for PostgreSQL database.

PostgreResultClass in namespace Dibi\Drivers

The driver for PostgreSQL result set.

PcreExceptionClass in namespace Dibi

PCRE exception.

ProcedureExceptionClass in namespace Dibi

Database procedure exception.

$ Index#primaryProperty in class Index
$ Table#primaryKeyProperty 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#resultProperty 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#referencesProperty in class ForeignKey
ResultClass in namespace Dibi\Reflection

Reflection metadata class for a result set.

ReflectorClass in namespace Dibi

Reflection driver.

ResultClass in namespace Dibi

Query result.

$ Result#rowCountProperty in class Result
ResultDriverClass in namespace Dibi

Result set driver interface.

ResultIteratorClass in namespace Dibi

External result set iterator.

ResultIterator::rewind() — Method in class ResultIterator

Rewinds the iterator to the first element.

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

Sqlite3DriverClass in namespace Dibi\Drivers

Alias for SqliteDriver driver.

Sqlite3ResultClass in namespace Dibi\Drivers

Alias for SqliteResult driver.

SqliteDriverClass in namespace Dibi\Drivers

The driver for SQLite v3 database.

SqliteReflectorClass in namespace Dibi\Drivers

The reflector for SQLite database.

SqliteResultClass in namespace Dibi\Drivers

The driver for SQLite result set.

SqliteResult::seek() — Method in class SqliteResult

Moves cursor position without fetching row.

SqlsrvDriverClass in namespace Dibi\Drivers

The driver for Microsoft SQL Server and SQL Azure databases.

SqlsrvReflectorClass in namespace Dibi\Drivers

The reflector for Microsoft SQL Server and SQL Azure databases.

SqlsrvResultClass 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#sqlProperty in class Event
$ Event#sourceProperty in class Event
$ Fluent#separatorsProperty 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#severityProperty in class ProcedureException
$ Column#sizeProperty 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#sqlProperty 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#typeProperty in class Event
$ Event#timeProperty 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#tableProperty in class Column
$ Column#typeProperty in class Column
$ Database#tablesProperty in class Database
$ Database#tableNamesProperty in class Database
TableClass in namespace Dibi\Reflection

Reflection metadata class for a database table.

Row::toArray() — Method in class Row
TranslatorClass in namespace Dibi

SQL translator.

Translator::translate() — Method in class Translator

Generates SQL. Can be called only once.

TypeClass in namespace Dibi

Data types.

$ dibi#totalTimeProperty 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#uniqueProperty in class Index
ResultDriver::unescapeBinary() — Method in class ResultDriver

Decodes data from result set.

UniqueConstraintViolationExceptionClass in namespace Dibi

Exception for a unique constraint violation.

dibi::update() — Method in class dibi

V

Fluent::values() — Method in class Fluent
$ Table#viewProperty 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.