v5:reference:connection:setfetchmode
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
reference:setfetchmode [2015/07/12 21:01] – [Constants] mnewnham | v5:reference:connection:setfetchmode [2018/06/11 10:18] – [Usage] function names starting with lowercase (#426) dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== setFetchMode() ====== | + | ====== setFetchMode ====== |
+ | ~~NOTOC~~ | ||
- | ===== Constants ===== | + | 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 '' |
+ | <WRAP right 300px box> | ||
+ | == See Also == | ||
+ | [[v5: | ||
+ | [[v5: | ||
+ | == Syntax | ||
+ | int setFetchMode( | ||
+ | optional int $fetchMode | ||
+ | ) | ||
- | ^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| | + | ==== Use as a getter ==== |
- | |ADODB_FETCH_NUM|1|The recordset is returned as a numeric array| | + | Use < |
- | |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. | + | ==== Constants ==== |
+ | ^ Name | ||
+ | | ADODB_FETCH_DEFAULT | ||
+ | | ADODB_FETCH_NUM | ||
+ | | ADODB_FETCH_ASSOC | ||
+ | | ADODB_FETCH_BOTH | ||
- | ===== Syntax | + | ===== Usage ===== |
<code php> | <code php> | ||
- | $ADODB_FETCH_MODE = ADODB_FETCH_NUM; | + | $db-> |
+ | $rs1 = $db-> | ||
- | $rs1 = $db->Execute(' | + | $db->setFetchMode(ADODB_FETCH_ASSOC) |
- | + | $rs2 = $db->execute(' | |
- | $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; | + | |
- | + | ||
- | $rs2 = $db->Execute(' | + | |
print_r($rs1-> | print_r($rs1-> | ||
Line 32: | Line 44: | ||
</ | </ | ||
+ | ====== Fetch Both ===== | ||
+ | Some databases support a 'Fetch Both' mode. In this mode, the value are returned as both a numeric and an associative array, interspersed. | ||
+ | <code php> | ||
+ | shows _array([0]=>' | ||
+ | | ||
+ | [1] =>' | ||
+ | | ||
+ | ) | ||
+ | |||
+ | </ | ||
+ | This mode can be set using '' | ||
+ |
v5/reference/connection/setfetchmode.txt · Last modified: 2020/01/05 12:30 by dregad