Description

oci_fetch_all() fetches all the rows from a result into a user-defined array. oci_fetch_all() returns the number of rows fetched or FALSE in case of error. skip is the number of initial rows to ignore when fetching the result (default value of 0, to start at the first line). maxrows is the number of rows to read, starting at the skipth row (default to -1, meaning all the rows).

Parameter flags can be any combination of the following:

Przykład 1. oci_fetch_all() example <?php /* oci_fetch_all example mbritton at verinet dot com (990624) */ $conn = oci_connect("scott", "tiger"); $stmt = oci_parse($conn, "select * from emp"); oci_execute($stmt); $nrows = oci_fetch_all($stmt, $results); if ($nrows > 0) {    echo "<table border=\"1\">\n";    echo "<tr>\n";    while (list($key, $val) = each($results)) {       echo "<th>$key</th>\n";    }    echo "</tr>\n";        for ($i = 0; $i < $nrows; $i++) {       reset($results);       echo "<tr>\n";       while ($column = each($results)) {             $data = $column['value'];          echo "<td>$data[$i]</td>\n";       }       echo "</tr>\n";    }    echo "</table>\n"; } else {    echo "No data found<br />\n"; }       echo "$nrows Records Selected<br />\n"; oci_free_statement($stmt); oci_close($conn); ?>

oci_fetch_all() returns FALSE in case of error.