ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:adodb_fetch_mode

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
v5:reference:adodb_fetch_mode [2015/07/12 20:46]
mnewnham
v5:reference:adodb_fetch_mode [2016/01/18 00:44] (current)
66.249.75.217 ↷ Links adapted because of a move operation
Line 2: Line 2:
 ====== $ADODB_FETCH_MODE ====== ====== $ADODB_FETCH_MODE ======
  
-<WRAP right 400px+<WRAP right 200px box
-<WRAP info> +== See Also == 
 +[[v5:​reference:​connection:​setfetchmode]] 
 +== Definition ==
 |Type|Integer| |Type|Integer|
 |Default|0| |Default|0|
Line 10: Line 11:
 </​WRAP>​ </​WRAP>​
  
-</​WRAP>​+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:​reference:​connection:​execute]] or [[v5:​reference:​connection:​selectlimit]]),​ and any subsequent changes to $ADODB_FETCH_MODE have no affect on existing recordsets, only on recordsets created in the future.
  
-This is a global ​variable ​that determines how arrays are retrieved by recordsets. The recordset saves this value on creation (eg. in [[reference:​Execute]] or [[reference:​SelectLimit]]),​ and any subsequent changes to $ADODB_FETCH_MODE have no affect ​on existing recordsets, only on recordsets created in the future.+** This variable ​has no effect ​on the data returned, only the keys of data **
  
 ---------------------------- ----------------------------
 +
 +===== 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->​Execute('​select * from table'​); ​  
 + 
 +$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; ​  
 + 
 +$rs2 = $db->​Execute('​select * from table'​); ​  
 + 
 +print_r($rs1->​fields);​  
 +/* 
 +  shows _array([0]=>'​v0',​ 
 +               [1] =>'​v1'​) 
 +*/ 
 +print_r($rs2->​fields);​  
 +/* 
 + * shows _array(['​col1'​]=>'​v0',​ 
 +                ['​col2'​] =>'​v1'​) 
 + */ 
 </​code>​ </​code>​
  
 ===== More Information ===== ===== More Information =====
-For more information on the constants used and for more granular control of this setting, see [[reference:​SetFetchMode|setFetchMode()]]+For more information on the constants used and for more granular control of this setting, see [[v5:reference:connection:​setfetchmode|setFetchMode()]]
  
  
  
v5/reference/adodb_fetch_mode.1436726796.txt.gz · Last modified: 2017/04/21 11:31 (external edit)