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'; */