FirebirdDriver
class FirebirdDriver implements Driver, ResultDriver, Reflector
The driver for Firebird/InterBase database.
Driver options:
- database => the path to database file (server:/path/database.fdb)
- username (or user)
- password (or pass)
- charset => character encoding to set
- buffers (int) => buffers is the number of database buffers to allocate for the server-side cache. If 0 or omitted, server chooses its own default.
- resource (resource) => existing connection resource
Constants
| ERROR_EXCEPTION_THROWN |
|
Methods
No description
Connects to a database.
Disconnects from a database.
Executes the SQL query.
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Begins a transaction (if supported).
Commits statements in a transaction.
Rollback changes in a transaction.
Is in transaction?
Returns the connection resource.
Returns the connection reflector.
Result set driver factory.
Encodes data for use in a SQL statement.
No description
No description
No description
No description
No description
Encodes string for use in a LIKE statement.
Decodes data from result set.
Injects LIMIT/OFFSET to the SQL query.
Automatically frees the resources allocated for this result set.
Returns the number of rows in a result set.
Fetches the row at current position and moves the internal cursor to the next position.
Moves cursor position without fetching row.
Frees the resources allocated for this result set.
Returns the result set resource.
Returns metadata for all columns in a result set.
Returns list of tables.
Returns metadata for all columns in a table.
Returns metadata for all indexes in a table (the constraints are included).
Returns metadata for all foreign keys in a table.
Returns list of indices in given table (the constraints are not listed).
Returns list of constraints in given table.
Returns metadata for all triggers in a table or database.
Returns list of triggers for given table.
Returns metadata from stored procedures and their input and output parameters.
Returns list of stored procedures.
Returns list of generators.
Returns list of user defined functions (UDF).
Details
at line 49
__construct()
No description
at line 62
void
connect(array $config)
Connects to a database.
at line 96
void
disconnect()
Disconnects from a database.
at line 108
ResultDriver|null
query($sql)
Executes the SQL query.
at line 133
int|false
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 144
int|false
getInsertId($sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 156
void
begin($savepoint = null)
Begins a transaction (if supported).
at line 172
void
commit($savepoint = null)
Commits statements in a transaction.
at line 192
void
rollback($savepoint = null)
Rollback changes in a transaction.
at line 210
bool
inTransaction()
Is in transaction?
at line 220
mixed
getResource()
Returns the connection resource.
at line 230
Reflector
getReflector()
Returns the connection reflector.
at line 241
ResultDriver
createResultDriver($resource)
Result set driver factory.
at line 257
string
escapeText($value)
Encodes data for use in a SQL statement.
at line 267
string
escapeBinary($value)
No description
at line 277
string
escapeIdentifier($value)
No description
at line 287
string
escapeBool($value)
No description
at line 297
string
escapeDate($value)
No description
at line 310
string
escapeDateTime($value)
No description
at line 325
string
escapeLike($value, $pos)
Encodes string for use in a LIKE statement.
at line 336
string
unescapeBinary($value)
Decodes data from result set.
at line 343
escape($value, $type)
deprecated
deprecated
No description
at line 357
void
applyLimit($sql, $limit, $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 375
void
__destruct()
Automatically frees the resources allocated for this result set.
at line 387
int
getRowCount()
Returns the number of rows in a result set.
at line 398
array
fetch($assoc)
Fetches the row at current position and moves the internal cursor to the next position.
at line 422
bool
seek($row)
Moves cursor position without fetching row.
at line 432
void
free()
Frees the resources allocated for this result set.
at line 443
mixed
getResultResource()
Returns the result set resource.
at line 454
array
getResultColumns()
Returns metadata for all columns in a result set.
at line 478
array
getTables()
Returns list of tables.
at line 502
array
getColumns($table)
Returns metadata for all columns in a table.
at line 557
array
getIndexes($table)
Returns metadata for all indexes in a table (the constraints are included).
at line 591
array
getForeignKeys($table)
Returns metadata for all foreign keys in a table.
at line 621
array
getIndices($table)
Returns list of indices in given table (the constraints are not listed).
at line 643
array
getConstraints($table)
Returns list of constraints in given table.
at line 669
array
getTriggersMeta($table = null)
Returns metadata for all triggers in a table or database.
(Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
at line 717
array
getTriggers($table = null)
Returns list of triggers for given table.
(Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
at line 738
array
getProceduresMeta()
Returns metadata from stored procedures and their input and output parameters.
at line 790
array
getProcedures()
Returns list of stored procedures.
at line 808
array
getGenerators()
Returns list of generators.
at line 827
array
getFunctions()
Returns list of user defined functions (UDF).
Traits
Better OOP experience.