obj fetchObject( optional bool $upperCaseKeys=true )
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.
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() 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'; */