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/07/12 22:12] – mnewnham | v5:reference:connection:setfetchmode [2020/01/05 12:30] (current) – dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== setFetchMode ====== | ====== setFetchMode ====== | ||
- | <WRAP alert> | + | ~~NOTOC~~ |
- | 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 $fetchType | + | optional int $fetchMode |
- | ) | + | |
- | == 6.0.0 Syntax == | + | |
- | void setFetchMode( | + | |
- | int $fetchType | + | |
) | ) | ||
+ | |||
+ | == See Also == | ||
+ | [[v5: | ||
+ | [[v5: | ||
</ | </ | ||
==== Use as a getter ==== | ==== Use as a getter ==== | ||
Use < | Use < | ||
+ | ---------------------------------- | ||
==== 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 27: | 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 45: | 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.1436731958.txt.gz · Last modified: 2017/04/21 11:33 (external edit)