DB_sqlite
The methods PEAR DB uses to interact with PHP's sqlite extension for interacting with SQLite databases
These methods overload the ones declared in DB_common.
NOTICE: This driver needs PHP's track_errors ini setting to be on. It is automatically turned on when connecting to the database. Make sure your scripts don't turn it off.
Located in /web/lib/external/pear-db/DB/sqlite.php (line 53)
PEAR | --DB_common | --DB_sqlite
resource
$connection
(line 108)
The raw database connection created by PHP
string
$dbsyntax
= 'sqlite' (line 67)
The database syntax variant to be used (db2, access, etc.), if any
array
$dsn
= array() (line 114)
The DSN information for connecting to a database
array
$errorcode_map
= array() (line 101)
A mapping of native error codes to DB error codes
array
$features
= array('limit' => 'alter',
'new_link' => false,
'numrows' => true,
'pconnect' => true,
'prepare' => false,
'ssl' => false,
'transactions' => false,
) (line 82)
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
array
$keywords
= array ('BLOB' => '',
'BOOLEAN' => '',
'CHARACTER' => '',
'CLOB' => '',
'FLOAT' => '',
'INTEGER' => '',
'KEY' => '',
'NATIONAL' => '',
'NUMERIC' => '',
'NVARCHAR' => '',
'PRIMARY' => '',
'TEXT' => '',
'TIMESTAMP' => '',
'UNIQUE' => '',
'VARCHAR' => '',
'VARYING' => '',
) (line 124)
SQLite data types
string
$phptype
= 'sqlite' (line 61)
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
Connect to the database server, log in and open the database
Don't call this method directly. Use DB::connect() instead.
PEAR DB's sqlite driver supports the following extra DSN options:
- mode The permissions for the database file, in four digit chmod octal format (eg "0600").
- require_once 'DB.php';
- $dsn = 'sqlite:///path/and/name/of/db/file?mode=0400';
- $options = array(
- );
- die($db->getMessage());
- }
- 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
Determines PEAR::DB error code from the database's text error message
- string $errormsg: the error message returned from the database
- DB_common::errorCode()
- Maps native error codes to DB's portable ones
Gets the DBMS' native error message 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
In SQLite, this makes things safe for inserts/updates, but may cause problems when performing text comparisons against columns containing binary data. See the PHP manual for more info.
- 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
- &$result
Get the file stats for the current database
Possible arguments are dev, ino, mode, nlink, uid, gid, rdev, size, atime, mtime, ctime, blksize, blocks or a numeric key between
- and 12.
- string $arg: the array key for stats()
Obtains the query string needed for listing a given type of objects
- string $type: the kind of objects you want to retrieve
- array $args: SQLITE DRIVER ONLY: a private array of arguments used by the getSpecialQuery(). Do not use this directly.
- 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
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 sqlite result pointer to the next available result
- resource $result: the valid sqlite 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
Sends a query to the database server
NOTICE: This method needs PHP's track_errors ini setting to be on. It is automatically turned on when connecting to the database. Make sure your scripts don't turn it off.
- string $query: the SQL query string
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 information about a table
- string $result: a string containing the name of a table
- 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:04:41 +0700 by phpDocumentor 1.4.2