ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:adodb_recordset

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
v5:reference:connection:adodb_recordset [2016/02/26 03:06] – created mnewnhamv5:reference:connection:adodb_recordset [2016/02/28 03:33] (current) mnewnham
Line 145: Line 145:
 ^Field^Description| ^Field^Description|
 |databaseType] => array |databaseType] => array
-|_array|Array +|_array|An array that holds all the retrieved records|
-+
- [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|| |_types||
 |_colnames|| |_colnames||
 |_skiprow1|| |_skiprow1||
-|_fieldobjects|Array +|_fieldobjects|An array of [[v5:reference:adofieldobjects|adoFieldObjects]] describing the columns in the result set|
-+
- [0] => ADOFieldObject Object +
-+
- [name=> Order ID +
- [max_length] => 10 +
- [type] => COUNTER +
-+
- +
- [1] => ADOFieldObject Object +
-+
- [name] => Employee ID +
- [max_length] => 10 +
- [type=> INTEGER +
-+
- +
-+
 |canSeek|| |canSeek||
-|affectedrows||+|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|| |insertid||
-|sql|SELECT * FROM orders|+|sql|The SQL statement issued to produce the result|
 |compat|| |compat||
 |dataProvider|odbc| |dataProvider|odbc|
-|fields|Array +|fields|The list of column names returned by the query, if appropriate|
-+
- [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|| |blobSize||
-|EOF||+|EOF|A boolean value indicating if EOF has been reached. This value can be queried using ADOConnection::EOF|
 |emptyTimeStamp|| |emptyTimeStamp||
 |emptyDate|| |emptyDate||
-|debug||+|debug|Indicates whether [[v5:reference:degug|Debugging Mode]] is enabled|
 |timeCreated|| |timeCreated||
 |bind|| |bind||
 |fetchMode|The Fetch mode in use when the query was executed|[[v5:reference:fetchmode|ADODB_FETCH_MODE]]| |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| |connection|This is a recursive link to the ADOconnection Object|
-|_numOfRows|The number of rows returned from a query|[[v5:reference:connection:rowcount|ADOConnection::rowCount()]]|+|_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|| |_numOfFields|The number of columns returned by the query||
 |_queryID|The PHP resource in use when the query was executed| |_queryID|The PHP resource in use when the query was executed|
-|_currentRow||+|_currentRow|The current row number when iterating through the the recordset, see [[v5:reference:recordset|recordNumber()]|
 |_closed|| |_closed||
 |_inited|| |_inited||
Line 272: Line 180:
 |_maxRecordCount|| |_maxRecordCount||
 |datetime|| |datetime||
- 
-     
v5/reference/connection/adodb_recordset.txt · Last modified: 2016/02/28 03:33 by mnewnham