v5:userguide:learn_fields:field_objects
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:userguide:learn_fields:field_objects [2016/03/18 02:20] – mnewnham | v5:userguide:learn_fields:field_objects [2021/03/09 09:38] (current) – [Interrogating The Columns] wrong variable name in code sample dregad | ||
---|---|---|---|
Line 2: | Line 2: | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
====== Fields As Objects ====== | ====== Fields As Objects ====== | ||
- | In Lesson 2, the concept of the **// | + | In Lesson 2, the concept of the **// |
+ | In this section, we show how the value of a field, | ||
+ | By treating the returned result set as a 2 dimensional array, we can process each row on a column-by-column basis. | ||
===== The Limits Of The Array ===== | ===== The Limits Of The Array ===== | ||
Line 13: | Line 15: | ||
===== Walking The Rows Of A ResultSet ===== | ===== Walking The Rows Of A ResultSet ===== | ||
- | In Lesson 1, we saw a number of ways of moving from one row to the next. It is important to not mix methods, as some methods read the record and automatically advance the record pointer, and some do not. However in all cases, a flag **EOF** is set as soon as the end of the result set is reached. In the following example, the method [[v5: | + | In Lesson 1, we saw a number of ways of moving from one row to the next. It is important to not mix methods, as some methods read the record and automatically advance the record pointer, and some do not. However in all cases, a flag **EOF** is set as soon as the end of the result set is reached. In the following example, the method [[v5: |
Note the for both rows and columns, ADOdb uses the PHP convention of a Zero-Based (0) array, as opposed to SQL offsets, which are One-based (1). | Note the for both rows and columns, ADOdb uses the PHP convention of a Zero-Based (0) array, as opposed to SQL offsets, which are One-based (1). | ||
Line 49: | Line 51: | ||
| | ||
| | ||
- | | + | |
/* | /* | ||
* This is the value of the field | * This is the value of the field | ||
*/ | */ | ||
- | | + | |
</ | </ | ||
Line 71: | Line 73: | ||
* End of the colums, move to next row | * End of the colums, move to next row | ||
| | ||
- | | + | |
} | } | ||
</ | </ | ||
<WRAP info center 300px> | <WRAP info center 300px> | ||
- | **End Of Lesson | + | **End Of Lesson** |
</ | </ | ||
v5/userguide/learn_fields/field_objects.1458264013.txt.gz · Last modified: 2017/04/21 11:40 (external edit)