MDB_mysql (Constructor) [line 89]
autoCommit [line 224]
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 269]
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 318]
convertResult [line 829]
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:
currId [line 1366]
mixed currId(
string
$seq_name)
|
|
returns the current id of a sequence
Overrides
MDB_Common::currId() (returns the current id of a sequence)
Parameters:
endOfResult [line 749]
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 145]
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)
fetch [line 771]
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 813]
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 796]
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 1389]
int fetchInto(
resource
$result, [int
$fetchmode = MDB_FETCHMODE_DEFAULT], [int
$rownum = NULL])
|
|
Fetch a row and insert the data into an existing array.
Overrides
MDB_Common::fetchInto() (Fetch a row and return data in an array.)
Parameters:
freeBlobValue [line 1270]
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 1226]
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 864]
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 993]
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 1246]
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:
getClobDeclaration [line 943]
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 1202]
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 697]
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 1041]
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:
getDecimalDeclaration [line 1179]
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 1305]
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 1136]
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 1288]
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 908]
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:
getTimeDeclaration [line 1104]
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 1073]
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:
mysqlRaiseError [line 164]
object a mysqlRaiseError(
[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:
nextId [line 1324]
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 1435]
true nextResult(
a
$result)
|
|
Move the internal mysql result pointer to the next available result Currently not supported
Parameters:
numCols [line 729]
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 849]
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 463]
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:
quoteIdentifier [line 200]
string quoteIdentifier(
string
$str)
|
|
Quote a string so it can be safely used as a table or column name
Quoting style depends on which database driver is being used.
MySQL can't handle the backtick character (`) in table or column names.
Overrides
MDB_Common::quoteIdentifier() (Quote a string so it can be safely used as a table or column name)
Parameters:
replace [line 612]
mixed replace(
string
$table, array
$fields)
|
|
Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the REPLACE query just updates its values instead of inserting a new row.
The REPLACE type of query does not make part of the SQL standards. Since practically only MySQL implements it natively, this type of query is emulated through this method for other DBMS using standard types of queries inside a transaction to assure the atomicity of the operation.
Overrides
MDB_Common::replace() (Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the REPLACE query just updates its values instead of inserting a new row.)
Parameters:
rollback [line 296]
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.)
subSelect [line 525]
string subSelect(
string
$query, [string
$quote = FALSE])
|
|
simple subselect emulation for Mysql
Overrides
MDB_Common::subSelect() (simple subselect emulation: leaves the query untouched for all RDBMS that support subselects)
Parameters:
tableInfo [line 1451]
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: