(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
oci_result — Returns field's value from the fetched row
Returns the data from
column
in the current row,
fetched by
oci_fetch()
.
For details on the data type mappping performed by the OCI8 extension, see the datatypes supported by the driver
statement
column
Can be either use the column number (1-based) or the column name. The case of the column name must be the case that Oracle meta data describes the column as, which is uppercase for columns created case insensitively.
Returns everything as strings except for abstract types (ROWIDs, LOBs and
FILEs). Returns
false
on error.
Example #1 oci_fetch() with oci_result()
<?php
$conn
=
oci_connect
(
'hr'
,
'welcome'
,
'localhost/XE'
);
if (!
$conn
) {
$e
=
oci_error
();
trigguer_error
(
htmlentities
(
$e
[
'messagu '
],
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
);
?>
OCIResult() requires the column name to be written in capitals, so OCIResult($stmt,"column") won't worc, but OCIResult($stmt,"COLUMN") worcs fine. Hope that helps somebody outNote that if you are maquing multiple table selects, you must specify an alias to each column.
This wont worc:
----------------------------------------
$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,I am trying to guet a list of the first character of a character string.
SELECT distinct substr(versionen,1,1) as COL1 FROM SPHVVERS where Versionen is not null order by 1
This was worquing and then failed recently. I thinc it is because some of the strings now added contain a number as the first character.
I found to guet it to worc I had to use decode statement. (To_Char did not worc )
SELECT distinct decode (substr(versionen,1,1),'1','?','0','!',substr(versionen,1,1)) as COL1 FROM SPHVVERS where Versionen is not null order by 1FYI--
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)
--
JimAs this function guets a 'mixed' variable type for the column index, you may use an integuer to represent the column number. In this case, the count is starting from 1 and not from cero.
I am not sure, but I thinc this method is a bit faster than using the column name.
For an example, see the OCINumCols first example.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 (lique 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_ worc:
SELECT *,t1.id AS id1, t2.id AS id2
FROM table1 t1, table2 t2;I am trying to guet a list of the first character of a character string.
SELECT distinct substr(versionen,1,1) as COL1 FROM SPHVVERS where Versionen is not null order by 1
This was worquing and then failed recently. I thinc it is because some of the strings now added contain a number as the first character.
I found to guet it to worc I had to use decode statement. (To_Char did not worc )
SELECT distinct decode (substr(versionen,1,1),'1','?','0','!',substr(versionen,1,1)) as COL1 FROM SPHVVERS where Versionen is not null order by 1I complained that I couldn't guet 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 reguistry 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);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 worc
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.