PHP: ocifetchinto

Описание

int ocifetchinto ( resource statement, array &result [, int mode] )

Замечание: Эта функция устарела и не рекомендуется к использованию. Вместо неё вы можете использовать функции oci_fetch_array(), oci_fetch_object(), oci_fetch_assoc(), oci_fetch_row().

ocifetchinto() выбирает следующую строку из результат запроса в массив result. ocifetchinto() перезапишет сверху содержимое переменной result. По умолчанию result будет содержать массив с числовыми индексами и значениями полей, которые не равны NULL.

Параметр mode позволяет менять поведение по умолчанию. Вы можете указывать несколько флагов одновременно, просто суммируя их (например, OCI_ASSOC+OCI_RETURN_NULLS). Возможные флаги:

OCI_ASSOC - возврашать ассоциативный массив.

OCI_NUM - возвращать массив с числовыми индексами (поведение по умолчанию).

OCI_RETURN_NULLS - возвращать поля, которые равны NULL.

OCI_RETURN_LOBS - возвращать значение LOB вместо дескриптора.

Пример 1. Пример использования ocifetchinto()

<?php $conn = ocilogon("username", "password"); $query = "SELECT apples FROM oranges"; $statement = OCIParse ($conn, $query); OCIExecute ($statement); while (OCIFetchInto ($statement, $row, OCI_ASSOC)) { echo $row['apples']; } ?>

См. также oci_fetch_array(), oci_fetch_object(), oci_fetch_assoc(), oci_fetch_row(), oci_fetch() и oci_execute().

ocifetchinto

php at natalian dot org
24-Oct-2005 04: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);

?>

jafar78 at comcast dot net
27-Apr-2005 09:23


Hi, the following is a simple connect and select which creates a single elment array. One can also create a multiDementional array out of this.  I hope this can help.  



<?php

$DB_USER="DB user name"; 

$DB_PASSWD="DB passwd";

$DB="TNS name of your DB";

$connection = OCILogon ($DB_USER, $DB_PASSWD, $DB);

if ($connection == false){

  echo OCIError($connection)."<BR>";

  exit();

}

$ColName="your col name";

$TableName="your table name";

$YourOrderby="your order by col";

   $query = "SELECT $ColName from $TableName ORDER BY $yourOrderby";

   $cursor = ociparse($connection, $query);

   ociexecute($cursor);

   $Rrows = ocifetchstatement($cursor, $results);

   echo "Found: $Rrows results<br><br>\n";

   

   $myarray = array ();



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



        $myarray[$i]= $results["$ColName"][$i];

 

   };

  //This will print all the elements in the array

//or you can print one element=$myarray[0]

 for ($j=0; $j <  $Rrows; $j++){

   echo "myarrayElement$j=$myarray[$j]<br>";

}

McKay Salisbury
10-May-2004 04:10


test1 said that it has to be in all caps, but that isn't the case. Oracle is case sensitive, but it has weird case sensitivity behavior.



oracle takes all identifiers, and "To_Upper"s them, unless they are in double quotes, which it treats as exact case (Single quotes are used for string delimiters)



then a table with the name "BLAH" having columns "Blah1", "BLAH2", and "BLAH3" could be accessed by the SQL statement

select "Blah1", blah2, "BLAH3" from bLaH;

which is the same as

select "Blah1", "BLAH2", bLaH3 from blah;

(note that there is only one way to reference something that is stored in mixed or lower case, i.e. in its proper case, with strings around it



so if a table is created with mixed case and double quotes, then that's how they'll come out of the orifetchinto statement and they will not be all upper case, but most of the time Oracle DBAs (especially dba's recently transferred from a different DBMS) tend to leave the double quotes off all the time, and it appears as if oracle is case insensitive.

cjbj at hotmail dot com
07-Jan-2004 06:29


In Oracle's terms a column alias is a temporary name assigned to a

column.  In "SELECT EMP.ENAME EX1 FROM EMP" the column name is "ENAME"

and the column alias is "EX1".



Associative arrays can be used with duplicate columns if the columns

have aliases.  In the example below the aliases id1 and id2 have been

added.



<?php

$sql = "select a.id id1, b.id id2 from ref a, library b where a.id = b.id";

// ...parsed and executed...

ocifetchinto($stmt, $row, OCI_ASSOC);

Array

(

   [ID2] => 948

   [ID1] => 948

)

*/

?>

Guillaume Cocatre-Zilgien
18-Dec-2003 10:39


The use of ocifetchinto() with the OCI_ASSOC parameter is not suitable for queries with aliased columns: the columns' real names, *not* their aliases, are used as keys in the associative array, causing some values to be overwritten.



<?php

$sql = "select a.id, b.id from ref a, library b where a.id = b.id";

// ...parsed and executed...

ocifetchinto($stmt, $row, OCI_ASSOC);

/* print_r($row) will return only one value instead of two:

Array

(

    [ID] => 948

)

*/

?>

test1 at cet99 dot com
31-Jul-2003 06:40


The returned associative array should have the keys in all uppercase. Otherwise, you will get only null values.

gid <gid at gifpaste.net>
20-May-2003 01:00


With oracle 9i, setting the NLS_DATE_FORMAT variable under Linux didn't want to work with command line php.  I tried export before running php, and putenv inside of php.



So I used the ALTER SESSION command instead to make the date fields return the date AND time by default.  Running the query "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'" worked like a charm.  And it remains effective throughout entire oracle session.

russ at zerotech.net
28-Apr-2003 01:22


In response to an easy way to return an object instead of an array, simply take the array returned, for example:



ocifetchinto($stmt, $myarray, OCI_ASSOC);

$myobject = (object)$myarray;



It will automatically cast into stdClass, and assign a member for each key in $myarray. You can cast like this with anything, including from object back to array.

dan at calleope dot fsnet dot com
11-Mar-2003 11:10


By default Oracle 8i (and I guess 9i) return date type columns in the format "DD MON YY", which can be a problem if you want the time. You can convert these columns in your SELECT statements with the TO_CHAR function, but it is much nicer to make Oracle return ISO 8601 complient dates!



Try setting an environment var for NLS_DATE_FORMAT before you connect to your DB.



The following has worked for me in Apache & IIS on Windows... but it might work on *NIX?



$datetime = 'YYYY-MM-DD HH24:MI:SS';

putenv("NLS_DATE_FORMAT=$datetime");



You can also set this up in the Windows registry:

Key: "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0"

Make a new String value called "NLS_DATE_FORMAT" with a value of "YYYY-MM-DD HH24:MI:SS"



Hope that this helps someone else.

xerxes at dataforce dot com dot au
03-Oct-2002 09: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

Maxwell_Smart at ThePentagon dot com
09-Aug-2002 12:29


When using OCI_RETURN_LOBS to get a BFILE (stored with a DIRECTORY) the user needs READ on the DIRECTORY.  (GRANT READ on DIRECTORY <directory name> TO <user>;) Otherwise, you'll get a cryptic error. Warning: OCILobFileOpen: ORA-22285: non-existent directory or file for FILEOPEN operation in ... on line ...

<BR>

The user that CREATEs the DIRECTORY is automatically GRANTed READ WITH THE GRANT OPTION.

kboyer at matchlogic dot com
14-Jul-2000 01: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.