File/query-defs.php

Description
Classes
Class Description
 class sqlquery SQLquery class An SQL Statement Text Container.
 class dbquery DB Query class This class is the one which executes queries against the connected database.
 class dbrows DB Rows class Renders a query into data and allows access to the data either directly or via the usual get first,last,next,previous cursor navigation.
 class dbrecords DB Records class Renders a query into data and allows access to the data either directly or via the usual get first,last,next,previous cursor navigation.
 class dbselect DB Select class A special case of the dbrecords class.
 class dbdelete DB Delete class A special case of the dbquery class. This is for deleting rows from the database.
Abstract class dbtablemod DB tablemod class Parent class for classes which only modify a single table. This means either update or inserts. This class is provided so we can define a common method for sequence definition.
 class dbinsert DB Insert class A special case of the dbtablemod class.
 class dbupdate DB Update class A special case of the dbquery class. This is for updating data in particular rows in the database.
 class dbseq DB seq class A class which allows the management and use of sequences.
Includes
 include_once ("datetime-defs.php") (line 29)

Date-time functions

Constants
NO_ROLLBACK_ON_FAIL = false (line 36)

Transaction response to failure - do nothing

NULLVALUE = "NULL!FIELD!VALUE" (line 41)

This value indicates a NULL field value for queries

ROLLBACK_ON_FAIL = true (line 34)

Transaction response to failure - rollback

Functions
begin_transaction (line 1142)

Begin a DB transaction

void begin_transaction ()
commit (line 1178)

Commit a DB transaction

  • return: True if transaction committed
bool commit ()
dbcommand (line 1101)

Execute a DB command

A wrapper which caters for the 'command' type of SQL query where no results are reauired, such as for a DELETE or UPDATE, or INSERT etc. Returns true if all ok, otherwise returns false.

  • return: True if dbcommand succeeded
bool dbcommand (string $sql)
  • string $sql: An SQL statement in full
dbrecordset (line 1113)

A wrapper which caters for queries which will return a record set identifier for returning data.

  • return: Returns a resource ID for the recordset
resource dbrecordset (string $sql)
  • string $sql: An SQL statement in full
get_next_sequencevalue (line 1125)

A wrapper to get the next sequence value from a named sequence..

  • return: The value of the next integer in this sequence
integer get_next_sequencevalue (string $sequencename, [string $table = ""], [string $column = ""])
  • string $sequencename: Name of the sequence
  • string $column: Name of the column sequence is on
  • string $table: Name of the table column is on
lock (line 1203)

Take out a lock on a table or tables, in a given mode. The mode string is database-specific and will vary according to the implementation of its locking scheme.

void lock (string $tablelist, string $mode)
  • string $tablelist: List of tables to lock, comma-delimited
  • string $mode: Databes-specific locking-mode or type
rollback (line 1188)

Rollback a DB transaction

  • return: True if transaction rolled back
bool rollback ()
start_transaction (line 1135)

Start a DB transaction. Alias for begin_transaction()

void start_transaction ()
transaction_failed (line 1152)

Return DB transaction failure status.

  • return: True if transaction failed
bool transaction_failed ()
transaction_open (line 1169)

Return DB transaction open status.

  • return: True if transaction already open
bool transaction_open ()
transaction_succeeded (line 1161)

Return DB transaction success status.

  • return: True if transaction succeeded
bool transaction_succeeded ()

Documentation generated by phpDocumentor 1.3.0RC3