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:connection:setfetchmode [2016/03/14 00:12] mnewnhamv5: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. 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 == 
-[[v5:reference:$ADODB_FETCH_MODE]]\\ 
-[[v5:reference:connection:getFetchMode()]]\\ 
 == Syntax == == Syntax ==
     int setFetchMode(     int setFetchMode(
Line 12: Line 9:
     )     )
  
 +== See Also ==
 +[[v5:reference:$ADODB_FETCH_MODE]]\\
 +[[v5:reference:connection:getFetchMode()]]\\
 </WRAP> </WRAP>
 ==== Use as a getter ==== ==== Use as a getter ====
Line 27: 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 47: Line 45:
 </code> </code>
 ====== Fetch Both ===== ====== 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> <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> </code>
-This mode can be set using ''ADODB_FETCH_MODE'' 
  
v5/reference/connection/setfetchmode.1457910777.txt.gz · Last modified: 2017/04/21 11:33 (external edit)