ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:setfetchmode

This is an old revision of the document!


setFetchMode

Use of direct querying of the $fetchMode property, and use of setFetchMode() as a getter is deprecated as of version 5.21.0 and will be removed as of version 6.0.0. As of 5.21.0 you should use getFetchMode() intead

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.

Syntax
  setFetchMode(
  optional int $fetchType
  )

Use as a getter

Use

setFetchMode()

without an argument to return the current fetch mode

Constants

NameValueDescription
ADODB_FETCH_DEFAULT0The recordset is returned in the default provided by the PHP driver. Use of this value is not recommended if writing cross-database applications
ADODB_FETCH_NUM1The recordset is returned as a numeric array
ADODB_FETCH_ASSOC2The recordset is returned as an associative array
ADODB_FETCH_BOTH3The record is returned as both a numeric and associative arrays

Usage

$db->setFetchMode(ADODB_FETCH_NUM);  
 
$rs1 = $db->Execute('select * from table');  
 
$db->setFetchMode(ADODB_FETCH_ASSOC)
 
$rs2 = $db->Execute('select * from table');  
 
print_r($rs1->fields); 
/*
  shows _array([0]=>'v0',
               [1] =>'v1')
*/
print_r($rs2->fields); 
/*
 * shows _array(['col1']=>'v0',
                ['col2'] =>'v1')
 */

Constants

NameValueDescription
ADODB_FETCH_DEFAULT0The recordset is returned in the default provided by the PHP driver. Use of this value is not recommended if writing cross-database applications
ADODB_FETCH_NUM1The recordset is returned as a numeric array
ADODB_FETCH_ASSOC2The recordset is returned as an associative array
ADODB_FETCH_BOTH3The record is returned as both a numeric and associative arrays. Not supported in all databases

Syntax

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;  
 
$rs1 = $db->Execute('select * from table');  
 
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;  
 
$rs2 = $db->Execute('select * from table');  
 
print_r($rs1->fields); 
/*
  shows _array([0]=>'v0',
               [1] =>'v1')
*/
print_r($rs2->fields); 
/*
 * shows _array(['col1']=>'v0',
                ['col2'] =>'v1')
 */
v5/reference/connection/setfetchmode.1436731435.txt.gz · Last modified: 2017/04/21 11:33 (external edit)