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
Last revisionBoth sides next revision
v5:reference:connection:setfetchmode [2018/06/11 10:18] – [Usage] function names starting with lowercase (#426) dregadv5:reference:connection:setfetchmode [2018/06/11 10:22] – [Fetch Both] Add full code example dregad
Line 45: 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.txt · Last modified: 2020/01/05 12:30 by dregad