MDB_fbsql (Constructor) [line 87]
autoCommit [line 191]
mixed autoCommit(
boolean
$auto_commit)
|
|
Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.
Overrides
MDB_Common::autoCommit() (Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.)
Parameters:
commit [line 233]
Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
Overrides
MDB_Common::commit() (Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.)
connect [line 282]
convertResult [line 585]
mixed convertResult(
mixed
$value, int
$type)
|
|
convert a value to a RDBMS indepdenant MDB type
Overrides
MDB_Common::convertResult() (convert a value to a RDBMS indepdenant MDB type)
Parameters:
endOfResult [line 496]
mixed endOfResult(
resource
$result)
|
|
check if the end of the result set has been reached
Overrides
MDB_Common::endOfResult() (check if the end of the result set has been reached)
Parameters:
errorNative [line 135]
Get the native error code of the last error (if any) that occured on the current connection.
Overrides
MDB_Common::errorNative() (returns an errormessage, provides by the database)
fbsqlRaiseError [line 154]
object a fbsqlRaiseError(
[integer
$errno = NULL], [string
$message = NULL])
|
|
This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for MDB::raiseError that checks for native error msgs.
Parameters:
fetch [line 518]
mixed fetch(
resource
$result, int
$row, int
$field)
|
|
fetch value from a result set
Overrides
MDB_Common::fetch() (fetch value from a result set)
Parameters:
fetchBlob [line 569]
mixed fetchBlob(
resource
$result, int
$row, int
$field)
|
|
fetch a blob value from a result set
Overrides
MDB_Common::fetchBlob() (fetch a blob value from a result set)
Parameters:
fetchClob [line 552]
mixed fetchClob(
resource
$result, int
$row, int
$field)
|
|
fetch a clob value from a result set
Overrides
MDB_Common::fetchClob() (fetch a clob value from a result set)
Parameters:
fetchInto [line 1223]
mixed fetchInto(
resource
$result, [int
$fetchmode = MDB_FETCHMODE_DEFAULT], [int
$rownum = NULL])
|
|
Fetch a row and return data in an array.
Overrides
MDB_Common::fetchInto() (Fetch a row and return data in an array.)
Parameters:
freeBlobValue [line 1058]
MDB_OK freeBlobValue(
resource
$prepared_query, string
$blob)
|
|
free a binary large object
Overrides
MDB_Common::freeBlobValue() (free a binary large object)
Parameters:
freeClobValue [line 1013]
MDB_OK freeClobValue(
resource
$prepared_query, string
$clob)
|
|
free a character large object
Overrides
MDB_Common::freeClobValue() (free a character large object)
Parameters:
freeResult [line 630]
boolean freeResult(
$result
$result)
|
|
Free the internal resources associated with $result.
Overrides
MDB_Common::freeResult() (Free the internal resources associated with $result.)
Parameters:
getBlobDeclaration [line 779]
string getBlobDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getBlobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.)
Parameters:
getBlobValue [line 1033]
string getBlobValue(
resource
$prepared_query, $parameter
$parameter, $blob
$blob)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getBlobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getBooleanDeclaration [line 807]
string getBooleanDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getBooleanDeclaration() (Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.)
Parameters:
getBooleanValue [line 1076]
string getBooleanValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getBooleanValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getClobDeclaration [line 747]
string getClobDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getClobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.)
Parameters:
getClobValue [line 988]
string getClobValue(
resource
$prepared_query, $parameter
$parameter, $clob
$clob)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getClobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getColumnNames [line 445]
mixed getColumnNames(
resource
$result)
|
|
Retrieve the names of columns returned by the DBMS in a query result.
Overrides
MDB_Common::getColumnNames() (Retrieve the names of columns returned by the DBMS in a query result.)
Parameters:
getDateDeclaration [line 837]
string getDateDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an date type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getDateDeclaration() (Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE.)
Parameters:
getDateValue [line 1093]
string getDateValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getDateValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getDecimalDeclaration [line 965]
string getDecimalDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an decimal type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getDecimalDeclaration() (Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE.)
Parameters:
getDecimalValue [line 1161]
string getDecimalValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getDecimalValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getFloatDeclaration [line 932]
string getFloatDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an float type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getFloatDeclaration() (Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE.)
Parameters:
getFloatValue [line 1144]
string getFloatValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getFloatValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getIntegerDeclaration [line 674]
string getIntegerDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getIntegerDeclaration() (Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.)
Parameters:
getTextDeclaration [line 712]
string getTextDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTextDeclaration() (Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.)
Parameters:
getTimeDeclaration [line 900]
string getTimeDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an time type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTimeDeclaration() (Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE.)
Parameters:
getTimestampDeclaration [line 869]
string getTimestampDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an timestamp type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTimestampDeclaration() (Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE.)
Parameters:
getTimestampValue [line 1110]
string getTimestampValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getTimestampValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getTimeValue [line 1127]
string getTimeValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getTimeValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
nextId [line 1182]
mixed nextId(
string
$seq_name, [boolean
$ondemand = TRUE])
|
|
returns the next free id of a sequence
Overrides
MDB_Common::nextId() (returns the next free id of a sequence)
Parameters:
nextResult [line 1268]
true nextResult(
a
$result)
|
|
Move the internal fbsql result pointer to the next available result
Parameters:
numCols [line 477]
mixed numCols(
resource
$result)
|
|
Count the number of columns returned by the DBMS in a query result.
Overrides
MDB_Common::numCols() (Count the number of columns returned by the DBMS in a query result.)
Parameters:
numRows [line 615]
mixed numRows(
ressource
$result)
|
|
returns the number of rows in a result object
Overrides
MDB_Common::numRows() (returns the number of rows in a result object)
Parameters:
query [line 377]
mixed query(
string
$query, [mixed
$types = NULL])
|
|
Send a query to the database and return any results
Overrides
MDB_Common::query() (Send a query to the database and return any results)
Parameters:
rollback [line 260]
Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
Overrides
MDB_Common::rollback() (Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.)
tableInfo [line 1284]
array tableInfo(
resource
$result, [mixed
$mode = NULL])
|
|
returns meta data about the result set
Overrides
MDB_Common::tableInfo() (returns meta data about the result set)
Parameters: