DB_FETCHMODE_ORDERED, DB_FETCHMODE_ASSOC or DB_FETCHMODE_OBJECT.
If you will be using getCol(), the DB_FETCHMODE_ORDERED or DB_FETCHMODE_ASSOC constants can be combined with the DB_FETCHMODE_FLIPPED constant via the bitwise OR operator (|). For example:
DB_FETCHMODE_ASSOC | DB_FETCHMODE_FLIPPED |
See the Examples section, below, for more information.
This parameter is for use when $fetchmode is set to DB_FETCHMODE_OBJECT.
You can set this parameter to DB_row, which then causes the resulting data to populate a new instance of a DB_row object.
Table 26-1. Possible PEAR_Error values
Error code | Error message | Reason | Solution |
---|---|---|---|
NULL | invalid fetchmode mode | The given fetch mode does not exists or is not implement in your DB version. | Check writing of the argument and your used version of DB. |
Example 26-1. DB_FETCHMODE_ORDERED (default) Causes ordered arrays to be returned. The order is taken from the select statement.
Output:
|
Example 26-2. DB_FETCHMODE_ASSOC Makes associative arrays, with the column names as the array keys.
Output:
|
Example 26-3. DB_FETCHMODE_OBJECT Returns objects with column names as properties.
Output:
|
Example 26-4. DB_FETCHMODE_OBJECT and DB_row If setFetchMode()'s optional $object_class parameter is set to DB_row, DB_row objects are returned.
Output:
|