php+获取数组行数据,获取结果数据的所有行到一个数组 - PHP 7 中文文档

(PHP 5, PHP 7, PECL OCI8 >= 1.1.0)

oci_fetch_all – 获取结果数据的所有行到一个数组

说明

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() 例子

/* 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 "

echo "

n";

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

echo "

$keyn";

}

echo "

n";

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

echo "

n";

foreach ($results as $data) {

echo "

$data[$i]n";

}

echo "

n";

}

echo "

n";

} else {

echo "No data found
n";

}

echo "$nrows Records Selected
n";

oci_free_statement($stmt);

oci_close($conn);

?>

oci_fetch_all() 如果出错则返回 FALSE。

Note:

在 PHP 5.0.0 之前的版本必须使用 [ocifetchstatement()](php7/function.ocifetchstatement)

替代本函数。该函数名仍然可用，为向下兼容作为

oci_fetch_all() 的别名。不过其已被废弃，不推荐使用。

参数

statement

有效的 OCI8 报表标识符

由 [oci_parse()](php7/function.oci-parse) 创建，被 [oci_execute()](php7/function.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()](php7/function.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()](php7/function.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

$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
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 "

foreach ($res as $col) {

echo "

n";

foreach ($col as $item) {

echo "

".($item !== null ? htmlentities($item, ENT_QUOTES) : "")."n";

}

echo "

n";

}

echo "

n";

oci_free_statement($stid);

oci_close($conn);

?>

Example #3 oci_fetch_all() example with OCI_FETCHSTATEMENT_BY_ROW

$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
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

$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
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()](php7/function.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()](php7/function.oci-fetch-array) is used.

Note:

查询返回巨大数量的数据行时，通过增大

[oci8.default_prefetch](php7/oci8.configuration)

值或使用 [oci_set_prefetch()](php7/function.oci-set-prefetch) 可显著提高性能。

Note:

In PHP versions before 5.0.0 you must

use [ocifetchstatement()](php7/function.ocifetchstatement)

instead. 在当前版本中，旧的函数名还可以被使用，但已经被废弃并不建议使用。

参见

[oci_fetch()](php7/function.oci-fetch) – Fetches the next row into result-buffer

[oci_fetch_array()](php7/function.oci-fetch-array) – Returns the next row from a query as an associative or numeric array

[oci_fetch_assoc()](php7/function.oci-fetch-assoc) – Returns the next row from a query as an associative array

[oci_fetch_object()](php7/function.oci-fetch-object) – Returns the next row from a query as an object

[oci_fetch_row()](php7/function.oci-fetch-row) – Returns the next row from a query as a numeric array

[oci_set_prefetch()](php7/function.oci-set-prefetch) – 设置预提取行数