Database Abstraction Layer for PHP

User Tools

Site Tools



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