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 revisionPrevious revision
Next revision
Previous revision
reference:adodb_fetch_mode [2015/07/12 20:46] 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|
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)