-
$_changes
-
an assoc with the names of the properties in this object that
-
$_data
-
stores the $data passed to execute() in the oci8 driver
-
$_db
-
-
$_db
-
-
$_db
-
-
$_dbh
-
DB connection handle used for all transactions
-
$_keycolumn
-
which column(s) in the table contains primary keys, can be a
-
$_lasterror
-
-
$_properties
-
an assoc with the names of database fields stored as properties
-
$_readonly
-
flag that decides if data in this object can be changed.
-
$_table
-
the name of the table (or view, if the backend database supports
-
$_validator
-
function or method that implements a validator for fields that
-
_add_flag
-
Adds a string to the flags array if the flag is not yet in there
- if there is no flag present the array is created.
-
_add_flag
-
Adds a string to the flags array if the flag is not yet in there
- if there is no flag present the array is created.
-
_BCsequence
-
Backwards compatibility with old sequence emulation implementation (clean up the dupes).
-
_BCsequence
-
Backwards compatibility with old sequence emulation implementation (clean up the dupes)
-
_convertNullArrayValuesToEmpty
-
Convert all null values in an array to empty strings
-
_DB_storage
-
Destructor, calls DB_storage::store() if there are changes that are to be kept.
-
_ibaseFieldFlags
-
get the Flags of a Field
-
_makeWhere
-
Utility method to build a "WHERE" clause to locate ourselves in the table.
-
_modifyQuery
-
"DELETE FROM table" gives 0 affected rows in SQLite.
-
_mssql_field_flags
-
Get the flags for a field, currently supports "not_null", "primary_key",
-
_pgFieldFlags
-
Flags of a Field
-
_rtrimArrayValues
-
Right trim all strings in an array
-
_sybase_field_flags
-
Get the flags for a field.
-
$affected
-
-
$affected
-
-
$autocommit
-
-
$autocommit
-
-
$autocommit
-
-
$autoCommit
-
-
$autocommit
-
-
$autocommit
-
-
$autocommit
-
-
$autocommit
-
-
affectedRows
-
Gets the number of rows affected by the last query.
-
affectedRows
-
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
-
affectedRows
-
Returns the number of rows affected by a manipulative query
-
affectedRows
-
Gets the number of rows affected by a query.
-
affectedRows
-
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
-
affectedRows
-
Returns the affected rows of a query
-
affectedRows
-
Gets the number of rows affected by the last query.
-
affectedRows
-
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
-
affectedRows
-
Gets the number of rows affected by the last query.
-
affectedRows
-
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
-
affectedRows
-
Gets the number of rows affected by a query.
-
affectedRows
-
Gets the number of rows affected by the last query.
-
apiVersion
-
Return the DB API version
-
assertExtension
-
Load a PHP database extension if it is not loaded already.
-
autoCommit
-
Enable/disable automatic commits
-
autoCommit
-
Enable/disable automatic commits
-
autoCommit
-
enable automatic Commit
-
autoCommit
-
Enable/disable automatic commits
-
autoCommit
-
-
autoCommit
-
-
autoCommit
-
Enable/disable automatic commits.
-
autoCommit
-
-
autoCommit
-
Enable/disable automatic commits
-
autoCommit
-
Enable/disable automatic commits
-
autoCommit
-
Enable/disable automatic commits
-
autoExecute
-
Automaticaly generate an insert or update query and call prepare() and execute() with it
-
autoPrepare
-
Automaticaly generate an insert or update query and pass it to prepare()
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
$connection
-
-
commit
-
Commit the current transaction.
-
commit
-
-
commit
-
Commit the current transaction.
-
commit
-
Commit transactions on the current connection
-
commit
-
Commit the current transaction.
-
commit
-
starts a Commit
-
commit
-
Commit the current transaction.
-
commit
-
Commit the current transaction.
-
commit
-
-
commit
-
Commit the current transaction.
-
commit
-
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
Connect to a database represented by a file.
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
-
connect
-
-
connect
-
Connect to a database and log in as the specified user.
-
connect
-
Create a new DB object and connect to the specified database.
-
create
-
Static method used to create new DB storage objects.
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Create the sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Create the sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
createSequence
-
Creates a new sequence
-
common.php
-
-
$dbh
-
DB handle
-
$dbh
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dbsyntax
-
-
$dsn
-
-
$dsn
-
-
DB
-
The main "DB" class is simply a container class with some static methods for creating DB objects as well as some utility functions common to all parts of DB.
-
DB_AUTOQUERY_INSERT
-
-
DB_AUTOQUERY_UPDATE
-
-
DB_BINMODE_CONVERT
-
-
DB_BINMODE_PASSTHRU
-
-
DB_BINMODE_RETURN
-
-
DB_common
-
DB_common is a base class for DB implementations, and must be inherited by all such
-
DB_common
-
Constructor
-
DB_dbase
-
Database independent query interface definition for PHP's dbase extension.
-
DB_dbase
-
DB_mysql constructor.
-
DB_ERROR
-
-
DB_Error
-
DB_Error implements a class for reporting portable database error messages.
-
DB_Error
-
DB_Error constructor.
-
DB_ERROR_ACCESS_VIOLATION
-
-
DB_ERROR_ALREADY_EXISTS
-
-
DB_ERROR_CANNOT_CREATE
-
-
DB_ERROR_CANNOT_DELETE
-
-
DB_ERROR_CANNOT_DROP
-
-
DB_ERROR_CONNECT_FAILED
-
-
DB_ERROR_CONSTRAINT
-
-
DB_ERROR_CONSTRAINT_NOT_NULL
-
-
DB_ERROR_DIVZERO
-
-
DB_ERROR_EXTENSION_NOT_FOUND
-
-
DB_ERROR_INVALID
-
-
DB_ERROR_INVALID_DATE
-
-
DB_ERROR_INVALID_DSN
-
-
DB_ERROR_INVALID_NUMBER
-
-
DB_ERROR_MISMATCH
-
-
DB_ERROR_NEED_MORE_DATA
-
-
DB_ERROR_NODBSELECTED
-
-
DB_ERROR_NOSUCHDB
-
-
DB_ERROR_NOSUCHFIELD
-
-
DB_ERROR_NOSUCHTABLE
-
-
DB_ERROR_NOT_CAPABLE
-
-
DB_ERROR_NOT_FOUND
-
-
DB_ERROR_NOT_LOCKED
-
-
DB_ERROR_SYNTAX
-
-
DB_ERROR_TRUNCATED
-
-
DB_ERROR_UNSUPPORTED
-
-
DB_ERROR_VALUE_COUNT_ON_ROW
-
-
DB_fbsql
-
DB_fbsql constructor.
-
DB_fbsql
-
Database independent query interface definition for PHP's FrontBase extension.
-
DB_FETCHMODE_ASSOC
-
Column data indexed by column names
-
DB_FETCHMODE_DEFAULT
-
This is a special constant that tells DB the user hasn't specified any particular get mode, so the default should be used.
-
DB_FETCHMODE_FLIPPED
-
For multi-dimensional results: normally the first level of arrays is the row number, and the second level indexed by column number or name.
-
DB_FETCHMODE_OBJECT
-
Column data as object properties
-
DB_FETCHMODE_ORDERED
-
Column data indexed by numbers, ordered from 0 and up
-
DB_GETMODE_ASSOC
-
-
DB_GETMODE_FLIPPED
-
-
DB_GETMODE_ORDERED
-
-
DB_ibase
-
-
DB_ibase
-
Database independent query interface definition for PHP's Interbase extension.
-
DB_ifx
-
-
DB_ifx
-
Database independent query interface definition for PHP's Informix extension.
-
DB_msql
-
Database independent query interface definition for PHP's Mini-SQL extension.
-
DB_msql
-
-
DB_mssql
-
-
DB_mssql
-
Database independent query interface definition for PHP's Microsoft SQL Server extension.
-
DB_mysql
-
Database independent query interface definition for PHP's MySQL extension.
-
DB_mysql
-
DB_mysql constructor.
-
DB_mysqli
-
Database independent query interface definition for PHP's mysqli extension.
-
DB_mysqli
-
DB_mysql constructor.
-
DB_oci8
-
Database independent query interface definition for PHP's Oracle 8 call-interface extension.
-
DB_oci8
-
-
DB_odbc
-
Database independent query interface definition for PHP's ODBC extension.
-
DB_odbc
-
-
DB_OK
-
-
DB_PARAM_MISC
-
-
DB_PARAM_OPAQUE
-
-
DB_PARAM_SCALAR
-
-
DB_pgsql
-
Database independent query interface definition for PHP's PostgreSQL extension.
-
DB_pgsql
-
-
DB_PORTABILITY_ALL
-
Portability: turn on all portability features.
-
DB_PORTABILITY_DELETE_COUNT
-
Portability: force reporting the number of rows deleted.
-
DB_PORTABILITY_ERRORS
-
Portability: makes certain error messages in certain drivers compatible with those from other DBMS's.
-
DB_PORTABILITY_LOWERCASE
-
Portability: convert names of tables and fields to lower case when using the get*(), fetch*() and tableInfo() methods.
-
DB_PORTABILITY_NONE
-
Portability: turn off all portability features.
-
DB_PORTABILITY_NULL_TO_EMPTY
-
Portability: convert null values to empty strings in data output by get*() and fetch*().
-
DB_PORTABILITY_NUMROWS
-
Portability: enable hack that makes numRows() work in Oracle.
-
DB_PORTABILITY_RTRIM
-
Portability: right trim the data output by get*() and fetch*().
-
DB_result
-
DB_result constructor.
-
DB_result
-
This class implements a wrapper for a DB result set.
-
DB_sqlite
-
Constructor for this class.
-
DB_sqlite
-
Database independent query interface definition for the SQLite PECL extension.
-
DB_storage
-
Constructor
-
DB_storage
-
Provides an object interface to a table row.
-
DB_sybase
-
DB_sybase constructor.
-
DB_sybase
-
Database independent query interface definition for PHP's Sybase extension.
-
DB_TABLEINFO_FULL
-
-
DB_TABLEINFO_ORDER
-
these are constants for the tableInfo-function
-
DB_TABLEINFO_ORDERTABLE
-
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
-
disconnect
-
-
disconnect
-
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
Log out and disconnect from the database.
-
disconnect
-
-
disconnect
-
Log out and disconnect from the database.
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Drop a sequence
-
dropSequence
-
Deletes a sequence
-
dropSequence
-
Drop a sequence
-
dump
-
Dump the contents of this object to "standard output".
-
dbase.php
-
-
DB.php
-
-
$errorcode_map
-
assoc mapping native error codes to DB ones
-
errorCode
-
Determine PEAR::DB error code from the database's text error message.
-
errorCode
-
Determine PEAR::DB error code from the database's text error message.
-
errorCode
-
Determine PEAR::DB error code from mssql's native codes.
-
errorCode
-
Determine PEAR::DB error code from the database's text error message.
-
errorCode
-
Map native error codes to DB's portable ones.
-
errorCode
-
Map native error codes to DB's portable ones
-
errorMessage
-
Return a textual error message for a DB error code
-
errorMessage
-
Map a DB error code to a textual message. This is actually just a wrapper for DB::errorMessage()
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection. This does not work, as OCIError does not work unless given a statement. If OCIError does return something, so will this.
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection.
-
errorNative
-
Get the last server error messge (if any)
-
errorNative
-
Get the native error string of the last error (if any) that occured on the current connection.
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection.
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection.
-
errorNative
-
Determine MS SQL Server error code by querying @@ERROR.
-
errorNative
-
Returns an errormessage, provides by the database
-
errorNative
-
Get the native error message of the last error (if any) that occured on the current connection.
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection.
-
errorNative
-
Get the native error code of the last error (if any) that occured on the current connection.
-
escapeSimple
-
Escape a string according to the current DBMS's standards
-
escapeSimple
-
Escape a string according to the current DBMS's standards
-
escapeSimple
-
Escape a string according to the current DBMS's standards
-
escapeSimple
-
Escape a string according to the current DBMS's standards
-
escapeSimple
-
Escape a string according to the current DBMS's standards
-
execute
-
Executes a DB statement prepared with prepare().
-
execute
-
Executes a DB statement prepared with prepare().
-
execute
-
Executes a DB statement prepared with prepare()
-
executeEmulateQuery
-
Emulates the execute statement, when not supported
-
executeMultiple
-
This function does several execute() calls on the same statement handle
-
$features
-
assoc of capabilities for this DB implementation
-
$fetchmode
-
-
$fetchmode
-
-
$fetchmode
-
-
$fetchmode
-
-
$fetchmode
-
-
$fetchmode
-
-
$fetchmode_object_class
-
-
factory
-
Create a new DB object for the specified database type.
-
fbsqlRaiseError
-
Gather information about an error, then use that info to create a DB error object and finally return that object.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchInto
-
Fetch a row of data into an array which is passed by reference.
-
fetchInto
-
Fetch a row and insert the data into an existing array.
-
fetchRow
-
Fetch a row of data and return it by reference into an array.
-
free
-
Frees the resources allocated for this result set.
-
freePrepared
-
Free the internal resources associated with a prepared query.
-
freePrepared
-
Free the internal resources associated with a prepared query.
-
freePrepared
-
Free the resource used in a prepared query
-
freeQuery
-
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
-
freeResult
-
-
freeResult
-
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
Free the internal resources associated with $result.
-
freeResult
-
Free the internal resources associated with $result.
-
fbsql.php
-
-
get
-
Fetch an attribute value.
-
getAll
-
Fetch all the rows returned from a query
-
getAssoc
-
Fetch the entire result set of a query and return it as an associative array using the first column as the key
-
getCol
-
Fetch a single column from a result set and return it as an indexed array
-
getDbFileStats
-
Get the file stats for the current database.
-
getListOf
-
list internal DB info valid values for $type are db dependent, often: databases, users, view, functions
-
getOne
-
Fetch the first column of the first row of data returned from a query
-
getOption
-
Returns the value of an option
-
getRow
-
Fetch the first row of data returned from a query
-
getRowCounter
-
returns the actual row number
-
getSequenceName
-
Generate the name used inside the database for a sequence
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info.
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info.
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getSpecialQuery
-
Returns the query needed to get some backend info
-
getTables
-
-
$num_rows
-
-
$num_rows
-
-
$num_rows
-
-
$num_rows
-
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextId
-
Returns the next free id in a sequence
-
nextResult
-
Move the internal odbc result pointer to the next available result
-
nextResult
-
Move the internal sqlite result pointer to the next available result.
-
nextResult
-
Move the internal sybase result pointer to the next available result
-
nextResult
-
Move the internal pgsql result pointer to the next available result
-
nextResult
-
Move the internal mssql result pointer to the next available result
-
nextResult
-
Move the internal oracle result pointer to the next available result
-
nextResult
-
Move the internal mysql result pointer to the next available result.
-
nextResult
-
Move the internal mysql result pointer to the next available result
-
nextResult
-
Get the next result if a batch of queries was executed.
-
nextResult
-
Move the internal fbsql result pointer to the next available result
-
nextResult
-
Move the internal ibase result pointer to the next available result
-
nextResult
-
Move the internal msql result pointer to the next available result
-
nextResult
-
Move the internal ifx result pointer to the next available result
-
numCols
-
Gets the number of columns in a result set.
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
Get the the number of columns in a result set.
-
numCols
-
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
-
numCols
-
-
numCols
-
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
Get the number of columns in a result set.
-
numCols
-
Get the number of columns in a result set.
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
Gets the number of rows affected by a query.
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
Returns the number of rows in a result object
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
-
numRows
-
-
numRows
-
-
numRows
-
Get the number of rows in a result set.
-
numRows
-
ODBC may or may not support counting rows in the result set of SELECTs.
-
numRows
-
-
numRows
-
-
query
-
Send a query to the database and return any results with a DB_result object
-
query
-
-
quote
-
-
quote
-
-
quote
-
DEPRECATED: Quotes a string so it can be safely used in a query
-
quote
-
-
quoteIdentifier
-
Quote a string so it can be safely used as a table or column name
-
quoteIdentifier
-
Quote a string so it can be safely used as a table / column name
-
quoteIdentifier
-
Quote a string so it can be safely used as a table / column name
-
quoteIdentifier
-
Quote a string so it can be safely used as a table or column name
-
quoteIdentifier
-
Quote a string so it can be safely used as a table / column name
-
quoteIdentifier
-
Quote a string so it can be safely used as a table or column name
-
quoteSmart
-
Format input so it can be safely used in a query
-
quoteSmart
-
Format input so it can be safely used in a query
-
quoteSmart
-
Format input so it can be safely used in a query
-
quoteSmart
-
Format input so it can be safely used in a query
-
quoteString
-
DEPRECATED: Quotes a string so it can be safely used within string delimiters in a query
-
sqlite.php
-
-
storage.php
-
-
sybase.php
-
-
set
-
Modify an attriute value.
-
setFetchMode
-
Sets which fetch mode should be used by default on queries on this connection
-
setOption
-
-
setOption
-
Set run-time configuration options for PEAR DB
-
setup
-
Method used to initialize a DB_storage object from the configured table.
-
simpleQuery
-
Send a query to PostgreSQL and return the results as a PostgreSQL resource identifier.
-
simpleQuery
-
Send a query to Sybase and return the results as a Sybase resource identifier.
-
simpleQuery
-
Send a query to SQLite and returns the results as a SQLite resource identifier.
-
simpleQuery
-
Send a query to ODBC and return the results as a ODBC resource identifier.
-
simpleQuery
-
Send a query to Informix and return the results as a Informix resource identifier.
-
simpleQuery
-
-
simpleQuery
-
Send a query to fbsql and return the results as a fbsql resource identifier.
-
simpleQuery
-
Send a query to oracle and return the results as an oci8 resource identifier.
-
simpleQuery
-
-
simpleQuery
-
-
simpleQuery
-
Send a query to MySQL and return the results as a MySQL resource identifier.
-
simpleQuery
-
Send a query to MySQL and return the results as a MySQL resource identifier.
-
sqliteRaiseError
-
Gather information about an error, then use that info to create a DB error object and finally return that object.
-
store
-
Stores changes to this object in the database.
-
sybaseRaiseError
-
Gather information about an error, then use that info to create a DB error object and finally return that object.