ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:learn_fields:field_objects

Differences

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

Link to this comparison view

Next revision		Previous revision
Next revisionBoth sides next revision
v5:userguide:learn_fields:field_objects [2016/03/18 02:13] – created mnewnhamv5:userguide:learn_fields:field_objects [2020/01/02 12:03] – ↷ Links adapted because of a move operation dregad
Line 13: Line 13:
  
 ===== 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:reference:connection:movenext|moveNext()]] is used.+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:reference:recordset:movenext|moveNext()]] is used.
    
 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 35: Line 35:
  
 </code> </code>
 +===== Interrogating The Columns =====
 We are now going to loop through each column of each row and use 3 methods to ascertain the value and attributes of the field: We are now going to loop through each column of each row and use 3 methods to ascertain the value and attributes of the field:
   * [[v5:reference:recordset:fields|fields()]], which returns the value of a field at a specified offset.   * [[v5:reference:recordset:fields|fields()]], which returns the value of a field at a specified offset.
Line 56: Line 57:
                        
 </code> </code>
 +===== MetaType Based Decisions =====
 At this point in the loop, we make a formatting decision based on the portable metaType attribute of the column. If the type of the field is a timestamp, we will immediately format the data to present the data as a human readable date At this point in the loop, we make a formatting decision based on the portable metaType attribute of the column. If the type of the field is a timestamp, we will immediately format the data to present the data as a human readable date
 <code php>          <code php>         
Line 69: Line 71:
      * End of the colums, move to next row      * End of the colums, move to next row
      */       */ 
-     $recordSet->MoveNext();+     $recordSet->moveNext();
  
 } }
 </code> </code>
 <WRAP info center 300px> <WRAP info center 300px>
-**End Of Lesson 3**+**End Of Lesson**
 </WRAP> </WRAP>
  
  
v5/userguide/learn_fields/field_objects.txt · Last modified: 2021/03/09 09:38 by dregad