锟斤拷取锟斤拷锟斤拷锟斤拷莸锟斤拷锟斤拷锟斤拷械锟揭伙拷锟斤拷锟斤拷锟�

说锟斤拷

oci_fetch_all ( resource $statement , array &$output [, int $skip [, int $maxrows [, int $flags ]]] ) : int

oci_fetch_all() 锟斤拷一锟斤拷锟斤拷锟斤拷谢锟饺★拷锟斤拷械锟斤拷械锟揭伙拷锟斤拷没锟斤拷锟斤拷锟斤拷锟斤拷锟介。oci_fetch_all() 锟斤拷锟截伙拷取锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟津返伙拷 FALSE锟斤拷skip 锟角从斤拷锟斤拷谢锟饺★拷锟斤拷锟绞憋拷锟斤拷羁硷拷锟斤拷缘锟斤拷锟斤拷锟斤拷锟侥拷锟街碉拷锟� 0锟斤拷锟斤拷锟接碉拷一锟叫匡拷始锟斤拷锟斤拷maxrows 锟斤拷要锟斤拷取锟斤拷锟斤拷锟斤拷锟斤拷锟接碉拷 skip 锟叫匡拷始锟斤拷默锟斤拷值锟斤拷 -1锟斤拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷锟斤拷

flags 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷希锟�

OCI_FETCHSTATEMENT_BY_ROW
OCI_FETCHSTATEMENT_BY_COLUMN锟斤拷默锟斤拷值锟斤拷
OCI_NUM
OCI_ASSOC

Example #1 oci_fetch_all() 锟斤拷锟斤拷


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

oci_fetch_all() 锟斤拷锟斤拷锟斤拷锟斤拷蚍祷锟� FALSE锟斤拷

Note:
锟斤拷 PHP 5.0.0 之前锟侥版本锟斤拷锟斤拷使锟斤拷 ocifetchstatement() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷煤锟斤拷锟斤拷锟斤拷锟饺伙拷锟斤拷茫锟轿拷锟斤拷录锟斤拷锟斤拷锟轿� oci_fetch_all() 锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟窖憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡硷拷使锟矫★拷

锟斤拷锟斤拷

statement

锟斤拷效锟斤拷 OCI8 锟斤拷锟斤拷锟绞讹拷锟� 锟斤拷 oci_parse() 锟斤拷锟斤拷锟斤拷锟斤拷 oci_execute() 锟斤拷 REF CURSOR statement 锟斤拷识执锟叫★拷

output

The variable to contain the returned rows.

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

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

skip

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

maxrows

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

flags

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

**oci_fetch_all()** Array Structure Modes
Constant	Description
`OCI_FETCHSTATEMENT_BY_ROW`	The outer array will contain one sub-array per query row.
`OCI_FETCHSTATEMENT_BY_COLUMN`	The outer array will contain one sub-array per query column. This is the default.

Arrays can be indexed by column heading or numerically.

**oci_fetch_all()** Array Index Modes
Constant	Description
`OCI_NUM`	Numeric indexes are used for each column's array.
`OCI_ASSOC`	Associative indexes are used for each column's array. This is the default.

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 var_dump() on output to verify the appropriate case to use for each query.

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 output, which may be 0 or more, 锟斤拷锟斤拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE.

锟斤拷锟斤拷

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

?>

Example #3 oci_fetch_all() example with OCI_FETCHSTATEMENT_BY_ROW


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

?>

Example #4 oci_fetch_all() with OCI_NUM


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

?>

注锟斤拷

Note:
Using skip 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 oci_fetch_array() for an example.

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

Note:
锟斤拷询锟斤拷锟截巨达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷通锟斤拷锟斤拷锟斤拷 oci8.default_prefetch 值锟斤拷使锟斤拷 oci_set_prefetch() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷堋锟�

Note:
In PHP versions before 5.0.0 you must use ocifetchstatement() instead. 锟节碉拷前锟芥本锟叫ｏ拷锟缴的猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆憋拷使锟矫ｏ拷锟斤拷锟窖撅拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷使锟矫★拷

锟轿硷拷

oci_fetch() - Fetches the next row into result-buffer
oci_fetch_array() - Returns the next row from a query as an associative or numeric array
oci_fetch_assoc() - Returns the next row from a query as an associative array
oci_fetch_object() - Returns the next row from a query as an object
oci_fetch_row() - Returns the next row from a query as a numeric array
oci_set_prefetch() - 锟斤拷锟斤拷预锟斤拷取锟斤拷锟斤拷