ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:setfetchmode

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
v5:reference:setfetchmode [2016/01/13 02:31] – ↷ Links adapted because of a move operation mnewnhamv5:reference:connection:setfetchmode [2020/01/05 12:30] (current) dregad
Line 1: Line 1:
 ====== setFetchMode ======  ====== setFetchMode ====== 
 ~~NOTOC~~ ~~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 [[v5: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> <WRAP right 300px box>
-== See Also == +== Syntax ==
-[[v5:reference:adodb_fetch_mode]]\\ +
-[[v5:reference:getfetchmode]]\\ +
-== 5.21.0 Syntax ==+
     int setFetchMode(     int setFetchMode(
     optional int $fetchMode     optional int $fetchMode
     )     )
-== 6.0.0 Syntax == + 
-    void setFetchMode( +== See Also == 
-    int $fetchMode +[[v5:reference:$ADODB_FETCH_MODE]]\\ 
-    )+[[v5:reference:connection:getFetchMode()]]\\
 </WRAP> </WRAP>
 ==== Use as a getter ==== ==== Use as a getter ====
Line 32: Line 27:
 <code php> <code php>
 $db->setFetchMode(ADODB_FETCH_NUM);   $db->setFetchMode(ADODB_FETCH_NUM);  
- +$rs1 = $db->execute('select * from table');  
-$rs1 = $db->Execute('select * from table');  +
  
 $db->setFetchMode(ADODB_FETCH_ASSOC) $db->setFetchMode(ADODB_FETCH_ASSOC)
- +$rs2 = $db->execute('select * from table');  
-$rs2 = $db->Execute('select * from table');  +
  
 print_r($rs1->fields);  print_r($rs1->fields); 
Line 50: 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> </code>
  
v5/reference/connection/setfetchmode.1452648698.txt.gz · Last modified: 2017/04/21 11:33 (external edit)