Database Abstraction Layer for PHP

User Tools

Site Tools



obj fetchObj()
obj fetchObject(
    optional bool $upperCaseKeys=true



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 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 or if the recordset has moved past end of file, then calling fetchObj() will return an empty record. Use recordCount() or check the EOF flag 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.


 * Database connection assumed
$SQL = "SELECT * FROM Employees"
$result = $db->execute($SQL);
$r = $result->fetchObj()
 * 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: 2023/06/11 12:25 by dregad