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 revision Previous revision
v5:reference:connection:setfetchmode [2018/06/11 10:18]
dregad [Usage] function names starting with lowercase (#426)
v5:reference:connection:setfetchmode [2018/06/11 10:22] (current)
dregad [Fetch Both] Add full code example
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: 2018/06/11 10:22 by dregad