ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:recordset:fetchobj

This is an old revision of the document!


fetchObj

obj fetchObj(
    optional bool $upperCaseKeys=false
    )

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 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 ADODB_ASSOC_CASE constant and $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

/*
 * 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';
*/
v5/reference/recordset/fetchobj.1454000413.txt.gz · Last modified: 2017/04/21 11:37 (external edit)