Podręcznik PHP
Poprzedni |  | Następny

# oci_fetch_array

(PHP 5)

oci_fetch_array -- Returns the next row from the result data as an associative or numeric array, or both

## Opis

array oci_fetch_array ( resource statement [, int mode] )

Returns an array, which corresponds to the next result row.

Więcej szczegółów na temat mapowania typów danych dokonywanego przez sterownik oci8 można uzyskać w rozdziale dotyczącym typów danych obsługiwanych przez ten sterownik

It should be mentioned here, that oci_fetch_array() is insignificantly slower, than oci_fetch_row(), but much more handy.

## Parametry

`statement`

  A valid OCI statement identifier.

`statement`

  An optional second parameter can be any combination of the following constants:

  `OCI_BOTH` - return an array with both associative and numeric indices (the same as `OCI_ASSOC` + `OCI_NUM`). This is the default behavior.
  `OCI_ASSOC` - return an associative array (as oci_fetch_assoc() works).
  `OCI_NUM` - return a numeric array, (as oci_fetch_row() works).
  `OCI_RETURN_NULLS` - create empty elements for the `NULL` fields.
  `OCI_RETURN_LOBS` - return the value of a LOB of the descriptor.

  Default `mode` is `OCI_BOTH`.

## Zwracane wartości

Returns an array with both associative and numeric indices, or `FALSE` if there are no more rows in the `statement`.

> Notatka: Ta funkcja ustala wartość pól NULL na `NULL`.

> Notatka: Oracle returns all field names in uppercase and associative indices in the result array will be uppercased too.

## Przykłady

Przykład 1. oci_fetch_array() with `OCI_BOTH` example

`<?php $connection = oci_connect("apelsin", "kanistra"); $query = "SELECT id, name FROM fruits"; $statement = oci_parse ($connection, $query); oci_execute ($statement); while ($row = oci_fetch_array ($statement, OCI_BOTH)) { echo $row[0]." and ".$row['ID']." is the same<br>"; echo $row[1]." and ".$row['NAME']." is the same<br>"; } ?>`

Przykład 2. oci_fetch_array() with `OCI_NUM` example

`<?php $connection = oci_connect("user", "password"); $query = "SELECT id, name, lob_field FROM fruits"; $statement = oci_parse ($connection, $query); oci_execute ($statement); while ($row = oci_fetch_array ($statement, OCI_NUM)) { echo $row[0]."<br>"; echo $row[1]."<br>"; echo $row[2]->read(100)."<br>"; //this will output first 100 bytes from LOB } ?>`

Przykład 3. oci_fetch_array() with `OCI_ASSOC` example

`<?php $connection = oci_connect("user", "password"); $query = "SELECT id, name, lob_field FROM fruits"; $statement = oci_parse ($connection, $query); oci_execute ($statement); while ($row = oci_fetch_array ($statement, OCI_ASSOC)) { echo $row['ID']."<br>"; echo $row['NAME']."<br>"; echo $row['LOB_FIELD']."<br>"; //this will output "Object id #1" } ?>`

Przykład 4. oci_fetch_array() with `OCI_RETURN_LOBS` example

`<?php $connection = oci_connect("user", "password"); $query = "SELECT id, name, lob_field FROM fruits"; $statement = oci_parse ($connection, $query); oci_execute ($statement); while ($row = oci_fetch_array ($statement, (OCI_NUM+OCI_RETURN_LOBS))) { echo $row[0]."<br>"; echo $row[1]."<br>"; echo $row['LOB_FIELD']."<br>"; //this will output LOB's content } ?>`

## Patrz także

oci_fetch_assoc()
oci_fetch_object()
oci_fetch_row()
oci_fetch_all()

Poprzedni | Spis treści | Następny
oci_fetch_all | Początek rozdziału | oci_fetch_assoc