v5:reference:connection:adodb_recordset
This is an old revision of the document!
Table of Contents
The ADORecordSet_array Object
Description
The ADORecordSet_array Object is the result of the execution of an SQL statement through an ADOdbConnection object.
The Object
ADORecordSet_array Object ( [databaseType] => array [_array] => Array ( [0] => Array ( [Order ID] => 30 [Employee ID] => 9 [Customer ID] => 27 [Order Date] => 2006-01-15 00:00:00 [Shipped Date] => 2006-01-22 00:00:00 [Shipper ID] => 2 [Ship Name] => Karen Toh [Ship Address] => 789 27th Street [Ship City] => Las Vegas [Ship State/Province] => NV [Ship ZIP/Postal Code] => 99999 [Ship Country/Region] => USA [Shipping Fee] => 200.0000 [Taxes] => .0000 [Payment Type] => Check [Paid Date] => 2006-01-15 00:00:00 [Notes] => [Tax Rate] => 0.0 [Tax Status] => [Status ID] => 3 ) [1] => Array ( [Order ID] => 31 [Employee ID] => 3 [Customer ID] => 4 [Order Date] => 2006-01-20 00:00:00 [Shipped Date] => 2006-01-22 00:00:00 [Shipper ID] => 1 [Ship Name] => Christina Lee [Ship Address] => 123 4th Street [Ship City] => New York [Ship State/Province] => NY [Ship ZIP/Postal Code] => 99999 [Ship Country/Region] => USA [Shipping Fee] => 5.0000 [Taxes] => .0000 [Payment Type] => Credit Card [Paid Date] => 2006-01-20 00:00:00 [Notes] => [Tax Rate] => 0.0 [Tax Status] => [Status ID] => 3 ) ) [_types] => [_colnames] => [_skiprow1] => [_fieldobjects] => Array ( [0] => ADOFieldObject Object ( [name] => Order ID [max_length] => 10 [type] => COUNTER ) [1] => ADOFieldObject Object ( [name] => Employee ID [max_length] => 10 [type] => INTEGER ) ) [canSeek] => 1 [affectedrows] => [insertid] => [sql] => SELECT * FROM orders [compat] => [dataProvider] => odbc [fields] => Array ( [Order ID] => 30 [Employee ID] => 9 [Customer ID] => 27 [Order Date] => 2006-01-15 00:00:00 [Shipped Date] => 2006-01-22 00:00:00 [Shipper ID] => 2 [Ship Name] => Karen Toh [Ship Address] => 789 27th Street [Ship City] => Las Vegas [Ship State/Province] => NV [Ship ZIP/Postal Code] => 99999 [Ship Country/Region] => USA [Shipping Fee] => 200.0000 [Taxes] => .0000 [Payment Type] => Check [Paid Date] => 2006-01-15 00:00:00 [Notes] => [Tax Rate] => 0.0 [Tax Status] => [Status ID] => 3 ) [blobSize] => 100 [EOF] => [emptyTimeStamp] => [emptyDate] => [debug] => [timeCreated] => 0 [bind] => [fetchMode] => 2 [connection] => ADODB_access Object ( ) [_numOfRows] => 48 [_numOfFields] => 20 [_queryID] => Resource id #13 [_currentRow] => 0 [_closed] => [_inited] => 1 [_obj] => [_names] => [_currentPage] => -1 [_atFirstPage] => [_atLastPage] => [_lastPageNo] => -1 [_maxRecordCount] => 0 [datetime] => )
Object Data
| Field | Description | |
|---|---|---|
| _array | ||
| _types | ||
| _colnames | ||
| _skiprow1 | ||
| _fieldobjects | An array of adoFieldObjects describing the columns in the result set | |
| canSeek | ||
| affectedrows | ||
| insertid | ||
| sql | SELECT * FROM orders | |
| compat | ||
| dataProvider | odbc | |
| fields | Array( [Order ID] => 30 [Employee ID] => 9 [Customer ID] => 27 [Order Date] => 2006-01-15 00:00:00 [Shipped Date] => 2006-01-22 00:00:00 [Shipper ID] => 2 [Ship Name] => Karen Toh [Ship Address] => 789 27th Street [Ship City] => Las Vegas [Ship State/Province] => NV [Ship ZIP/Postal Code] => 99999 [Ship Country/Region] => USA [Shipping Fee] => 200.0000 [Taxes] => .0000 [Payment Type] => Check [Paid Date] => 2006-01-15 00:00:00 [Notes] => [Tax Rate] => 0.0 [Tax Status] => [Status ID] => 3 ) | |
| blobSize | ||
| EOF | A boolean value indicating if EOF has been reached. This | |
| emptyTimeStamp | ||
| emptyDate | ||
| debug | Indicates whether Debugging Mode is enabled | |
| timeCreated | ||
| bind | ||
| fetchMode | The Fetch mode in use when the query was executed | ADODB_FETCH_MODE |
| connection | This is a recursive link to the ADOconnection Object | |
| _numOfRows | The number of rows returned from a query, if appropriate, see ADOConnection::rowCount() | |
| _numOfFields | The number of columns returned by the query | |
| _queryID | The PHP resource in use when the query was executed | |
| _currentRow | The current row number when iterating through the the recordset, see [[v5:reference:recordset | recordNumber()] |
| _closed | ||
| _inited | ||
| _obj | ||
| _names | ||
| _currentPage | ||
| _atFirstPage | ||
| _atLastPage | ||
| _lastPageNo | ||
| _maxRecordCount | ||
| datetime | ||
v5/reference/connection/adodb_recordset.1456625986.txt.gz · Last modified: 2017/04/21 11:37 (external edit)