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
Next revision
Previous revision
Last revision Both sides next revision
v5:reference:connection:setfetchmode [2017/04/21 11:50]
127.0.0.1 external edit
v5:reference:connection:setfetchmode [2018/06/11 10:22]
dregad [Fetch Both] Add full code example
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.txt · Last modified: 2020/01/05 12:30 by dregad