DB_mysql
The methods PEAR DB uses to interact with PHP's mysql extension for interacting with MySQL databases
These methods overload the ones declared in DB_common.
Located in /web/lib/external/pear-db/DB/mysql.php (line 47)
PEAR | --DB_common | --DB_mysql
resource
$connection
(line 123)
The raw database connection created by PHP
string
$dbsyntax
= 'mysql' (line 61)
The database syntax variant to be used (db2, access, etc.), if any
array
$dsn
= array() (line 129)
The DSN information for connecting to a database
array
$errorcode_map
= array(1004 => DB_ERROR_CANNOT_CREATE,
1005 => DB_ERROR_CANNOT_CREATE,
1006 => DB_ERROR_CANNOT_CREATE,
1007 => DB_ERROR_ALREADY_EXISTS,
1008 => DB_ERROR_CANNOT_DROP,
1022 => DB_ERROR_ALREADY_EXISTS,
1044 => DB_ERROR_ACCESS_VIOLATION,
1046 => DB_ERROR_NODBSELECTED,
1048 => DB_ERROR_CONSTRAINT,
1049 => DB_ERROR_NOSUCHDB,
1050 => DB_ERROR_ALREADY_EXISTS,
1051 => DB_ERROR_NOSUCHTABLE,
1054 => DB_ERROR_NOSUCHFIELD,
1061 => DB_ERROR_ALREADY_EXISTS,
1062 => DB_ERROR_ALREADY_EXISTS,
1064 => DB_ERROR_SYNTAX,
1091 => DB_ERROR_NOT_FOUND,
1100 => DB_ERROR_NOT_LOCKED,
1136 => DB_ERROR_VALUE_COUNT_ON_ROW,
1142 => DB_ERROR_ACCESS_VIOLATION,
1146 => DB_ERROR_NOSUCHTABLE,
1216 => DB_ERROR_CONSTRAINT,
1217 => DB_ERROR_CONSTRAINT,
1356 => DB_ERROR_DIVZERO,
1451 => DB_ERROR_CONSTRAINT,
1452 => DB_ERROR_CONSTRAINT,
) (line 90)
A mapping of native error codes to DB error codes
array
$features
= array('limit' => 'alter',
'new_link' => '4.2.0',
'numrows' => true,
'pconnect' => true,
'prepare' => false,
'ssl' => false,
'transactions' => true,
) (line 76)
The capabilities of this DB implementation
The 'new_link' element contains the PHP version that first provided new_link support for this DBMS. Contains false if it's unsupported.
Meaning of the 'limit' element:
- 'emulate' = emulate with fetch row by number
- 'alter' = alter the query
- false = skip rows
string
$phptype
= 'mysql' (line 55)
The DB driver type (mysql, oci8, odbc, etc.)
Inherited Variables
Inherited from DB_common
Determines the number of rows affected by a data maniuplation query
- is returned for queries that don't manipulate data.
- DB_common::affectedRows()
- Determines the number of rows affected by a data maniuplation query
Enables or disables automatic commits
- bool $onoff: true turns it on, false turns it off
- DB_common::autoCommit()
- Enables or disables automatic commits
Commits the current transaction
- DB_common::commit()
- Commits the current transaction
Connect to the database server, log in and open the database
Don't call this method directly. Use DB::connect() instead.
PEAR DB's mysql driver supports the following extra DSN options:
- new_link If set to true, causes subsequent calls to connect() to return a new connection link instead of the existing one. WARNING: this is not portable to other DBMS's. Available since PEAR DB 1.7.0.
- client_flags Any combination of MYSQL_CLIENT_* constants. Only used if PHP is at version 4.3.0 or greater. Available since PEAR DB 1.7.0.
- array $dsn: the data source name
- bool $persistent: should the connection be persistent?
Creates a new sequence
- string $seq_name: name of the new sequence
- DB_common::createSequence()
- Creates a new sequence
Deletes a sequence
- string $seq_name: name of the sequence to be deleted
- DB_common::dropSequence()
- Deletes a sequence
Gets the DBMS' native error code produced by the last query
- DB_common::errorNative()
- Gets the DBMS' native error code produced by the last query
Escapes a string according to the current DBMS's standards
- string $str: the string to be escaped
- DB_common::escapeSimple()
- Escapes a string according to the current DBMS's standards
Places a row from the result set into the given array
Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information.
This method is not meant to be called directly. Use DB_result::fetchInto() instead. It can't be declared "protected" because DB_result is a separate object.
- resource $result: the query result resource
- array $arr: the referenced array to put the data in
- int $fetchmode: how the resulting array should be indexed
- int $rownum: the row number to fetch (0 = first row)
- &$arr
Deletes the result set and frees the memory occupied by the result set
This method is not meant to be called directly. Use DB_result::free() instead. It can't be declared "protected" because DB_result is a separate object.
- resource $result: PHP's query result resource
Obtains the query string needed for listing a given type of objects
- string $type: the kind of objects you want to retrieve
- DB_common::getSpecialQuery()
- Obtains the query string needed for listing a given type of objects
Adds LIMIT clauses to a query string according to current DBMS standards
- string $query: the query to modify
- int $from: the row to start to fetching (0 = the first row)
- int $count: the numbers of rows to fetch
- mixed $params: array, string or numeric data to be used in execution of the statement. Quantity of items passed must match quantity of placeholders in query: meaning 1 placeholder for non-array parameters or 1 placeholder per array element.
- DB_common::modifyLimitQuery()
- Adds LIMIT clauses to a query string according to current DBMS standards
Changes a query string for various DBMS specific reasons
This little hack lets you know how many rows were deleted when running a "DELETE FROM table" query. Only implemented if the DB_PORTABILITY_DELETE_COUNT portability option is on.
- string $query: the query string to modify
- DB_common::modifyQuery()
- Changes a query string for various DBMS specific reasons
Produces a DB_Error object regarding the current problem
- int $errno: if the error is being manually raised pass a DB_ERROR* constant here. If this isn't passed the error information gathered from the DBMS.
Returns the next free id in a sequence
- string $seq_name: name of the sequence
- boolean $ondemand: when true, the seqence is automatically created if it does not exist
- DB_common::nextId()
- Returns the next free id in a sequence
Move the internal mysql result pointer to the next available result
This method has not been implemented yet.
- a $result: valid sql result resource
Gets the number of columns in a result set
This method is not meant to be called directly. Use DB_result::numCols() instead. It can't be declared "protected" because DB_result is a separate object.
- resource $result: PHP's query result resource
Gets the number of rows in a result set
This method is not meant to be called directly. Use DB_result::numRows() instead. It can't be declared "protected" because DB_result is a separate object.
- resource $result: PHP's query result resource
- DB_common::numRows()
- Determines the number of rows in a query result
- $str
- DB_common::quote()
- DEPRECATED: Quotes a string so it can be safely used in a query
Quotes a string so it can be safely used as a table or column name (WARNING: using names that require this is a REALLY BAD IDEA)
WARNING: Older versions of MySQL can't handle the backtick character (`) in table or column names.
- string $str: identifier name to be quoted
- DB_common::quoteIdentifier()
- Quotes a string so it can be safely used as a table or column name
Reverts the current transaction
- DB_common::rollback()
- Reverts the current transaction
Sends a query to the database server
Generally uses mysql_query(). If you want to use mysql_unbuffered_query() set the "result_buffering" option to 0 using setOptions(). This option was added in Release 1.7.0.
- string $query: the SQL query string
Returns information about a table or a result set
- object|string $result: DB_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
- int $mode: a valid tableInfo mode
- DB_common::tableInfo()
- Returns information about a table or a result set
Inherited Methods
Inherited From DB_common
DB_common::DB_common()
DB_common::affectedRows()
Inherited From PEAR
Documentation generated on Wed, 09 Feb 2011 09:02:11 +0700 by phpDocumentor 1.4.2