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
reference:adodb_fetch_mode [2015/07/12 20:31] – created mnewnhamv5:reference:adodb_fetch_mode [2016/01/18 00:44] (current) – ↷ Links adapted because of a move operation 66.249.75.217
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.txt · Last modified: 2016/01/18 00:44 by 66.249.75.217