ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:recordset:fetchobj

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:reference:recordset:fetchobj [2023/06/11 11:40] – [Description] describe difference between fetchObj/fetchObject, remove invalid mention of advancing cursor dregadv5:reference:recordset:fetchobj [2023/06/11 12:25] (current) – dregad
Line 1: Line 1:
 ====== fetchObj ======= ====== fetchObj =======
-====== fetchObject ======= 
  
 ~~NOTOC~~ ~~NOTOC~~
  
 <WRAP right box> <WRAP right box>
-  obj fetchObj( +  obj fetchObj()
-      optional bool $upperCaseKeys=false +
-      )+
  
   obj fetchObject(   obj fetchObject(
Line 13: Line 10:
       )       )
 </WRAP> </WRAP>
 +
 +====== fetchObject =======
 +
 ===== Description ===== ===== Description =====
  
-The ''fetchObj()'' / ''fetchObject()'' function returns the current row of a RecordSet as an ADOFetchObj object, or //false// if past end-of-file.+The ''fetchObj()'' / ''fetchObject()'' functions return the current row of a RecordSet as an ADOFetchObj object.
  
 They can be considered as aliases, except for the fact that ''fetchObject()'' converts the field names to uppercase by default, whereas ''fetchObj()'' does not. They can be considered as aliases, except for the fact that ''fetchObject()'' converts the field names to uppercase by default, whereas ''fetchObj()'' does not.
Line 21: Line 21:
 Unlike the [[v5:reference:recordset:fetchNextObj()]] method, the record pointer is not advanced. It is recommended that the 2 methods are not mixed in the same procedure.  Unlike the [[v5:reference:recordset:fetchNextObj()]] method, the record pointer is not advanced. It is recommended that the 2 methods are not mixed in the same procedure. 
  
-If the SQL statement results in an empty recordset, then calling fetchObj() will return an empty record, not EOF. Use [[v5:reference:connection:recordcount|recordCount()]] to ensure that you have retrieved a record.+If the SQL statement results in an empty recordset or if the recordset has moved past end of file, then calling fetchObj() will return an empty record. Use [[v5:reference:connection:recordcount|recordCount()]] or check the EOF flag to ensure that you have retrieved a record.
  
 Results are influenced both by the [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] attribute. Results are influenced both by the [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] attribute.
  
-The ADOFetchObj object has no special functionality, but the method is useful when the recordset data needs to be converted into e.g. JSON+The ADOFetchObj object has no special functionality, but the method is useful when the recordset data needs to be converted into e.g. JSON.
  
 ------------------- -------------------
v5/reference/recordset/fetchobj.1686476424.txt.gz · Last modified: 2023/06/11 11:40 by dregad