oci_fetch_all

PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0

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

Code Examples

Example #1 oci_fetch_all 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);

Edit/Test in Sandbox

PHP Version:

Example #2 oci_fetch_all example with <span class='function-constant'>OCI_FETCHSTATEMENT_BY_ROW</span>

Edit/Test in Sandbox

PHP Version:

Example #3 oci_fetch_all with <span class='function-constant'>OCI_NUM</span>

Edit/Test in Sandbox

PHP Version:

oci_fetch_all

Example #1 oci_fetch_all example

Example #2 oci_fetch_all example with <span class='function-constant'>OCI_FETCHSTATEMENT_BY_ROW</span>

Example #3 oci_fetch_all with <span class='function-constant'>OCI_NUM</span>

Function oci_fetch_all:

Oracle OCI8 Functions

Most used PHP functions