note 45515 deleted from function.oci-fetch-all by sixd
| From: | sixd@php.net | Date: | Fri, 20 Nov 2009 23:47:04 +0000 |
| Subject: | note 45515 deleted from function.oci-fetch-all by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163155@lists.php.net to get a copy of this message | ||
Note Submitter: phpnet at rafael dot eti dot br
----
Humberto, from the previous note misunderstood the function ocifetchstatement. The default value of
the last parameter is OCI_FETCHSTATEMENT_BY_COLUMN. That is the reason that $rows has the value 20
and count($arr) has the value 13 in:
$rows=ocifetchstatement ($st, &$arr, 0, 20);
It happens because his query probably had 13 columns.
That way, count($arr[0]) would have the value 20 that he expected of count($arr).
So,
$rows=ocifetchstatement ($st, &$arr, 0, 20);
is equivalent to
$rows=ocifetchstatement ($st, &$arr, 0, 20, OCI_FETCHSTATEMENT_BY_COLUMN);
and it is not equivalent to
$rows=ocifetchstatement ($st, &$arr, 0, 20, OCI_FETCHSTATEMENT_BY_ROW);
I hope this helps to avoid some confusion about ocifetchstatement.