ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:getrowassoc

getRowAssoc

Using this function when the fetch mode is set to ADODB_FETCH_ASSOC may produce unpredictable results

Currently, after the first call to getRowAssoc, any changes to $upperCase have no effect

Syntax
mixed getRowAssoc(
      optional bool $upperCase=true
      )

Description

The function getRowAssoc() returns the current row of a recordset in associative mode if the recordset was originally fetched in numeric mode. The second parameter $upperCase indicates whether the keys of the recordset should be upper case or lower case. The constant ADODB_ASSOC_CASE has no effect on the returned row keys.


Usage

/* 
 * Database connection assumed
 */
$db->setFetchMode(ADODB_FETCH_NUM);
$SQL = "SELECT * FROM act";
$result = $db->execute($SQL);
$r = $result->fetchRow();
print_r($r);
/*
 * Prints 
Array
(
    [0] => 10
    [1] => MANAGE
    [2] => MANAGE/ADVISE
)
 
 
 */
$r = $result->getRowAssoc(false);
print_r($r);
/*
 * Prints
Array
(
    [actno] => 20
    [actkwd] => ECOST
    [actdesc] => ESTIMATE COST */
v5/reference/connection/getrowassoc.txt · Last modified: 2016/01/17 01:08 by mnewnham