Differences

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

--- v5:reference:connection:setfetchmode [2016/03/14 00:12] – mnewnham
+++ v5:reference:connection:setfetchmode [2020/01/05 12:30] (current) – dregad
@@ Line 4: / Line 4: @@
 If you have multiple connection objects, and want to have different fetch modes for each connection, then use SetFetchMode. Once this function is called for a connection object, that connection object will ignore the global variable ''$ADODB_FETCH_MODE'' and will use the internal fetchMode property exclusively.
 <WRAP right 300px box>
-== See Also ==
-[[v5:reference:$ADODB_FETCH_MODE]]\\
-[[v5:reference:connection:getFetchMode()]]\\
 == Syntax ==
     int setFetchMode(
@@ Line 12: / Line 9: @@
     )
+== See Also ==
+[[v5:reference:$ADODB_FETCH_MODE]]\\
+[[v5:reference:connection:getFetchMode()]]\\
 </WRAP>
 ==== Use as a getter ====
@@ Line 27: / Line 27: @@
 <code php>
 $db->setFetchMode(ADODB_FETCH_NUM);
+$rs1 = $db->execute('select * from table');
-$rs1 = $db->Execute('select * from table');
 $db->setFetchMode(ADODB_FETCH_ASSOC)
+$rs2 = $db->execute('select * from table');
-$rs2 = $db->Execute('select * from table');
 print_r($rs1->fields);
@@ Line 47: / Line 45: @@
 </code>
 ====== Fetch Both =====
-Some databases support a 'Fetch Both' mode. In this mode, the value are returned as both a numeric and an associative array, interspersed.
+Some databases support a 'Fetch Both' mode, which can be set using ''ADODB_FETCH_MODE''. In this mode, the recordset contains data as both a numeric and an associative array, interspersed.
 <code php>
-shows _array([0]=>'v0',
+$db->setFetchMode(ADODB_FETCH_BOTH)
-             ['col1']=>'v0',
+$rs3 = $db->execute('select * from table');
-             [1] =>'v1',
+print_r($rs3->fields);
-             ['col2']=>'v1'
+/*
-             )
+  shows _array([0]=>'v0',
+               ['col1']=>'v0',
+               [1] =>'v1',
+               ['col2']=>'v1'
+               )
+*/
 </code>
-This mode can be set using ''ADODB_FETCH_MODE''