v5:reference:adodb_fetch_mode
This is an old revision of the document!
$ADODB_FETCH_MODE
Type | Integer |
Default | 0 |
This is a global variable that determines how arrays are retrieved by recordsets. 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.
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.1436727661.txt.gz · Last modified: 2017/04/21 11:31 (external edit)