v5:reference:connection:setfetchmode
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
reference:setfetchmode [2015/07/12 22:03] – [setFetchMode()] mnewnham | v5:reference:connection:setfetchmode [2018/06/11 10:22] – [Fetch Both] Add full code example 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> | ||
+ | == See Also == | ||
+ | [[v5: | ||
+ | [[v5: | ||
== Syntax == | == Syntax == | ||
- | setFetchMode( | + | |
- | optional int $fetchType | + | optional int $fetchMode |
) | ) | ||
Line 13: | Line 15: | ||
==== 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 24: | 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 43: | Line 44: | ||
</ | </ | ||
- | ===== Constants | + | ====== Fetch Both ===== |
- | + | Some databases support a 'Fetch Both' mode, which can be set using '' | |
- | ^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 | + | |
- | |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 all databases| | + | |
- | + | ||
- | ===== Syntax ===== | + | |
<code php> | <code php> | ||
- | $ADODB_FETCH_MODE = ADODB_FETCH_NUM; | + | $db->setFetchMode(ADODB_FETCH_BOTH) |
- | + | $rs3 = $db->execute(' | |
- | $rs1 = $db->Execute(' | + | print_r($rs3-> |
- | + | ||
- | $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; | + | |
- | + | ||
- | $rs2 = $db->Execute(' | + | |
- | + | ||
- | print_r($rs1-> | + | |
/* | /* | ||
shows _array([0]=>' | shows _array([0]=>' | ||
- | [1] =>' | + | [' |
+ | [1] =>' | ||
+ | | ||
+ | ) | ||
*/ | */ | ||
- | print_r($rs2-> | + | </code> |
- | /* | + | |
- | * shows _array([' | + | |
- | [' | + | |
- | */ | + | |
- | </ |
v5/reference/connection/setfetchmode.txt · Last modified: 2020/01/05 12:30 by dregad