ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


Action unknown: siteexport_addpage
v5:reference:recordset:fetchobj

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.

If the SQL statement results in an empty recordset, then calling fetchObj() will return an empty record, not EOF. Use recordCount() to ensure that you have retrieved a record

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.txt · Last modified: 2020/03/28 21:24 by mnewnham