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
mixed getRowAssoc( optional bool $upperCase=true )
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.
/* * 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 */