v5:reference:connection:setfetchmode
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:setfetchmode [2015/12/04 17:20] – mnewnham | v5:reference:connection:setfetchmode [2020/01/05 12:30] (current) – dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== setFetchMode ====== | ====== setFetchMode ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | <WRAP alert> | + | |
- | Use of direct querying of the $fetchMode property, and use of setFetchMode() as a getter is deprecated as of version 5.21.0 and will be removed as of version 6.0.0. As of 5.21.0 you should use [[reference: | + | If you have multiple connection objects, and want to have different fetch modes for each connection, then use SetFetchMode. Once this function is called for a connection object, that connection object will ignore the global variable |
- | </ | + | |
- | If you have multiple connection objects, and want to have different fetch modes for each connection, then use SetFetchMode. Once this function is called for a connection object, that connection object will ignore the global variable $ADODB_FETCH_MODE and will use the internal fetchMode property exclusively. | + | |
<WRAP right 300px box> | <WRAP right 300px box> | ||
- | == 5.21.0 | + | == Syntax == |
int setFetchMode( | int setFetchMode( | ||
optional int $fetchMode | optional int $fetchMode | ||
) | ) | ||
- | == 6.0.0 Syntax | + | |
- | void setFetchMode( | + | == See Also == |
- | int $fetchMode | + | [[v5: |
- | ) | + | [[v5: |
</ | </ | ||
==== Use as a getter ==== | ==== Use as a getter ==== | ||
Line 19: | Line 17: | ||
---------------------------------- | ---------------------------------- | ||
==== Constants ==== | ==== Constants ==== | ||
- | ^Name^Value^Description^ | + | ^ Name |
- | |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_DEFAULT |
- | |ADODB_FETCH_NUM|1|The recordset is returned as a numeric array| | + | | ADODB_FETCH_NUM |
- | |ADODB_FETCH_ASSOC|2|The recordset is returned as an associative array| | + | | ADODB_FETCH_ASSOC |
- | |ADODB_FETCH_BOTH|3|The record is returned as both a numeric and associative arrays| | + | | ADODB_FETCH_BOTH |
===== Usage ===== | ===== Usage ===== | ||
Line 29: | Line 27: | ||
<code php> | <code php> | ||
$db-> | $db-> | ||
- | + | $rs1 = $db->execute(' | |
- | $rs1 = $db->Execute(' | + | |
$db-> | $db-> | ||
- | + | $rs2 = $db->execute(' | |
- | $rs2 = $db->Execute(' | + | |
print_r($rs1-> | print_r($rs1-> | ||
Line 47: | Line 43: | ||
*/ | */ | ||
+ | </ | ||
+ | ====== Fetch Both ===== | ||
+ | Some databases support a 'Fetch Both' mode, which can be set using '' | ||
+ | <code php> | ||
+ | $db-> | ||
+ | $rs3 = $db-> | ||
+ | print_r($rs3-> | ||
+ | /* | ||
+ | shows _array([0]=>' | ||
+ | | ||
+ | [1] =>' | ||
+ | | ||
+ | ) | ||
+ | */ | ||
</ | </ | ||
v5/reference/connection/setfetchmode.1449246014.txt.gz · Last modified: 2017/04/21 11:33 (external edit)