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:28] – [fetchObj] add fetchObject alias 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 function ''fetchObj()'' returns the current row of a recordset as an ADOFetchObj object or false if past end-of-file and advances the pointer of the result. If the end-of-file is reached, the ''EOF'' attribute is set.+ 
 +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.
  
 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. 
 ------------------- -------------------
 ===== Usage ===== ===== Usage =====
v5/reference/recordset/fetchobj.1686475682.txt.gz · Last modified: 2023/06/11 11:28 by dregad