Differences

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

--- reference:setfetchmode [2015/12/24 16:14] – [Table] mnewnham
+++ v5:reference:connection:setfetchmode [2018/06/11 10:22] – [Fetch Both] Add full code example dregad
@@ Line 1: / Line 1: @@
 ====== setFetchMode ======
 ~~NOTOC~~
-<WRAP alert>
-Use of direct querying of the $fetchMode property, and use of setFetchMode() as a getter is deprecated as of version 5.21.0 and will be removed as of version 6.0.0. As of 5.21.0 you should use [[reference:getFetchMode|getFetchMode()]] intead
+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>
-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 ==
-[[reference:$ADODB_FETCH_MODE]]
+[[v5:reference:$ADODB_FETCH_MODE]]\\
-== 5.21.0 Syntax ==
+[[v5:reference:connection:getFetchMode()]]\\
+== Syntax ==
     int setFetchMode(
     optional int $fetchMode
     )
-== 6.0.0 Syntax ==
-    void setFetchMode(
-    int $fetchMode
-    )
 </WRAP>
 ==== Use as a getter ====
@@ Line 31: / 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 49: / Line 43: @@
  */
+</code>
+====== Fetch Both =====
+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>
+$db->setFetchMode(ADODB_FETCH_BOTH)
+$rs3 = $db->execute('select * from table');
+print_r($rs3->fields);
+/*
+  shows _array([0]=>'v0',
+               ['col1']=>'v0',
+               [1] =>'v1',
+               ['col2']=>'v1'
+               )
+*/
 </code>