====== fetchObj =======
~~NOTOC~~
<WRAP right box>
  obj fetchObj(
      optional bool $upperCaseKeys=false
      )
</WRAP>
===== 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.

Unlike the [[v6:reference:recordset:fetchNextObj()]] method, the record pointer is not advanced. It is recommended that the 2 methods are not mixed in the same procedure. 

Results are influenced both by the [[v6:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and [[v6: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
-------------------
===== Usage =====
<code php>
/*
 * Database connection assumed
 */
$SQL = "SELECT * FROM Employees"
$result = $db->execute($SQL);
$r = $result->fetchObj()
   print_r($r);
/*
 * returns
ADOFetchObj Object
(
    [emp_no] => 10001
    [birth_date] => 1953-09-02
    [first_name] => Georgi
    [last_name] => Facello
    [gender] => M
    [hire_date] => 1986-06-26
)

*/

print $r->first_name;
/*
* prints 'Georgi';
*/
</code>
{{tag>PEAR Objects}}