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

Next revision
Previous revision
v5:reference:adodb_fetch_mode [2015/07/12 20:31]
mnewnham created
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|
  
 </​WRAP>​ </​WRAP>​
-<WRAP alert> 
-Do not confuse with the [[reference:​setFetchMode|setFetchMode()]] function 
  
-</​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.
-</​WRAP>​+
  
-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 ===== 
  
 +===== Constants ​ =====
 ^Name^Value^Description^ ^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_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_NUM|1|The recordset is returned as a numeric array|
 |ADODB_FETCH_ASSOC|2|The recordset is returned as an associative 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|+|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 =====
 +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.1436725866.txt.gz · Last modified: 2017/04/21 11:31 (external edit)