Differences

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

--- reference:adodb_fetch_mode [2015/07/12 20:46] – mnewnham
+++ v5: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 ======
-<WRAP right 400px>
+<WRAP right 200px box>
-<WRAP info>
+== See Also ==
+[[v5:reference:connection:setfetchmode]]
+== Definition ==
 |Type|Integer|
 |Default|0|
@@ Line 10: / Line 11: @@
 </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 =====
 <code php>
 $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>
 ===== 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()]]