(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
oci_fetch_all — 獲取結(jié)果數(shù)據(jù)的所有行到一個數(shù)組
$statement,&$output,$skip = ?,$maxrows = ?,$flags = ?
oci_fetch_all()
從一個結(jié)果中獲取所有的行到一個用戶定義的數(shù)組。oci_fetch_all()
返回獲取的行數(shù)，出錯則返回 false。skip
是從結(jié)果中獲取數(shù)據(jù)時，最開始忽略的行數(shù)（默認(rèn)值是
0，即從第一行開始）。maxrows
是要讀取的行數(shù)，從第 skip
行開始（默認(rèn)值是 -1，即所有行）。
flags 參數(shù)可以是下列值的任意組合：
OCI_FETCHSTATEMENT_BY_ROW
OCI_FETCHSTATEMENT_BY_COLUMN（默認(rèn)值）
OCI_NUM
OCI_ASSOC
示例 #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。
注意:
在 PHP 5.0.0 之前的版本必須使用 ocifetchstatement() 替代本函數(shù)。該函數(shù)名仍然可用，為向下兼容作為 oci_fetch_all() 的別名。不過其已被廢棄，不推薦使用。
statement有效的 OCI8 報表標(biāo)識符
由 oci_parse() 創(chuàng)建，被 oci_execute()
或 REF CURSOR statement 標(biāo)識執(zhí)行。
outputThe 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.
skipThe 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.
| 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.
| 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.
示例 #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);
?>
示例 #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);
?>
示例 #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);
?>
注意:
Using
skipis 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.
注意:
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.
注意:
查詢返回巨大數(shù)量的數(shù)據(jù)行時，通過增大 oci8.default_prefetch 值或使用 oci_set_prefetch() 可顯著提高性能。
注意:
In PHP versions before 5.0.0 you must use ocifetchstatement() instead.