MDB_pgsql (Constructor) [line 88]
autoCommit [line 205]
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 232]
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 315]
convertResult [line 784]
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 1233]
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 594]
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:
endOfResultLob [line 675]
mixed endOfResultLob(
int
$lob)
|
|
Determine whether it was reached the end of the large object and therefore there is no more data to be read for the its input stream.
Overrides
MDB_Common::endOfResultLob() (Determine whether it was reached the end of the large object and therefore there is no more data to be read for the its input stream.)
Parameters:
errorCode [line 121]
int errorCode(
$nativecode
$errormsg)
|
|
Map native error codes to DB's portable ones. Requires that the DB implementation's constructor fills in the $errorcode_map property.
Overrides
MDB_Common::errorCode() (Map native error codes to MDB's portable ones. Requires that the DB implementation's constructor fills in the $errorcode_map property.)
Parameters:
errorNative [line 184]
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 615]
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 768]
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 751]
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 1257]
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:
freeResult [line 841]
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 941]
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 1147]
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 912]
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 1128]
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 544]
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 968]
string getDateDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a 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 1049]
string getDecimalDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a 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 1181]
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 1022]
string getFloatDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a 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 1164]
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:
getTextDeclaration [line 883]
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 995]
string getTimeDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a time 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:
nextId [line 1199]
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 1302]
true nextResult(
a
$result)
|
|
Move the internal pgsql result pointer to the next available result
Parameters:
numCols [line 575]
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 826]
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:
pgsqlRaiseError [line 163]
object a pgsqlRaiseError(
[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:
query [line 455]
mixed query(
string
$query, [array
$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:
resultIsNull [line 809]
mixed resultIsNull(
resource
$result, int
$row, int
$field)
|
|
Determine whether the value of a query result located in given row and field is a NULL.
Overrides
MDB_Common::resultIsNull() (Determine whether the value of a query result located in given row and field is a NULL.)
Parameters:
rollback [line 253]
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 1318]
array tableInfo(
$result, [mixed
$mode = NULL], mixed
$resource)
|
|
returns meta data about the result set
Overrides
MDB_Common::tableInfo() (returns meta data about the result set)
Parameters: