ID: 35344
Updated by: [EMAIL PROTECTED]
Reported By: sdb at mail dot chita dot ru
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: Red Hat Enterprise Linux AS
PHP Version: 5.0.5
New Comment:
"A subsequent call to oci_fetch_assoc() will return the next row or
FALSE if there are no more rows."
Previous Comments:
------------------------------------------------------------------------
[2005-11-24 06:22:02] sdb at mail dot chita dot ru
The result of var_dump($a) is: "bool(false)"
------------------------------------------------------------------------
[2005-11-23 09:18:57] [EMAIL PROTECTED]
Try doing 'var_dump($a);'
------------------------------------------------------------------------
[2005-11-23 07:19:35] sdb at mail dot chita dot ru
Description:
------------
My script successfully connects to oracle, parse and execute simple
query (select * from some_table).
Functions oci_fetch_assoc, oci_fetch_array, oci_fetch_row does not
return an array. When I try to do "each" with returned array, PHP
prints "Variable passed to each() is not an array or object"
oci_num_fields returns right count of columns in result and
oci_field_name returns right column names in loop.
Function oci_fetch_all works good, it returns result (array of fields
and values), that I expect.
Reproduce code:
---------------
$c=oci_new_connect("a", "b" , "c", "AMERICAN_AMERICA.CL8MSWIN1251");
$s = oci_parse($c, "SELECT NAME from ABONENT");
if (oci_execute($s, OCI_DEFAULT))
{
while($a=oci_fetch_assoc($s)) {
while (list($key, $val) = each($a))
{
echo $key." = ".$val."<br>";
};
};
};
Expected result:
----------------
Something like that:
NAME = aaa
NAME = bbb
...
Actual result:
--------------
Warning: Variable passed to each() is not an array or object in
/var/www/test3.php on line 27
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35344&edit=1
