ocifetchinto

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

ocifetchinto — 結果配列の次の行を取得する (非推奨)

説明

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

この関数は推奨されません。代わりに推奨されるものは、 oci_fetch_array()、 oci_fetch_object()、 oci_fetch_assoc() および oci_fetch_row() です。

警告

この関数は、PHP 5.4.0 以降では非推奨となりました。この関数は決して使わないようにしましょう。

ocifetchstatement

ocifetch

[edit] Last updated: Fri, 25 May 2012

add a note User Contributed Notes ocifetchinto

php at natalian dot org 25-Oct-2005 01: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 06: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 10: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.

add a note