oci_fetch_all

Fetches all rows of result data into an array (PHP 5, PECL oci8:1.1-1.2.4)
int oci_fetch_all ( resource statement, array &output [, int skip [, int maxrows [, int flags]]] )

Example 1642. 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";

   foreach ($results as $key => $val) {

      echo "<th>$key</th>\n";

   }

   echo "</tr>\n";


   for ($i = 0; $i < $nrows; $i++) {

      echo "<tr>\n";

      foreach ($results as $data) {

         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);
?>

Related Examples ( Source code ) » oci_fetch_all

Code Examples / Notes » oci_fetch_all

The number of rows returned is the number actually fetched, not the number potentially available. If one limits the number of rows to fetch, the number of rows returned will be bound by that limit. For example... $nrows = oci_fetch_all($statement, $results, 0, 1); would result in a returned value of '0' if there are no rows found for the statement, or '1' if any rows were found, regardless of the number actually present in the database.

It looks like passing 0 (zero) as a $maxrows parameter is treated identically as -1 value - all the rows are returned. OCIfetchstatement($stmt, $res, 1, 0, OCI_FETCHSTATEMENT_BY_ROW) Tested under: PHP 4.4.3, WinXP pro

If you want to use more than one flag, you need to use the + to connect them: <?php oci_fetch_all($stmt, $row, "0", "-1", OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW); ?>

oci_fetch_all

Fetches all rows of result data into an array (PHP 5, PECL oci8:1.1-1.2.4) int oci_fetch_all ( resource statement, array &output [, int skip [, int maxrows [, int flags]]] )

Example 1642. oci_fetch_all() example

Related Examples ( Source code ) » oci_fetch_all

Code Examples / Notes » oci_fetch_all

Change Language

Fetches all rows of result data into an array (PHP 5, PECL oci8:1.1-1.2.4)
int oci_fetch_all ( resource statement, array &output [, int skip [, int maxrows [, int flags]]] )