$databaseType
$databaseType :
This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
Note that the constructor is different from the standard ADORecordSet
GetMenu( $name, $defstr = '', $blank1stItem = true, $multiple = false, $size, $selectAttr = '', $compareFields0 = true) : \HTML
Generate a SELECT tag string from a recordset, and return the string.
If the recordset has 2 cols, we treat the 1st col as the containing the text to display to the user, and 2nd col as the return value. Default strings are compared with the FIRST column.
| $name | ||
| $defstr | ||
| $blank1stItem | ||
| $multiple | ||
| $size | ||
| $selectAttr | ||
| $compareFields0 |
changes by glen.davies@cce.ac.nz to support multiple hilited items
GetMenu2( $name, $defstr = '', $blank1stItem = true, $multiple = false, $size, $selectAttr = '')
Generate a SELECT tag string from a recordset, and return the string.
If the recordset has 2 cols, we treat the 1st col as the containing the text to display to the user, and 2nd col as the return value. Default strings are compared with the SECOND column.
| $name | ||
| $defstr | ||
| $blank1stItem | ||
| $multiple | ||
| $size | ||
| $selectAttr |
GetAssoc( $force_array = false, $first2cols = false) : \an
return whole recordset as a 2-dimensional associative array if there are more than 2 columns.
The first column is treated as the key and is not included in the array. If there is only 2 columns, it will return a 1 dimensional array of key-value pairs unless $force_array == true.
| $force_array | ||
| $first2cols |
associative array indexed by the first column of the array, or false if the data has less than 2 cols.
FetchInto( $arr) : \DB_OK
Fetch a row, returning PEAR_Error if no more rows.
This is PEAR DB compat mode.
| $arr |
or error object
GetRowAssoc(integer $upper = ADODB_ASSOC_CASE)
Use associative array to get fields array for databases that do not support associative arrays. Submitted by Paolo S. Asioli paolo.asioli#libero.it
| integer | $upper | Case for the array keys, defaults to uppercase (see ADODB_ASSOC_CASE_xxx constants) |
PO_RecordCount( $table = "", $condition = "") : \the
Portable RecordCount. Pablo Roca <pabloroca@mvps.org>
| $table | ||
| $condition |
number of records from a previous SELECT. All databases support this.
But aware possible problems in multiuser environments. For better speed the table must be indexed by the condition. Heavy test this before deploying.
FetchNextObject( $isupper = true) : \the
Return the fields array of the current row as an object for convenience.
The default is upper case field names.
| $isupper | to set the object property names to uppercase |
object with the properties set to the fields of the current row, or false if EOF
Fixed bug reported by tim@orotech.net
MetaType( $t, $len = -1, $fieldobj = false) : \the
Get the metatype of the column. This is used for formatting. This is because many databases use different names for the same type, so we transform the original type to our standardised version which uses 1 character codes:
| $t | ||
| $len | ||
| $fieldobj |
general type of the data: C for character < 250 chars X for teXt (>= 250 chars) B for Binary N for numeric or floating point D for date T for timestamp L for logical/Boolean I for integer R for autoincrement counter/integer