OCI8 Obsolete Aliases and Functions
在线手册：中文 英文
PHP手册

ocifetchinto

(PHP 4, PHP 5, PECL OCI8 >= 1.0.0)

ocifetchinto — Fetches the next row into an array (deprecated)

说明

int ocifetchinto ( resource $statement , array &$result [, int $mode = OCI_ASSOC + OCI_NUM ] )

This function is deprecated. Recommended alternatives: oci_fetch_array(), oci_fetch_object(), oci_fetch_assoc() and oci_fetch_row().

Warning

自PHP 5.4.0起,此函数已经被废弃。 强烈建议不要应用此函数 。

OCI8 Obsolete Aliases and Functions
在线手册：中文 英文
PHP手册
PHP手册 - N: Fetches the next row into an array (deprecated)

用户评论:

php at natalian dot org (25-Oct-2005 12:45)

There might be a better way.

<?php

 $conn = OCILogon('user', 'secret', 'DB');

 $th = 0; // Table Header

       $query = 'select * from PAYMENT';

       $stid = OCIParse($conn, $query);
       OCIExecute($stid);

        echo "<table>\n\n";
        while (OCIFetchInto($stid, $row, OCI_ASSOC)) {
          if (!$th) {

            $keys = (array_keys($row));

            echo "\n<tr>\n";
            foreach ($keys as $k) {echo "<th>" . $k . "</th>\n";}
            echo "</tr>\n";

            $th = 1; // Table header done !
                    }

          echo "\n<tr>\n";
          foreach ($keys as $k) {echo "<td>" . $row[$k] . "</td>\n";}
          echo "</tr>\n";
          $count = $count + 1;
        }

        echo "</table>\n\n";

echo "<h3>" . $count . " records</h3>";

OCILogoff($conn);
?>

xerxes at dataforce dot com dot au (04-Oct-2002 05:37)

Hi all....

Following an eariler message about having similar functionality to "mysql_fetch_object", here is a snip of code i frequently use to return an array of all rows from a query....each element of the array is an object, where the properties for the object are the columns selected from the query.

Note that this function reqs that you pass in a connection handler....

It can be modified to return just a single row, quite easily.

    function executeSQL($SQL, $oConn) {
        $cur = OCIParse($oConn, $SQL);
       
        if (OCIExecute($cur, OCI_DEFAULT)) {
            $iCounter = 0;
            $aGeneric = Array();
            $TempClass = new stdClass ();
            while(OCIFetchInto($cur, $res, OCI_RETURN_NULLS + OCI_ASSOC)) {
                foreach ($res as $sKey => $sVal) {
                    $TempClass->{$sKey} = $sVal;
                }
                $aGeneric[$iCounter] = $TempClass;
               
                $iCounter++;
            }
        }
        else {
            return (false);
        }
        return ($aGeneric);
    }

hth!

-Xerxes

kboyer at matchlogic dot com (14-Jul-2000 09:26)

When using ocifetchinto, be careful with the resulting array.  If the array variable is previously populated before calling ocifetchinto, and the the ocifetchinto command returns no (0) rows, the array is not overwritten.  This can make you think that you actually got rows returned when you actually didn't.