ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== fetchNextObj =======

~~NOTOC~~

<WRAP right box>
  obj fetchNextObj(
      optional bool $upperCaseKeys=false
      )

  obj fetchNextObject(
      optional bool $upperCaseKeys=true
      )
</WRAP>

====== fetchNextObject =======

===== Description =====

The ''fetchNextObj()'' / ''fetchNextObject()'' functions return the current record from a recordset as an object or //false// if past end-of-file, and advance the record pointer. 

''fetchNextObj()'' and ''fetchNextObject()'' can be considered as aliases, except for the fact that the latter converts the field names to uppercase by default, whereas ''fetchNextObj()'' does not.

The [[v5:reference:recordset:fetchObj()]] method is similar, but does not affect the record pointer. It is recommended that the 2 methods are not mixed in the same procedure. 


===== Usage =====
<code php>
/*
 * Connection assumed
 */
$result = $db->Execute('SELECT * FROM Employees');
while (!$result->EOF){
    $obj = $result->fetchNextObj();
    print_r($obj);
    /*
     * Prints :
     * 
     * 
    ADOFetchObj Object
    (
        [emp_no] => 10001
        [birth_date] => 1953-09-02
        [first_name] => Georgi
        [last_name] => Facello
        [gender] => M
        [hire_date] => 1986-06-26
    )
}
   
</code>

{{tag>PEAR Objects}}