A class defining a resultset and how to interact with results from a database query.
| package |
CMS |
|---|---|
| author |
Robert Campbell |
| copyright |
Copyright (c) 2015, Robert Campbell calguy1000@cmsmadesimple.org |
| since | 2.2 |
| property-read |
Test if we are at the end of the current resultset. |
| property-read |
Return the current row of the resultset. |
MoveFirst()
MoveNext()
Move(integer $idx)
integer $idxGetArray() : array
array
GetRows() : array
array
GetAll() : array
array
GetAssoc( $force_array = false, $first2cols = false) : array
If only two columns are returned in the resultset, the keys of the returned associative array will be the value of the first column, and the value of each key will be the value from the second column.
If more than 2 columns are returned, then the key of the returned associative array will be the value from the first column, and the value of each key will be an associative array of the remaining columns. This is known as array behavior.
array
EOF() : boolean
boolean
Close()
RecordCount() : integer
integer
NumRows() : integer
integer
Fields(string $field = null) : mixed|array
string $fieldAn optional field name, if not specified, the entire row will be returned.
mixed|array
Either a single value, or an array
FetchRow() : array
array
EOF : boolean
Test if we are at the end of the current resultset.
boolean fields : array
Return the current row of the resultset.
array