ADOdb

Database Abstraction Layer for PHP

Trace: • find • $ADODB_COUNTRECS

v5:reference:connection:adodb_recordset

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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 =====
<code php>
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] => &nbsp;
    [emptyDate] => &nbsp;
    [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] => 
)
</code>
===== Object Data =====

^Field^Description|
|databaseType] => array
|_array|An array that holds all the retrieved records|
|_types||
|_colnames||
|_skiprow1||
|_fieldobjects|An array of [[v5:reference:adofieldobjects|adoFieldObjects]] describing the columns in the result set|
|canSeek||
|affectedrows|If the the statement executed is not a select, the number of rows affected by the statement. This value is database dependant and is accessible via the [[v5:reference:connection:affected_rows|affected_rows()]] method.
|insertid||
|sql|The SQL statement issued to produce the result|
|compat||
|dataProvider|odbc|
|fields|The list of column names returned by the query, if appropriate|
|blobSize||
|EOF|A boolean value indicating if EOF has been reached. This value can be queried using ADOConnection::EOF|
|emptyTimeStamp||
|emptyDate||
|debug|Indicates whether [[v5:reference:degug|Debugging Mode]] is enabled|
|timeCreated||
|bind||
|fetchMode|The Fetch mode in use when the query was executed|[[v5:reference:fetchmode|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 [[v5:reference:connection:rowcount|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.txt · Last modified: 2016/02/28 03:33 by mnewnham