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

Both sides previous revisionPrevious revision
v5:reference:connection:adodb_recordset [2016/02/28 03:19] 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||
Line 205: Line 153:
 |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. |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|A boolean value indicating if EOF has been reached. This |+|EOF|A boolean value indicating if EOF has been reached. This value can be queried using ADOConnection::EOF|
 |emptyTimeStamp|| |emptyTimeStamp||
 |emptyDate|| |emptyDate||
v5/reference/connection/adodb_recordset.txt · Last modified: 2016/02/28 03:33 by mnewnham