#11 oracle ADODB_ASSOC_CASE function
Hi folks,
I had to use the "oracle" driver and I needed the ADODB_ASSOC_CASE
function. I realized after readings posts etc. that this driver has not
implement this function, so I made it by myself and I hope that you can
use it.
./adodb/drivers/oracle.php
line: 272
function _fetch($ignore_fields=false) {
// should remove call by reference, but ora_fetch_into requires it in
4.0.3pl1
if($this->fetchMode & ADODB_FETCH_ASSOC){
$lowercase = (ADODB_ASSOC_CASE == 0);
$uppercase = (ADODB_ASSOC_CASE == 1);
$probe = array();
@ora_fetch_into($this->_queryID,&
$probe,ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC);
$arr2 = array();
$arrK = array_keys($probe);
$arrV = array_values($probe);
if (is_integer($arrK[$h])) $arrK[$h] = $arrV[$h];
else {
if ($lowercase){
$counter = count($arrK);
$Full = array();
$ev = array();
for ($i = 0; $i < $counter; $i++){
if ($arrV[$i] == NULL){
$Full = array($i=>NULL);
}else{
$Full = array($i=>$arrV[$i]);
}
$tmp_arr = array($arrK[$i]=>$arrV[$i]);
$sets = array_change_key_case($tmp_arr);
$ev = array_merge($Full, $sets);
$result = array_merge($result, $ev);
}
$arr2 = $result;
}
elseif ($uppercase){
$arr2 = array_change_key_case($probe,
CASE_UPPER);
}
else{
$arr2 = $probe;
}
}
return $this->fields = $arr2;
}
}
Logged In: YES
user_id=724867
Hi
Email to JLIM AT NATSOFT DOT COM the complete php file (not
a diff) and i will merge the code. Thanks.