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";
}

// Displays:
//   1000 is Roma
//   1100 is Venice

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

?>

参见

oci_fetch_array() - Returns the next row from a query as an associative or numeric array
oci_fetch_assoc() - Returns the next row from a query as an associative array
oci_fetch_object() - Returns the next row from a query as an object
oci_fetch_row() - Returns the next row from a query as a numeric array
oci_fetch_all() - 从查询中读取多行到二维数组中

改进此页面

了解如何改进此页面 • 提交拉取请求 • 报告一个错误

＋添加备注

用户贡献的备注 9 notes

down

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,

down

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

down

-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

down

-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

down

-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.

down

-3

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;

down

-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

down

-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);

down

-5

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.