ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:adodb_recordset

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

FieldDescription
_arrayAn array that holds all the retrieved records
_types
_colnames
_skiprow1
_fieldobjectsAn array of adoFieldObjects describing the columns in the result set
canSeek
affectedrows
insertid
sqlThe SQL statement issued to produce the result
compat
dataProviderodbc
fieldsThe list of column names returned by the query, if appropriate
blobSize
EOFA boolean value indicating if EOF has been reached. This value can be queried using ADOConnection::EOF
emptyTimeStamp
emptyDate
debugIndicates whether Debugging Mode is enabled
timeCreated
bind
fetchModeThe Fetch mode in use when the query was executedADODB_FETCH_MODE
connectionThis is a recursive link to the ADOconnection Object
_numOfRowsThe number of rows returned from a query, if appropriate, see ADOConnection::rowCount()
_numOfFieldsThe number of columns returned by the query
_queryIDThe PHP resource in use when the query was executed
_currentRowThe current row number when iterating through the the recordset, see [[v5:reference:recordsetrecordNumber()]
_closed
_inited
_obj
_names
_currentPage
_atFirstPage
_atLastPage
_lastPageNo
_maxRecordCount
datetime
v5/reference/connection/adodb_recordset.txt · Last modified: 2016/02/28 03:33 by mnewnham