- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:reference:adodb_fetch_mode

# $ADODB_FETCH_MODE

##### See Also

setfetchmode

##### Definition

Type | Integer
Default | 0

This is a global variable that determines how the keys of recordsets are presented when recordsets are retrived from the database. The recordset saves this value on creation (eg. in execute or selectlimit), and any subsequent changes to $ADODB_FETCH_MODE have no affect on existing recordsets, only on recordsets created in the future.

This variable has no effect on the data returned, only the keys of data

## Constants

Name | Value | Description
--- | --- | ---
ADODB_FETCH_DEFAULT | 0 | The recordset is returned in the default provided by the PHP driver. Use of this value is not recommended if writing cross-database applications
ADODB_FETCH_NUM | 1 | The recordset is returned as a numeric array
ADODB_FETCH_ASSOC | 2 | The recordset is returned as an associative array
ADODB_FETCH_BOTH | 3 | The record is returned as both a numeric and associative arrays. Not supported in many databases

## Syntax

    $ADODB_FETCH_MODE = ADODB_FETCH_NUM;

    $rs1 = $db->Execute('select * from table');

    $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;

    $rs2 = $db->Execute('select * from table');

    print_r($rs1->fields);
    /*
      shows _array([0]=>'v0',
                   [1] =>'v1')
    */
    print_r($rs2->fields);
    /*
     * shows _array(['col1']=>'v0',
                    ['col2'] =>'v1')
     */

## More Information

For more information on the constants used and for more granular control of this setting, see setFetchMode()

v5/reference/adodb_fetch_mode.txt · Last modified: 2016/01/17 15:44 by 66.249.75.217

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top