Class n2f_database_query

Description

Core database query class for N2 Framework Yverdon.

Located in /system/classes/database.cls.php (line 215)

n2f_events
   |
   --n2f_database_query
Variable Summary
array $params
string $query
result $result
Method Summary
n2f_database addData (mixed $key, mixed $data)
n2f_database_query addError (string $string)
n2f_database_query addParam (string $key, mixed $value, mixed $type)
string fetchError ()
array fetchErrors ()
mixed fetchInc ()
mixed fetchResult (integer $offset, string $field_name)
mixed fetchRow ()
mixed fetchRows ()
mixed getData (mixed $key)
boolean isError ()
integer numRows ()
Variables
n2f_database $db (line 221)

Internal reference to the global database handler.

  • access: public
array $params (line 233)

Collection of parameters for the current query.

  • access: public
string $query (line 227)

SQL string used for this query.

  • access: public
result $result (line 239)

Holds the current result set for the query if applicable.

  • access: public
array $_internalData (line 251)

Internal container for object data.

  • access: protected

Inherited Variables

Inherited from n2f_events

n2f_events::$events
Methods
Constructor __construct (line 260)

Initializes a new n2f_database_query object.

  • access: public
n2f_database_query __construct (string $sql, n2f_database &$db, n2f_database $db)

Redefinition of:
n2f_events::__construct()
Initializes the n2f_events object.
addData (line 317)

Mechanism for storing data in the n2f_database_query object's internal data container.

  • access: public
n2f_database addData (mixed $key, mixed $data)
  • mixed $key
  • mixed $data
addError (line 383)

Adds an error to the n2f_database_query object's error stack.

  • access: public
n2f_database_query addError (string $string)
  • string $string
addParam (line 345)

Adds a parameter to the query stack.

  • access: public
n2f_database_query addParam (string $key, mixed $value, mixed $type)
  • string $key
  • mixed $value
  • mixed $type
execQuery (line 362)

Executes the query.

  • access: public
n2f_database_query execQuery ()
fetchError (line 411)

Returns the last populated error string.

  • access: public
string fetchError ()
fetchErrors (line 420)

Returns the error stack.

  • access: public
array fetchErrors ()
fetchInc (line 458)

Fetches the last automatically incremented value from the query (if applicable).

  • access: public
mixed fetchInc ()
fetchResult (line 449)

Fetches a specific field from the result.

  • access: public
mixed fetchResult (integer $offset, string $field_name)
  • integer $offset
  • string $field_name
fetchRow (line 429)

Fetches a single row from the result.

  • access: public
mixed fetchRow ()
fetchRows (line 438)

Fetches all rows from the result.

  • access: public
mixed fetchRows ()
getData (line 329)

Retrieves data from the n2f_database_query object's internal data container.

  • access: public
mixed getData (mixed $key)
  • mixed $key
isError (line 398)

Returns true or false based on whether or not an error has occurred.

  • access: public
boolean isError ()
numRows (line 467)

Returns the number of rows from the result.

  • access: public
integer numRows ()

Inherited Methods

Inherited From n2f_events

n2f_events::__construct()
n2f_events::addEvent()
n2f_events::hitEvent()
n2f_events::hookEvent()

Documentation generated on Wed, 05 Nov 2008 13:15:11 -0500 by phpDocumentor 1.4.0