php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #1480 assigning null columns to an array doesnt seem to work
Submitted: 1999-06-01 01:27 UTC Modified: 2006-07-17 08:50 UTC
From: svd at excitecorp dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 3.0.8 OS: linux
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: svd at excitecorp dot com
New email:
PHP Version: OS:

 

 [1999-06-01 01:27 UTC] svd at excitecorp dot com
this code has some unexpected behavior:

while (OCIFetchInto($stmt,$row,OCI_RETURN_LOBS)){
  reset($formq[columns]);
  while($col=each($formq[columns])){
    $retrow[$col[value]]=$row[$col[key]];
  }
  $ret[]=$retrow;
}

if ocifetchinto returns a null into $col[x], then assigning to retrow["index"] has no effect on retrow (i.e. retrow["index"] is not instantiated... doing an each over retrow will not yeild an index "index")  I assume the expected behavior should be to instantiate retrow["index"] with an empty string.

here's my workaround:
$retrow[$col[value]]=sprintf("%s",$row[$col[key]]);

php 3.0.8 is the only non-standard module compiled into my apache server 1.3.4

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-06-01 02:12 UTC] thies at cvs dot php dot net
this is intended behaviour!

use OCIFetchInto($stmt,$row,OCI_RETURN_LOBS|OCI_RETURN_NULLS)
to also get array entries for columns which value is NULL.

you may also specify |OCI_ASSOC to get an associative array returned!

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 18:01:29 2024 UTC