[DB] element index

Package indexes

All elements
a b c d e f g i l m n o p q r s t _
_
top
Variable $_changes
DB_storage::$_changes in storage.php
an assoc with the names of the properties in this object that
Variable $_data
DB_oci8::$_data in oci8.php
stores the $data passed to execute() in the oci8 driver
Variable $_db
DB_mysql::$_db in mysql.php
Variable $_db
DB_mssql::$_db in mssql.php
Variable $_db
DB_mysqli::$_db in mysqli.php
Variable $_dbh
DB_storage::$_dbh in storage.php
DB connection handle used for all transactions
Variable $_keycolumn
which column(s) in the table contains primary keys, can be a
Variable $_lasterror
Variable $_properties
an assoc with the names of database fields stored as properties
Variable $_readonly
DB_storage::$_readonly in storage.php
flag that decides if data in this object can be changed.
Variable $_table
DB_storage::$_table in storage.php
the name of the table (or view, if the backend database supports
Variable $_validator
function or method that implements a validator for fields that
Method _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.
Method _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.
Method _BCsequence
Backwards compatibility with old sequence emulation implementation (clean up the dupes).
Method _BCsequence
Backwards compatibility with old sequence emulation implementation (clean up the dupes)
Method _convertNullArrayValuesToEmpty
Convert all null values in an array to empty strings
Method _DB_storage
Destructor, calls DB_storage::store() if there are changes that are to be kept.
Method _ibaseFieldFlags
get the Flags of a Field
Method _makeWhere
Utility method to build a "WHERE" clause to locate ourselves in the table.
Method _modifyQuery
"DELETE FROM table" gives 0 affected rows in SQLite.
Method _mssql_field_flags
Get the flags for a field, currently supports "not_null", "primary_key",
Method _pgFieldFlags
Flags of a Field
Method _rtrimArrayValues
Right trim all strings in an array
Method _sybase_field_flags
Get the flags for a field.
a
top
Variable $affected
Variable $affected
DB_pgsql::$affected in pgsql.php
Variable $autocommit
Variable $autocommit
Variable $autocommit
Variable $autoCommit
Variable $autocommit
Variable $autocommit
Variable $autocommit
Variable $autocommit
Method affectedRows
Gets the number of rows affected by the last query.
Method affectedRows
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
Method affectedRows
Returns the number of rows affected by a manipulative query
Method affectedRows
Gets the number of rows affected by a query.
Method affectedRows
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
Method affectedRows
Returns the affected rows of a query
Method affectedRows
Gets the number of rows affected by the last query.
Method affectedRows
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
Method affectedRows
Gets the number of rows affected by the last query.
Method affectedRows
Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0.
Method affectedRows
Gets the number of rows affected by a query.
Method affectedRows
Gets the number of rows affected by the last query.
Method apiVersion
Return the DB API version
Method assertExtension
Load a PHP database extension if it is not loaded already.
Method autoCommit
Enable/disable automatic commits
Method autoCommit
Enable/disable automatic commits
Method autoCommit
enable automatic Commit
Method autoCommit
Enable/disable automatic commits
Method autoCommit
Method autoCommit
Method autoCommit
Enable/disable automatic commits.
Method autoCommit
Method autoCommit
Enable/disable automatic commits
Method autoCommit
Enable/disable automatic commits
Method autoCommit
Enable/disable automatic commits
Method autoExecute
Automaticaly generate an insert or update query and call prepare() and execute() with it
Method autoPrepare
Automaticaly generate an insert or update query and pass it to prepare()
b
top
Method buildManipSQL
Make automaticaly an sql query for prepare()
c
top
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Variable $connection
Method commit
DB_sybase::commit() in sybase.php
Commit the current transaction.
Method commit
DB_odbc::commit() in odbc.php
Method commit
DB_mysql::commit() in mysql.php
Commit the current transaction.
Method commit
DB_oci8::commit() in oci8.php
Commit transactions on the current connection
Method commit
DB_mysqli::commit() in mysqli.php
Commit the current transaction.
Method commit
DB_common::commit() in common.php
starts a Commit
Method commit
DB_pgsql::commit() in pgsql.php
Commit the current transaction.
Method commit
DB_mssql::commit() in mssql.php
Commit the current transaction.
Method commit
DB_fbsql::commit() in fbsql.php
Method commit
DB_ifx::commit() in ifx.php
Commit the current transaction.
Method commit
DB_ibase::commit() in ibase.php
Method connect
DB_odbc::connect() in odbc.php
Connect to a database and log in as the specified user.
Method connect
DB_sybase::connect() in sybase.php
Connect to a database and log in as the specified user.
Method connect
DB_pgsql::connect() in pgsql.php
Connect to a database and log in as the specified user.
Method connect
DB_oci8::connect() in oci8.php
Connect to a database and log in as the specified user.
Method connect
DB_sqlite::connect() in sqlite.php
Connect to a database represented by a file.
Method connect
DB_mysql::connect() in mysql.php
Connect to a database and log in as the specified user.
Method connect
DB_msql::connect() in msql.php
Method connect
Connect to a database and log in as the specified user.
Method connect
DB_ibase::connect() in ibase.php
Method connect
DB_fbsql::connect() in fbsql.php
Connect to a database and log in as the specified user.
Method connect
DB_dbase::connect() in dbase.php
Method connect
DB_mssql::connect() in mssql.php
Method connect
DB_mysqli::connect() in mysqli.php
Connect to a database and log in as the specified user.
Method connect
DB::connect() in DB.php
Create a new DB object and connect to the specified database.
Method create
DB_storage::create() in storage.php
Static method used to create new DB storage objects.
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Method createSequence
Create the sequence
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Method createSequence
Create the sequence
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Method createSequence
Creates a new sequence
Page common.php
common.php in common.php
d
top
Variable $dbh
DB_common::$dbh in common.php
DB handle
Variable $dbh
DB_result::$dbh in DB.php
Variable $dbsyntax
DB_dbase::$dbsyntax in dbase.php
Variable $dbsyntax
DB_ibase::$dbsyntax in ibase.php
Variable $dbsyntax
DB_oci8::$dbsyntax in oci8.php
Variable $dbsyntax
DB_fbsql::$dbsyntax in fbsql.php
Variable $dbsyntax
DB_msql::$dbsyntax in msql.php
Variable $dbsyntax
DB_odbc::$dbsyntax in odbc.php
Variable $dbsyntax
DB_mysqli::$dbsyntax in mysqli.php
Variable $dbsyntax
DB_mysql::$dbsyntax in mysql.php
Variable $dbsyntax
DB_mssql::$dbsyntax in mssql.php
Variable $dbsyntax
DB_pgsql::$dbsyntax in pgsql.php
Variable $dbsyntax
DB_sqlite::$dbsyntax in sqlite.php
Variable $dbsyntax
DB_sybase::$dbsyntax in sybase.php
Variable $dsn
DB_ifx::$dsn in ifx.php
Variable $dsn
DB_pgsql::$dsn in pgsql.php
Class DB
DB in DB.php
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.
Constant DB_AUTOQUERY_INSERT
Constant DB_AUTOQUERY_UPDATE
Constant DB_BINMODE_CONVERT
Constant DB_BINMODE_PASSTHRU
Constant DB_BINMODE_RETURN
Class DB_common
DB_common in common.php
DB_common is a base class for DB implementations, and must be inherited by all such
Method DB_common
Constructor
Class DB_dbase
DB_dbase in dbase.php
Database independent query interface definition for PHP's dbase extension.
Method DB_dbase
DB_mysql constructor.
Constant DB_ERROR
DB_ERROR in DB.php
Class DB_Error
DB_Error in DB.php
DB_Error implements a class for reporting portable database error messages.
Method DB_Error
DB_Error constructor.
Constant DB_ERROR_ACCESS_VIOLATION
Constant DB_ERROR_ALREADY_EXISTS
Constant DB_ERROR_CANNOT_CREATE
Constant DB_ERROR_CANNOT_DELETE
Constant DB_ERROR_CANNOT_DROP
Constant DB_ERROR_CONNECT_FAILED
Constant DB_ERROR_CONSTRAINT
Constant DB_ERROR_CONSTRAINT_NOT_NULL
Constant DB_ERROR_DIVZERO
Constant DB_ERROR_EXTENSION_NOT_FOUND
Constant DB_ERROR_INVALID
Constant DB_ERROR_INVALID_DATE
Constant DB_ERROR_INVALID_DSN
Constant DB_ERROR_INVALID_NUMBER
Constant DB_ERROR_MISMATCH
Constant DB_ERROR_NEED_MORE_DATA
Constant DB_ERROR_NODBSELECTED
Constant DB_ERROR_NOSUCHDB
Constant DB_ERROR_NOSUCHFIELD
Constant DB_ERROR_NOSUCHTABLE
Constant DB_ERROR_NOT_CAPABLE
Constant DB_ERROR_NOT_FOUND
Constant DB_ERROR_NOT_LOCKED
Constant DB_ERROR_SYNTAX
DB_ERROR_SYNTAX in DB.php
Constant DB_ERROR_TRUNCATED
Constant DB_ERROR_UNSUPPORTED
Constant DB_ERROR_VALUE_COUNT_ON_ROW
Method DB_fbsql
DB_fbsql constructor.
Class DB_fbsql
DB_fbsql in fbsql.php
Database independent query interface definition for PHP's FrontBase extension.
Constant DB_FETCHMODE_ASSOC
Column data indexed by column names
Constant 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.
Constant 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.
Constant DB_FETCHMODE_OBJECT
Column data as object properties
Constant DB_FETCHMODE_ORDERED
Column data indexed by numbers, ordered from 0 and up
Constant DB_GETMODE_ASSOC
Constant DB_GETMODE_FLIPPED
Constant DB_GETMODE_ORDERED
Method DB_ibase
Class DB_ibase
DB_ibase in ibase.php
Database independent query interface definition for PHP's Interbase extension.
Method DB_ifx
DB_ifx::DB_ifx() in ifx.php
Class DB_ifx
DB_ifx in ifx.php
Database independent query interface definition for PHP's Informix extension.
Class DB_msql
DB_msql in msql.php
Database independent query interface definition for PHP's Mini-SQL extension.
Method DB_msql
DB_msql::DB_msql() in msql.php
Method DB_mssql
Class DB_mssql
DB_mssql in mssql.php
Database independent query interface definition for PHP's Microsoft SQL Server extension.
Class DB_mysql
DB_mysql in mysql.php
Database independent query interface definition for PHP's MySQL extension.
Method DB_mysql
DB_mysql constructor.
Class DB_mysqli
DB_mysqli in mysqli.php
Database independent query interface definition for PHP's mysqli extension.
Method DB_mysqli
DB_mysql constructor.
Class DB_oci8
DB_oci8 in oci8.php
Database independent query interface definition for PHP's Oracle 8 call-interface extension.
Method DB_oci8
DB_oci8::DB_oci8() in oci8.php
Class DB_odbc
DB_odbc in odbc.php
Database independent query interface definition for PHP's ODBC extension.
Method DB_odbc
DB_odbc::DB_odbc() in odbc.php
Constant DB_OK
DB_OK in DB.php
Constant DB_PARAM_MISC
DB_PARAM_MISC in DB.php
Constant DB_PARAM_OPAQUE
DB_PARAM_OPAQUE in DB.php
Constant DB_PARAM_SCALAR
DB_PARAM_SCALAR in DB.php
Class DB_pgsql
DB_pgsql in pgsql.php
Database independent query interface definition for PHP's PostgreSQL extension.
Method DB_pgsql
Constant DB_PORTABILITY_ALL
Portability: turn on all portability features.
Constant DB_PORTABILITY_DELETE_COUNT
Portability: force reporting the number of rows deleted.
Constant DB_PORTABILITY_ERRORS
Portability: makes certain error messages in certain drivers compatible with those from other DBMS's.
Constant DB_PORTABILITY_LOWERCASE
Portability: convert names of tables and fields to lower case when using the get*(), fetch*() and tableInfo() methods.
Constant DB_PORTABILITY_NONE
Portability: turn off all portability features.
Constant DB_PORTABILITY_NULL_TO_EMPTY
Portability: convert null values to empty strings in data output by get*() and fetch*().
Constant DB_PORTABILITY_NUMROWS
Portability: enable hack that makes numRows() work in Oracle.
Constant DB_PORTABILITY_RTRIM
Portability: right trim the data output by get*() and fetch*().
Method DB_result
DB_result constructor.
Class DB_result
DB_result in DB.php
This class implements a wrapper for a DB result set.
Method DB_sqlite
Constructor for this class.
Class DB_sqlite
DB_sqlite in sqlite.php
Database independent query interface definition for the SQLite PECL extension.
Method DB_storage
Constructor
Class DB_storage
DB_storage in storage.php
Provides an object interface to a table row.
Method DB_sybase
DB_sybase constructor.
Class DB_sybase
DB_sybase in sybase.php
Database independent query interface definition for PHP's Sybase extension.
Constant DB_TABLEINFO_FULL
Constant DB_TABLEINFO_ORDER
these are constants for the tableInfo-function
Constant DB_TABLEINFO_ORDERTABLE
Method disconnect
Log out and disconnect from the database.
Method disconnect
Log out and disconnect from the database.
Method disconnect
Method disconnect
Log out and disconnect from the database.
Method disconnect
Log out and disconnect from the database.
Method disconnect
Log out and disconnect from the database.
Method disconnect
Method disconnect
Method disconnect
Method disconnect
Log out and disconnect from the database.
Method disconnect
Log out and disconnect from the database.
Method disconnect
Method disconnect
Log out and disconnect from the database.
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Drop a sequence
Method dropSequence
Deletes a sequence
Method dropSequence
Drop a sequence
Method dump
DB_storage::dump() in storage.php
Dump the contents of this object to "standard output".
Page dbase.php
dbase.php in dbase.php
Page DB.php
DB.php in DB.php
e
top
Variable $errorcode_map
assoc mapping native error codes to DB ones
Method errorCode
Determine PEAR::DB error code from the database's text error message.
Method errorCode
Determine PEAR::DB error code from the database's text error message.
Method errorCode
Determine PEAR::DB error code from mssql's native codes.
Method errorCode
Determine PEAR::DB error code from the database's text error message.
Method errorCode
Map native error codes to DB's portable ones.
Method errorCode
Map native error codes to DB's portable ones
Method errorMessage
Return a textual error message for a DB error code
Method errorMessage
Map a DB error code to a textual message. This is actually just a wrapper for DB::errorMessage()
Method 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.
Method errorNative
Get the native error code of the last error (if any) that occured on the current connection.
Method errorNative
Get the last server error messge (if any)
Method errorNative
Get the native error string of the last error (if any) that occured on the current connection.
Method errorNative
Get the native error code of the last error (if any) that occured on the current connection.
Method errorNative
Get the native error code of the last error (if any) that occured on the current connection.
Method errorNative
Determine MS SQL Server error code by querying @@ERROR.
Method errorNative
Returns an errormessage, provides by the database
Method errorNative
Get the native error message of the last error (if any) that occured on the current connection.
Method errorNative
Get the native error code of the last error (if any) that occured on the current connection.
Method errorNative
Get the native error code of the last error (if any) that occured on the current connection.
Method escapeSimple
Escape a string according to the current DBMS's standards
Method escapeSimple
Escape a string according to the current DBMS's standards
Method escapeSimple
Escape a string according to the current DBMS's standards
Method escapeSimple
Escape a string according to the current DBMS's standards
Method escapeSimple
Escape a string according to the current DBMS's standards
Method execute
DB_ibase::execute() in ibase.php
Executes a DB statement prepared with prepare().
Method execute
DB_oci8::execute() in oci8.php
Executes a DB statement prepared with prepare().
Method execute
DB_common::execute() in common.php
Executes a DB statement prepared with prepare()
Method executeEmulateQuery
Emulates the execute statement, when not supported
Method executeMultiple
This function does several execute() calls on the same statement handle
f
top
Variable $features
DB_common::$features in common.php
assoc of capabilities for this DB implementation
Variable $fetchmode
DB_common::$fetchmode in common.php
Variable $fetchmode
Variable $fetchmode
Variable $fetchmode
Variable $fetchmode
DB_mysqli::$fetchmode in mysqli.php
Variable $fetchmode
Variable $fetchmode_object_class
Method factory
DB::factory() in DB.php
Create a new DB object for the specified database type.
Method fbsqlRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchInto
Fetch a row of data into an array which is passed by reference.
Method fetchInto
Fetch a row and insert the data into an existing array.
Method fetchRow
Fetch a row of data and return it by reference into an array.
Method free
Frees the resources allocated for this result set.
Method freePrepared
Free the internal resources associated with a prepared query.
Method freePrepared
Free the internal resources associated with a prepared query.
Method freePrepared
Free the resource used in a prepared query
Method freeQuery
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Method freeResult
Method freeResult
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Free the internal resources associated with $result.
Method freeResult
Free the internal resources associated with $result.
Page fbsql.php
fbsql.php in fbsql.php
g
top
Method get
DB_storage::get() in storage.php
Fetch an attribute value.
Method getAll
DB_common::getAll() in common.php
Fetch all the rows returned from a query
Method getAssoc
DB_common::getAssoc() in common.php
Fetch the entire result set of a query and return it as an associative array using the first column as the key
Method getCol
DB_common::getCol() in common.php
Fetch a single column from a result set and return it as an indexed array
Method getDbFileStats
Get the file stats for the current database.
Method getListOf
list internal DB info valid values for $type are db dependent, often: databases, users, view, functions
Method getOne
DB_common::getOne() in common.php
Fetch the first column of the first row of data returned from a query
Method getOption
Returns the value of an option
Method getRow
DB_common::getRow() in common.php
Fetch the first row of data returned from a query
Method getRowCounter
returns the actual row number
Method getSequenceName
Generate the name used inside the database for a sequence
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info.
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info.
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info
Method getSpecialQuery
Returns the query needed to get some backend info
Method getTables
i
top
Method ibaseRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method ifxraiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method insert
DB_storage::insert() in storage.php
Create a new (empty) row in the configured table for this object.
Method isConnection
Tell whether a value is a DB connection
Method isError
DB::isError() in DB.php
Tell whether a result code from a DB method is an error
Method isManip
DB::isManip() in DB.php
Tell whether a query is a data manipulation query (insert, update or delete) or a data definition query (create, drop, alter, grant, revoke).
Page ibase.php
ibase.php in ibase.php
Page ifx.php
ifx.php in ifx.php
l
top
Variable $last_query
Variable $last_stmt
Variable $limit_count
for limit queries, the number of rows to fetch
Variable $limit_from
for limit queries, the row to start fetching
Method limitQuery
Generates a limited query
m
top
Variable $manip_query
Variable $manip_query
Variable $mysqli_flags
Array for converting MYSQLI_*_FLAG constants to text values
Variable $mysqli_types
Array for converting MYSQLI_TYPE_* constants to text values
Page msql.php
msql.php in msql.php
Page mssql.php
mssql.php in mssql.php
Page mysqli.php
mysqli.php in mysqli.php
Page mysql.php
mysql.php in mysql.php
Method modifyLimitQuery
This method is used by backends to alter limited queries Uses the new FIRST n SKIP n Firebird 1.0 syntax, so it is only compatible with Firebird 1.x
Method modifyLimitQuery
Method modifyLimitQuery
Method modifyLimitQuery
This method is used by backends to alter limited queries
Method modifyLimitQuery
Method modifyLimitQuery
Method modifyLimitQuery
Emulate the row limit support altering the query
Method modifyQuery
Method modifyQuery
Method modifyQuery
Method modifyQuery
Method modifyQuery
This method is used by backends to alter queries for various reasons
Method mssqlRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method mysqlRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method mysqlRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
n
top
Variable $num_rows
DB_pgsql::$num_rows in pgsql.php
Variable $num_rows
DB_mysqli::$num_rows in mysqli.php
Variable $num_rows
DB_mysql::$num_rows in mysql.php
Variable $num_rows
DB_fbsql::$num_rows in fbsql.php
Method nextId
DB_odbc::nextId() in odbc.php
Returns the next free id in a sequence
Method nextId
DB_ibase::nextId() in ibase.php
Returns the next free id in a sequence
Method nextId
DB_mssql::nextId() in mssql.php
Returns the next free id in a sequence
Method nextId
DB_oci8::nextId() in oci8.php
Returns the next free id in a sequence
Method nextId
DB_common::nextId() in common.php
Returns the next free id in a sequence
Method nextId
DB_sybase::nextId() in sybase.php
Returns the next free id in a sequence
Method nextId
DB_mysql::nextId() in mysql.php
Returns the next free id in a sequence
Method nextId
DB_pgsql::nextId() in pgsql.php
Returns the next free id in a sequence
Method nextId
DB_mysqli::nextId() in mysqli.php
Returns the next free id in a sequence
Method nextId
DB_fbsql::nextId() in fbsql.php
Returns the next free id in a sequence
Method nextId
DB_sqlite::nextId() in sqlite.php
Returns the next free id in a sequence
Method nextResult
Move the internal odbc result pointer to the next available result
Method nextResult
Move the internal sqlite result pointer to the next available result.
Method nextResult
Move the internal sybase result pointer to the next available result
Method nextResult
Move the internal pgsql result pointer to the next available result
Method nextResult
Move the internal mssql result pointer to the next available result
Method nextResult
Move the internal oracle result pointer to the next available result
Method nextResult
Move the internal mysql result pointer to the next available result.
Method nextResult
Move the internal mysql result pointer to the next available result
Method nextResult
Get the next result if a batch of queries was executed.
Method nextResult
Move the internal fbsql result pointer to the next available result
Method nextResult
Move the internal ibase result pointer to the next available result
Method nextResult
Move the internal msql result pointer to the next available result
Method nextResult
Move the internal ifx result pointer to the next available result
Method numCols
DB_sqlite::numCols() in sqlite.php
Gets the number of columns in a result set.
Method numCols
DB_oci8::numCols() in oci8.php
Get the number of columns in a result set.
Method numCols
DB_mssql::numCols() in mssql.php
Method numCols
DB_fbsql::numCols() in fbsql.php
Get the number of columns in a result set.
Method numCols
Get the the number of columns in a result set.
Method numCols
DB_odbc::numCols() in odbc.php
Method numCols
DB_pgsql::numCols() in pgsql.php
Get the number of columns in a result set.
Method numCols
DB_ibase::numCols() in ibase.php
Method numCols
DB_msql::numCols() in msql.php
Method numCols
DB_dbase::numCols() in dbase.php
Method numCols
Get the number of columns in a result set.
Method numCols
DB_sybase::numCols() in sybase.php
Get the number of columns in a result set.
Method numCols
DB_mysql::numCols() in mysql.php
Get the number of columns in a result set.
Method numCols
DB_mysqli::numCols() in mysqli.php
Get the number of columns in a result set.
Method numRows
Get the number of rows in a result set.
Method numRows
DB_sqlite::numRows() in sqlite.php
Gets the number of rows affected by a query.
Method numRows
DB_sybase::numRows() in sybase.php
Get the number of rows in a result set.
Method numRows
DB_common::numRows() in common.php
Returns the number of rows in a result object
Method numRows
DB_pgsql::numRows() in pgsql.php
Get the number of rows in a result set.
Method numRows
DB_fbsql::numRows() in fbsql.php
Get the number of rows in a result set.
Method numRows
DB_mysql::numRows() in mysql.php
Get the number of rows in a result set.
Method numRows
DB_msql::numRows() in msql.php
Method numRows
DB_mssql::numRows() in mssql.php
Method numRows
Method numRows
DB_mysqli::numRows() in mysqli.php
Get the number of rows in a result set.
Method numRows
DB_odbc::numRows() in odbc.php
ODBC may or may not support counting rows in the result set of SELECTs.
Method numRows
DB_oci8::numRows() in oci8.php
Method numRows
DB_dbase::numRows() in dbase.php
o
top
Variable $options
DB_common::$options in common.php
Run-time configuration options.
Page oci8.php
oci8.php in oci8.php
Page odbc.php
odbc.php in odbc.php
Method oci8RaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method odbcRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
p
top
Variable $phptype
DB_common::$phptype in common.php
DB type (mysql, oci8, odbc etc.)
Variable $phptype
DB_mssql::$phptype in mssql.php
Variable $phptype
DB_msql::$phptype in msql.php
Variable $phptype
DB_sqlite::$phptype in sqlite.php
Variable $phptype
DB_mysql::$phptype in mysql.php
Variable $phptype
DB_pgsql::$phptype in pgsql.php
Variable $phptype
DB_oci8::$phptype in oci8.php
Variable $phptype
DB_odbc::$phptype in odbc.php
Variable $phptype
DB_mysqli::$phptype in mysqli.php
Variable $phptype
DB_fbsql::$phptype in fbsql.php
Variable $phptype
DB_ibase::$phptype in ibase.php
Variable $phptype
DB_sybase::$phptype in sybase.php
Variable $phptype
DB_dbase::$phptype in dbase.php
Variable $prepared_queries
Variable $prepare_maxstmt
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_tokens
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Variable $prepare_types
Page pgsql.php
pgsql.php in pgsql.php
Method parseDSN
DB::parseDSN() in DB.php
Parse a data source name.
Method pgsqlRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method prepare
DB_common::prepare() in common.php
Prepares a query for multiple execution with execute()
Method prepare
DB_oci8::prepare() in oci8.php
Prepares a query for multiple execution with execute().
Method prepare
DB_ibase::prepare() in ibase.php
Prepares a query for multiple execution with execute().
Method provides
DB_common::provides() in common.php
Tell whether a DB implementation or its backend extension supports a given feature
q
top
Method query
DB_common::query() in common.php
Send a query to the database and return any results with a DB_result object
Method query
DB_dbase::query() in dbase.php
Method quote
DB_odbc::quote() in odbc.php
Method quote
DB_pgsql::quote() in pgsql.php
Method quote
DB_common::quote() in common.php
DEPRECATED: Quotes a string so it can be safely used in a query
Method quote
DB_mysql::quote() in mysql.php
Method quoteIdentifier
Quote a string so it can be safely used as a table or column name
Method quoteIdentifier
Quote a string so it can be safely used as a table / column name
Method quoteIdentifier
Quote a string so it can be safely used as a table / column name
Method quoteIdentifier
Quote a string so it can be safely used as a table or column name
Method quoteIdentifier
Quote a string so it can be safely used as a table / column name
Method quoteIdentifier
Quote a string so it can be safely used as a table or column name
Method quoteSmart
Format input so it can be safely used in a query
Method quoteSmart
Format input so it can be safely used in a query
Method quoteSmart
Format input so it can be safely used in a query
Method quoteSmart
Format input so it can be safely used in a query
Method quoteString
DEPRECATED: Quotes a string so it can be safely used within string delimiters in a query
r
top
Variable $result
DB_dbase::$result in dbase.php
Variable $result
Variable $res_row
DB_dbase::$res_row in dbase.php
Variable $row
DB_pgsql::$row in pgsql.php
Variable $row
DB_odbc::$row in odbc.php
Variable $row_counter
Method raiseError
Communicate an error and invoke error callbacks, etc
Method remove
DB_storage::remove() in storage.php
Remove the row represented by this object from the database.
Method rollback
DB_sybase::rollback() in sybase.php
Roll back (undo) the current transaction.
Method rollback
Roll back (undo) the current transaction.
Method rollback
Roll back (undo) the current transaction.
Method rollback
Method rollback
Method rollback
DB_common::rollback() in common.php
starts a rollback
Method rollback
Roll back (undo) the current transaction.
Method rollback
Roll back (undo) the current transaction.
Method rollback
Roll back all uncommitted transactions on the current connection.
Method rollback
DB_mysqli::rollback() in mysqli.php
Roll back (undo) the current transaction.
Method rollback
s
top
Page sqlite.php
sqlite.php in sqlite.php
Page storage.php
storage.php in storage.php
Page sybase.php
sybase.php in sybase.php
Method set
DB_storage::set() in storage.php
Modify an attriute value.
Method setFetchMode
Sets which fetch mode should be used by default on queries on this connection
Method setOption
Method setOption
Set run-time configuration options for PEAR DB
Method setup
DB_storage::setup() in storage.php
Method used to initialize a DB_storage object from the configured table.
Method simpleQuery
Send a query to PostgreSQL and return the results as a PostgreSQL resource identifier.
Method simpleQuery
Send a query to Sybase and return the results as a Sybase resource identifier.
Method simpleQuery
Send a query to SQLite and returns the results as a SQLite resource identifier.
Method simpleQuery
Send a query to ODBC and return the results as a ODBC resource identifier.
Method simpleQuery
Send a query to Informix and return the results as a Informix resource identifier.
Method simpleQuery
Method simpleQuery
Send a query to fbsql and return the results as a fbsql resource identifier.
Method simpleQuery
Send a query to oracle and return the results as an oci8 resource identifier.
Method simpleQuery
Method simpleQuery
Method simpleQuery
Send a query to MySQL and return the results as a MySQL resource identifier.
Method simpleQuery
Send a query to MySQL and return the results as a MySQL resource identifier.
Method sqliteRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
Method store
DB_storage::store() in storage.php
Stores changes to this object in the database.
Method sybaseRaiseError
Gather information about an error, then use that info to create a DB error object and finally return that object.
t
top
Variable $transaction_opcount
Variable $transaction_opcount
Variable $transaction_opcount
Variable $transaction_opcount
Variable $transaction_opcount
Variable $transaction_opcount
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Method tableInfo
Returns information about a table or a result set
Method tableInfo
Returns information about a table or a result set.
Method tableInfo
Returns information about a table or a result set.
Method toString
DB_common::toString() in common.php
String conversation
Method toString
DB_storage::toString() in storage.php
Output a simple description of this DB_storage object.
Method transactionInit
a b c d e f g i l m n o p q r s t _