reference/oci8/functions/oci-fetch-all.xml
d33a6756e7a94bc06164d2a97bb0a3ffa19e3471
d33a6756e7a94bc06164d2a97bb0a3ffa19e3471
...
...
@@ -12,9 +12,9 @@
12
12
<type>int</type><methodname>oci_fetch_all</methodname>
13
13
<methodparam><type>resource</type><parameter>statement</parameter></methodparam>
14
14
<methodparam><type>array</type><parameter role="reference">output</parameter></methodparam>
15
-
<methodparam choice="opt"><type>int</type><parameter>skip</parameter><initializer>0</initializer></methodparam>
16
-
<methodparam choice="opt"><type>int</type><parameter>maxrows</parameter><initializer>-1</initializer></methodparam>
17
-
<methodparam choice="opt"><type>int</type><parameter>flags</parameter><initializer><constant>OCI_FETCHSTATEMENT_BY_COLUMN</constant> + <constant>OCI_ASSOC</constant></initializer></methodparam>
15
+
<methodparam choice="opt"><type>int</type><parameter>offset</parameter><initializer>0</initializer></methodparam>
16
+
<methodparam choice="opt"><type>int</type><parameter>limit</parameter><initializer>-1</initializer></methodparam>
17
+
<methodparam choice="opt"><type>int</type><parameter>flags</parameter><initializer>OCI_FETCHSTATEMENT_BY_COLUMN | OCI_ASSOC</initializer></methodparam>
18
18
</methodsynopsis>
19
19
<para>
20
20
Fetches multiple rows from a query into a two-dimensional array.
...
...
@@ -53,7 +53,7 @@
53
53
</listitem>
54
54
</varlistentry>
55
55
<varlistentry>
56
-
<term><parameter>skip</parameter></term>
56
+
<term><parameter>offset</parameter></term>
57
57
<listitem>
58
58
<para>
59
59
The number of initial rows to discard when fetching the
...
...
@@ -63,11 +63,11 @@
63
63
</listitem>
64
64
</varlistentry>
65
65
<varlistentry>
66
-
<term><parameter>maxrows</parameter></term>
66
+
<term><parameter>limit</parameter></term>
67
67
<listitem>
68
68
<para>
69
69
The number of rows to return. The default is -1 meaning return
70
-
all the rows from <parameter>skip</parameter> + 1 onwards.
70
+
all the rows from <parameter>offset</parameter> + 1 onwards.
71
71
</para>
72
72
</listitem>
73
73
</varlistentry>
...
...
@@ -102,7 +102,8 @@
102
102
</table>
103
103
</para>
104
104
<para>
105
-
Arrays can be indexed by column heading or numerically.
105
+
Arrays can be indexed either by column heading or numerically.
106
+
Only one index mode will be returned.
106
107
<table>
107
108
<title><function>oci_fetch_all</function> Array Index Modes</title>
108
109
<tgroup cols="2">
...
...
@@ -153,7 +154,7 @@
153
154
&reftitle.returnvalues;
154
155
<para>
155
156
Returns the number of rows in <parameter>output</parameter>, which
156
-
may be 0 or more, &return.falseforfailure;.
157
+
may be 0 or more.
157
158
</para>
158
159
</refsect1>
159
160
...
...
@@ -320,7 +321,7 @@ oci_close($conn);
320
321
&reftitle.notes;
321
322
<note>
322
323
<para>
323
-
Using <parameter>skip</parameter> is very inefficient. All the
324
+
Using <parameter>offset</parameter> is very inefficient. All the
324
325
rows to be skipped are included in the result set that is
325
326
returned from the database to PHP. They are then discarded. It
326
327
is more efficient to use SQL to restrict the offset and range of
...
...
@@ -340,9 +341,9 @@ oci_close($conn);
340
341
</note>
341
342
<note>
342
343
<para>
343
-
In PHP versions before 5.0.0 you must
344
-
use <function>ocifetchstatement</function>
345
-
instead. &oci.name.compat.note;
344
+
Will not return rows from Oracle Database 12<emphasis>c</emphasis>
345
+
Implicit Result Sets. Use <function>oci_fetch_array</function>
346
+
instead.
346
347
</para>
347
348
</note>
348
349
</refsect1>
...
...
@@ -362,7 +363,6 @@ oci_close($conn);
362
363
</refsect1>
363
364
364
365
</refentry>
365
-
366
366
<!-- Keep this comment at the end of the file
367
367
Local variables:
368
368
mode: sgml
...
...
@@ -383,4 +383,3 @@ vim600: syn=xml fen fdm=syntax fdl=2 si
383
383
vim: et tw=78 syn=sgml
384
384
vi: ts=1 sw=1
385
385
-->
386
-
387
386