v5:reference:adodb_fetch_mode
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:adodb_fetch_mode [2015/07/12 20:46] – mnewnham | v5:reference:adodb_fetch_mode [2016/01/18 00:44] (current) – ↷ Links adapted because of a move operation 66.249.75.217 | ||
---|---|---|---|
Line 2: | Line 2: | ||
====== $ADODB_FETCH_MODE ====== | ====== $ADODB_FETCH_MODE ====== | ||
- | <WRAP right 400px> | + | <WRAP right 200px box> |
- | <WRAP info> | + | == See Also == |
+ | [[v5: | ||
+ | == Definition == | ||
|Type|Integer| | |Type|Integer| | ||
|Default|0| | |Default|0| | ||
Line 10: | Line 11: | ||
</ | </ | ||
- | </ | + | 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 [[v5: |
- | This is a global | + | ** This variable |
---------------------------- | ---------------------------- | ||
+ | |||
+ | ===== 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 ===== | ===== Syntax ===== | ||
+ | |||
<code php> | <code php> | ||
- | $ADODB_FETCH_MODE = ADODB_FETCH_NUM; | + | $ADODB_FETCH_MODE = ADODB_FETCH_NUM; |
+ | |||
+ | $rs1 = $db-> | ||
+ | |||
+ | $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; | ||
+ | |||
+ | $rs2 = $db-> | ||
+ | |||
+ | print_r($rs1-> | ||
+ | /* | ||
+ | shows _array([0]=>' | ||
+ | [1] =>' | ||
+ | */ | ||
+ | print_r($rs2-> | ||
+ | /* | ||
+ | * shows _array([' | ||
+ | [' | ||
+ | */ | ||
</ | </ | ||
===== More Information ===== | ===== More Information ===== | ||
- | For more information on the constants used and for more granular control of this setting, see [[reference: | + | For more information on the constants used and for more granular control of this setting, see [[v5:reference:connection: |
v5/reference/adodb_fetch_mode.1436726796.txt.gz · Last modified: 2017/04/21 11:31 (external edit)