Edit Report a Bug

    oci_result

    (PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)

    oci_result — フェッチした行からフィールドの値を取得する

    説明

    oci_result(resource $statement, string|int $column): mixed

    oci_fetch() によってフェッチされた現在の行のフィールド columnからデータを返します。

    OCI8 拡張モジュールによるデータ型マッピングの 詳細については、ドライバが サポートするデータ型 を参照ください。

    パラメータ

    statement

    column

    カラム番号 (1から始まる) またはカラム名 (大文字) のどちらかを使用可能です。 カラム名の大文字小文字は、Oracle のメタデータで定義されているものに会わせる必要があります。 カラムの作成時に大文字小文字を明示しなかった場合、メタデータ上は大文字で記録されています。

    戻り値

    抽象型 (ROWID, LOB, FILE) を除き、全てを文字列として返します。 エラーの場合、false を返します。

    例

    例1 oci_fetch() と oci_result() を組み合わせる例

    <?php

    $conn     = oci_connect('hr', 'welcome', 'localhost/XE');
    if (!    $conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
    }

    $sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
    $stid = oci_parse($conn, $sql);
    oci_execute($stid);

    while (    oci_fetch($stid)) {
    echo     oci_result($stid, 'LOCATION_ID') . " is ";
    echo     oci_result($stid, 'CITY') . "<br>\n";
    }

    // 表示:
    // 1000 is Roma
    // 1100 is Venice

    oci_free_statement($stid);
    oci_close($conn);

    ?>

    参考

    add a note add a note

    User Contributed Notes 9 notes

    up
    0
    erabbott at NOSPAMterra dot com dot br
    22 years ago
    Note that if you are making multiple table selects, you must specify an alias to each column.

    This wont work:
    ----------------------------------------
    $qry = "SELECT A.COL_ONE, B.COL_ONE FROM TABLE1 A, TABLE2 B";
    $stmt = OCIParse($conn, $qry);

    while(OCIFetch($stmt))
    {
        $a = OCIResult($stmt, "A.COL_ONE");
    ...
    ----------------------------------------

    But this will:
    ----------------------------------------
    $qry = "SELECT A.COL_ONE AS X, B.COL_ONE AS Y FROM TABLE1 A, TABLE2 B";
    $stmt = OCIParse($conn, $qry);

    while(OCIFetch($stmt))
    {
        $a = OCIResult($stmt, "X");
    ...
    ----------------------------------------

    Regards,
    up
    0
    dominic dot standage at revolutionltd dot com
    25 years ago
    OCIResult() requires the column name to be written in capitals, so OCIResult($stmt,"column") won't work, but OCIResult($stmt,"COLUMN") works fine. Hope that helps somebody out
    up
    -1
    luismanuelp at gmail dot com
    19 years ago
    I am trying to get a list of the first character of a character string.

    SELECT distinct substr(version,1,1) as COL1 FROM SPHVVERS where Version is not null order by 1

    This was working and then failed recently. I think it is because some of the strings now added contain a number as the first character.

    I found to get it to work I had to use decode statement. (To_Char did not work )

    SELECT distinct decode (substr(version,1,1),'1','?','0','!',substr(version,1,1)) as COL1 FROM SPHVVERS where Version is not null order by 1
    up
    -1
    erabbott at NOSPAMterra dot com dot br
    22 years ago
    As in my previous post, the same thing applies when using conversion functions in CLOB columns.

    Probably the same thing will occur to any conversion function that you use.

    So, this wont work

    SELECT ... TO_CHAR(MY_CLOB) ...

    $my_clob = OCIResult($stmt,"MY_CLOB");

    But this will:

    SELECT ... TO_CHAR(MY_CLOB) AS MYC ...

    $my_clob = OCIResult($stmt,"MYC");

    Best regards.
    up
    -2
    jthome at fcgov dot com
    21 years ago
    FYI--

    In order to modify Oracle dates (using NLS_DATE_FORMAT...), you must set $ORACLE_HOME first.  This environmental variable is best set in the server startup script (i.e., ./apachectl)

    --
    Jim
    up
    -1
    gabi at gambita dot de
    21 years ago
    if you want to join two tables having both the same column (e.g. 'id') but you don't want to (or cannot) specify all the other fields in these two tables (like erabbott mentioned), you can use:

    SELECT t1.*, t2.*, t1.id AS id1, t2.id AS id2
    FROM table1 t1, table2 t2;

    Note that this does _not_ work:

    SELECT *,t1.id AS id1, t2.id AS id2
    FROM table1 t1, table2 t2;
    up
    -2
    shayman at quiver dot com
    24 years ago
    As this function gets a 'mixed' variable type for the column index, you may use an integer to represent the column number. In this case, the count is starting from 1 and not from zero.
    I am not sure, but I think this method is a bit faster than using the column name.
    For an example, see the OCINumCols first example.
    up
    -3
    steve dot hurst at instem-lss dot co dot uk
    22 years ago
    I am trying to get a list of the first character of a character string.

    SELECT distinct substr(version,1,1) as COL1 FROM SPHVVERS where Version is not null order by 1

    This was working and then failed recently. I think it is because some of the strings now added contain a number as the first character.

    I found to get it to work I had to use decode statement. (To_Char did not work )

    SELECT distinct decode (substr(version,1,1),'1','?','0','!',substr(version,1,1)) as COL1 FROM SPHVVERS where Version is not null order by 1
    up
    -4
    dwilson at cae dot wisc dot edu
    23 years ago
    I complained that I couldn't get the time from an Oracle date field.  Joe Brown said:

    This is not a PHP bug.

    Consider setting NLS_DATE_FORMAT.

    The manual states OCIResult() returns everything as a string.
    NLS_DATE_FORMAT may not be appropriate for your needs.

    There are quite a few places you can set NLS_DATE_FORMAT.
    * Environment variables (or windows registry on win32)
    * orclSID.ora
    * on a per session basis; execute this statement after logon:

    $cursor=OCIParse($connection,
    "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'");
    OCIExecute($cursor);
    OCIFreeCursor($cursor);
    add a note add a note
    To Top