oci_fetch_all

Fetches multiple rows from a query into a two-dimensional array

int **oci_fetch_all** resource $statement array $output int $offset int $limit int $flags

Fetches multiple rows from a query into a two-dimensional array. By default, all rows are returned.

This function can be called only once for each query executed with . oci_execute

statement``outputThe variable to contain the returned rows.

LOB columns are returned as strings, where Oracle supports conversion.

    See  for more information
    on how data and types are fetched.
  `oci_fetch_array`

offsetThe number of initial rows to discard when fetching the result. The default value is 0, so the first row onwards is returned.

limit The number of rows to return. The default is -1 meaning return all the rows from + 1 onwards. offset

flags Parameter indicates the array structure and whether associative arrays should be used.

  `flags`

Arrays can be indexed either by column heading or numerically. Only one index mode will be returned.

Use the addition operator "+" to choose a combination of array structure and index modes.

   Oracle's default, non-case sensitive column names will have
   uppercase array keys.  Case-sensitive column names will have
   array keys using the exact column case.
   Use 
   on  to verify the appropriate case
   to use for each query.
  `var_dump``output`

Queries that have more than one column with the same name should use column aliases. Otherwise only one of the columns will appear in an associative array.

Returns the number of rows in , which may be 0 or more. output

Voorbeeld: example

<?php

$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$stid = oci_parse($conn, 'SELECT POSTAL_CODE, CITY FROM locations WHERE ROWNUM < 3');
oci_execute($stid);

$nrows = oci_fetch_all($stid, $res);

echo "$nrows rows fetched<br>\n";
var_dump($res);

// var_dump output is:
//    2 rows fetched
//    array(2) {
//      ["POSTAL_CODE"]=>
//      array(2) {
//        [0]=>
//        string(6) "00989x"
//        [1]=>
//        string(6) "10934x"
//      }
//      ["CITY"]=>
//      array(2) {
//        [0]=>
//        string(4) "Roma"
//        [1]=>
//        string(6) "Venice"
//      }
//    }

// Pretty-print the results
echo "<table border='1'>\n";
foreach ($res as $col) {
    echo "<tr>\n";
    foreach ($col as $item) {
        echo "    <td>".($item !== null ? htmlentities($item, ENT_QUOTES) : "")."</td>\n";
    }
    echo "</tr>\n";
}
echo "</table>\n";

oci_free_statement($stid);
oci_close($conn);

?>

**Voorbeeld: example with **

<?php

$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$stid = oci_parse($conn, 'SELECT POSTAL_CODE, CITY FROM locations WHERE ROWNUM < 3');
oci_execute($stid);

$nrows = oci_fetch_all($stid, $res, null, null, OCI_FETCHSTATEMENT_BY_ROW);

echo "$nrows rows fetched<br>\n";
var_dump($res);

// Output is:
//    2 rows fetched
//    array(2) {
//      [0]=>
//      array(2) {
//        ["POSTAL_CODE"]=>
//        string(6) "00989x"
//        ["CITY"]=>
//        string(4) "Roma"
//      }
//      [1]=>
//      array(2) {
//        ["POSTAL_CODE"]=>
//        string(6) "10934x"
//        ["CITY"]=>
//        string(6) "Venice"
//      }
//    }

oci_free_statement($stid);
oci_close($conn);

?>

**Voorbeeld: with **

<?php

$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$stid = oci_parse($conn, 'SELECT POSTAL_CODE, CITY FROM locations WHERE ROWNUM < 3');
oci_execute($stid);

$nrows = oci_fetch_all($stid, $res, null, null, OCI_FETCHSTATEMENT_BY_ROW + OCI_NUM);

echo "$nrows rows fetched<br>\n";
var_dump($res);

// Output is:
//    2 rows fetched
//    array(2) {
//      [0]=>
//      array(2) {
//        [0]=>
//        string(6) "00989x"
//        [1]=>
//        string(4) "Roma"
//      }
//      [1]=>
//      array(2) {
//        [0]=>
//        string(6) "10934x"
//        [1]=>
//        string(6) "Venice"
//      }
//    }

oci_free_statement($stid);
oci_close($conn);

?>

Opmerking: > Using is very inefficient. All the rows to be skipped are included in the result set that is returned from the database to PHP. They are then discarded. It is more efficient to use SQL to restrict the offset and range of rows in the query. See for an example. offset``oci_fetch_array

Opmerking: > Queries that return a large number of rows can be more memory efficient if a single-row fetching function like is used. oci_fetch_array

Opmerking: >

Opmerking: > Will not return rows from Oracle Database 12 Implicit Result Sets. Use instead. coci_fetch_array

oci_fetch``oci_fetch_array``oci_fetch_assoc``oci_fetch_object``oci_fetch_row``oci_set_prefetch

Vorige ← oci_execute Volgende oci_fetch_array →

oci_fetch_all

oci_fetch_all

Documentatie