Docs For Class DB

Class DB

Description

Database independent query interface

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.

The object model of DB is as follows (indentation means inheritance):

 DB           The main DB class.  This is simply a utility class
              with some "static" methods for creating DB objects as
              well as common utility functions for other DB classes.

 DB_common    The base for each DB implementation.  Provides default
 |            implementations (in OO lingo virtual methods) for
 |            the actual DB implementations as well as a bunch of
 |            query utility functions.
 |
 +-DB_mysql   The DB implementation for MySQL.  Inherits DB_common.
              When calling DB::factory or DB::connect for MySQL
              connections, the object returned is an instance of this
              class.

version: Release: 1.7.6
link: http://pear.php.net/package/DB
license: PHP License 3.0
copyright: 1997-2005 The PHP Group
author: Tomas V.V.Cox <cox@idecnet.com>
author: Stig Bakken <ssb@php.net>
author: Daniel Convissor <danielc@php.net>

Located in /DB.php (line 431)

Method Summary

string apiVersion ()

object a &connect (mixed $dsn, [array $options = array()])

string errorMessage (integer $value)

object a &factory (string $type, [array $options = false])

bool isConnection (mixed $value)

bool isError (mixed $value)

boolean isManip (string $query)

array parseDSN (string $dsn)

Methods

apiVersion (line 572)

Return the DB API version

return: the DB API version number

string apiVersion ()

connect (line 517)

Create a new DB object including a connection to the specified database

Example 1.

require_once 'DB.php';
$dsn = 'pgsql://user:password@host/database';
$options = array(
'debug' => 2,
'portability' => DB_PORTABILITY_ALL,
);
$db =& DB::connect($dsn, $options);
if (PEAR::isError($db)) {
die($db->getMessage());
}

return: new DB object. A DB_Error object on failure.
uses: DB_dbase::connect(), - DB_fbsql::connect(), DB_ibase::connect(), DB_ifx::connect(), DB_msql::connect(), DB_mssql::connect(), DB_mysql::connect(), DB_mysqli::connect(), DB_oci8::connect(), DB_odbc::connect(), DB_pgsql::connect(), DB_sqlite::connect(), DB_sybase::connect()
uses: DB::parseDSN(), - DB_common::setOption(), PEAR::isError()

object a &connect (mixed $dsn, [array $options = array()])

mixed $dsn: the string "data source name" or array in the format returned by DB::parseDSN()
array $options: an associative array of option names and values

errorMessage (line 649)

Return a textual error message for a DB error code

return: the error message or false if the error code was not recognized

string errorMessage (integer $value)

integer $value: the DB error code

factory (line 446)

Create a new DB object for the specified database type but don't connect to the database

return: new DB object. A DB_Error object on failure.
see: DB_common::setOption()

object a &factory (string $type, [array $options = false])

string $type: the database type (eg "mysql")
array $options: an associative array of option names and values

isConnection (line 604)

Determines if a value is a DB_<driver> object

return: whether $value is a DB_<driver> object

bool isConnection (mixed $value)

mixed $value: the value to test

isError (line 587)

Determines if a variable is a DB_Error object

return: whether $value is DB_Error object

bool isError (mixed $value)

mixed $value: the variable to check

isManip (line 625)

Tell whether a query is a data manipulation or data definition query

Examples of data manipulation queries are INSERT, UPDATE and DELETE. Examples of data definition queries are CREATE, DROP, ALTER, GRANT, REVOKE.

return: whether $query is a data manipulation query

boolean isManip (string $query)

string $query: the query

parseDSN (line 730)

Parse a data source name

Additional keys can be added by appending a URI query string to the end of the DSN.

The format of the supplied DSN is in its fullest form:

Most variations are allowed:

phptype://username:password@protocol+hostspec:110//usr/db_file.db?mode=0644
phptype://username:password@hostspec/database_name
phptype://username:password@hostspec
phptype://username@hostspec
phptype://hostspec/database
phptype://hostspec
phptype(dbsyntax)
phptype

return: an associative array with the following keys:
- phptype: Database backend used in PHP (mysql, odbc etc.)
- dbsyntax: Database used with regards to SQL syntax etc.
- protocol: Communication protocol to use (tcp, unix etc.)
- hostspec: Host specification (hostname[:port])
- database: Database to use on the DBMS server
- username: User name for login
- password: Password for login

array parseDSN (string $dsn)

string $dsn: Data Source Name to be parsed

Documentation generated on Wed, 28 Mar 2007 09:54:11 -0600 by phpDocumentor 1.3.1