note 53698 deleted from function.oci-fetch-array by sixd
| From: | sixd@php.net | Date: | Wed, 18 Nov 2009 22:45:03 +0000 |
| Subject: | note 53698 deleted from function.oci-fetch-array by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163050@lists.php.net to get a copy of this message | ||
Note Submitter:
----
OCI_BOTH is the default.
If you just need to return all fields, you can leave out OCI_NUM & OCI_ASSOC.
EXAMPLE:
<?php
$connection = ocilogon("user", "password", "dbname");
$query = "SELECT id, name, lob_field FROM fruits";
$statement = oci_parse ($connection, $query);
oci_execute ($statement);
while ($row = oci_fetch_array ($statement)) {
$id = $row['ID'];
$name = $row['NAME'];
$lob_field = $row['LOB_FIELD'];
echo $id.' '.$name.' '.$lob_field;
}
?>