PHP - Manual: oci_result

2024-11-14

oci_result

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

oci_result — 返回所取得行中字段的值

说明

oci_result(resource $statement, mixed $field): mixed

oci_result() 返回由 oci_fetch() 所取得的当前行中 field 字段的数据。oci_result() 对所有类型都返回字符串只除了抽象类型（ROWID，LOB 和 FILE）。oci_result() 在出错时返回 false。

可以使用列序号（从 1 开始）或列名（大写）作为 col 的参数。

注意:
在 PHP 5.0.0 之前的版本必须使用 ociresult() 替代本函数。该函数名仍然可用，为向下兼容作为 oci_result() 的别名。不过其已被废弃，不推荐使用。

要获取 OCI8 扩展进行数据类型映射的细节，请参见驱动所支持的数据类型。

参见 oci_fetch_array()，oci_fetch_assoc()，oci_fetch_object()，oci_fetch_row() 和 oci_fetch_all()。

参数

statement
field: Can be either use the column number (1-based) or the column name (in uppercase).

返回值

Returns everything as strings except for abstract types (ROWIDs, LOBs and FILEs). Returns false on error.

注释

注意:
In PHP versions before 5.0.0 you must use ociresult() instead. This name still can be used, it was left as alias of oci_result() for downwards compatability. This, however, is deprecated and not recommended.

参见

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() - 获取结果数据的所有行到一个数组

add a note

User Contributed Notes 9 notes

down

dominic dot standage at revolutionltd dot com ¶

22 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

erabbott at NOSPAMterra dot com dot br ¶

19 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

-1

luismanuelp at gmail dot com ¶

16 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 ¶

19 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

gabi at gambita dot de ¶

18 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

-2

shayman at quiver dot com ¶

21 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

dwilson at cae dot wisc dot edu ¶

21 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

-3

steve dot hurst at instem-lss dot co dot uk ¶

20 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

erabbott at NOSPAMterra dot com dot br ¶

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

add a note

官方地址：https://www.php.net/manual/en/function.oci-result.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHP mkdir()写出来的权限与mode值不符合 Packagist / Composer 中国全量镜像 PHP获取指定函数定义在哪个文件中及行号支持php7的性能采集扩展 adodb连接mysql多个数据库的问题

略微加速

PHP官方手册 - 互联网笔记

oci_result

说明

参数

返回值

注释

参见

User Contributed Notes 9 notes