apidoc

[ ] [ ] [ ]

Packages:
DB

Classes:

DB-1.4.0
   DB_common
   DB_dbase
   DB_fbsql
   DB_ibase
   DB_ifx
   DB_msql
   DB_mssql
   DB_mysql
   DB_oci8
   DB_odbc
   DB_pgsql
   DB_row
   DB_sybase

Class: DB_dbase

Source Location: /DB-1.4.0/DB/dbase.php

Class Overview

PEAR
   |
   --DB_common
      |
      --DB_dbase

Variables

Methods

Inherited Variables

Class: DB_common

DB_common::$dbh
DB_common::$errorcode_map
DB_common::$features
DB_common::$fetchmode
DB_common::$fetchmode_object_class
DB_common::$last_query
DB_common::$options
DB_common::$prepared_queries
DB_common::$prepare_maxstmt
DB_common::$type

Inherited Methods

Class: DB_common

DB_common::DB_common(): Constructor
DB_common::affectedRows(): returns the affected rows of a query
DB_common::autoCommit(): enable automatic Commit
DB_common::autoExecute(): Make automaticaly an insert or update query and call prepare() and execute() with it
DB_common::autoPrepare(): Make automaticaly an insert or update query and call prepare() with it
DB_common::buildManipSQL(): Make automaticaly an sql query for prepare()
DB_common::commit(): starts a Commit
DB_common::createSequence(): creates a new sequence
DB_common::dropSequence(): deletes a sequence
DB_common::errorCode(): Map native error codes to DB's portable ones. Requires that the DB implementation's constructor fills in the $errorcode_map property.
DB_common::errorMessage(): Map a DB error code to a textual message. This is actually just a wrapper for DB::errorMessage().
DB_common::errorNative(): returns an errormessage, provides by the database
DB_common::execute(): Executes a prepared SQL query
DB_common::executeMultiple(): This function does several execute() calls on the same statement handle. $data must be an array indexed numerically from 0, one execute call is done for every "row" in the array.
DB_common::getAll(): Fetch all the rows returned from a query.
DB_common::getAssoc(): Fetch the entire result set of a query and return it as an associative array using the first column as the key.
DB_common::getCol(): Fetch a single column from a result set and return it as an indexed array.
DB_common::getListOf(): list internal DB info valid values for $type are db dependent, often: databases, users, view, functions
DB_common::getOne(): Fetch the first column of the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.
DB_common::getOption(): returns the value of an option
DB_common::getRow(): Fetch the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.
DB_common::getSequenceName()
DB_common::getTables()
DB_common::limitQuery(): Generates a limited query
DB_common::nextId(): returns the next free id of a sequence
DB_common::numRows(): returns the number of rows in a result object
DB_common::prepare(): Prepares a query for multiple execution with execute().
DB_common::provides(): Tell whether a DB implementation or its backend extension supports a given feature.
DB_common::query(): Send a query to the database and return any results with a DB_result object.
DB_common::quote(): Quotes a string so it can be safely used in a query. It will return the string with single quotes around. Other backend quote styles should override this method.
DB_common::quoteString(): Quotes a string so it can be safely used within string delimiters in a query (preserved for compatibility issues, quote() is preffered).
DB_common::raiseError(): This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for PEAR::raiseError without the message string.
DB_common::rollback(): starts a rollback
DB_common::setFetchMode(): Sets which fetch mode should be used by default on queries on this connection.
DB_common::setOption(): set the option for the db class
DB_common::tableInfo(): returns meta data about the result set

Class Details

[line 30]

[ Top ]

Class Variables

$connection =

[line 34]

Type:

mixed

[ Top ]

$dbsyntax =

[line 35]

Type:

mixed

[ Top ]

$phptype =

[line 35]

Type:

mixed

[ Top ]

$prepare_tokens = array()

[line 36]

Type:	mixed
Overrides:	Array

[ Top ]

$prepare_types = array()

[line 37]

Type:	mixed
Overrides:	Array

[ Top ]

$result = 0

[line 40]

Type:

mixed

[ Top ]

$res_row = array()

[line 39]

Type:

mixed

[ Top ]

$transaction_opcount = 0

[line 38]

Type:

mixed

[ Top ]

Method Detail

DB_dbase (Constructor) [line 51]

DB_dbase DB_dbase(
)

DB_mysql constructor.

Access: public

[ Top ]

connect [line 68]

void connect(
mixed
$dsninfo, [mixed
$persistent = false])

[ Top ]

disconnect [line 89]

void disconnect(
)

[ Top ]

fetchInto [line 109]

void fetchInto(
mixed
$res, mixed
&$row, mixed
$fetchmode, [mixed
$rownum = null])

[ Top ]

numCols [line 128]

void numCols(
mixed
$foo)

[ Top ]

numRows [line 136]

void numRows(
mixed
$foo)

Overrides DB_common::numRows() (returns the number of rows in a result object)

[ Top ]

query [line 99]

void &query(
[mixed
$query = null])

Overrides DB_common::query() (Send a query to the database and return any results with a DB_result object.)

[ Top ]

Documentation generated on Fri, 30 Apr 2004 23:19:45 +0200 by phpDocumentor 1.2.3. PEAR Logo Copyright © PHP Group 2004.