PHP
downloads | documentation | faq | getting help | mailing lists | wiki | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

oci_bind_array_by_name> <overload
Last updated: Sun, 25 Nov 2007

view this page in

Oracle 8 functions

Úvod

Tieto funkcie vám umo¾nia prístup k Oracle8 a Oracle7 databázam. Pou¾ívajú Oracle8 Call-Interface (OCI8)

Toto roz¹írenie je flexibilnej¹ie ako ¹tandardné Oracle roz¹írenie. Podporuje previazanie globálnych alebo lokálnych PHP a Oracle premenných, plná podpora LOB, FILE a ROWID a umo¾òuje pou¾íva» u¾ívateµsky definované premenné.

Požiadavky

Na pou¾ívanie tohto roz¹írenia budete potrebova» Oracle8 klientské kni¾nice.

Pred pou¾ívaním týchto funkcií sa uistite, ¾e máte korektne nastavené premenné prostredia Oracle pre Oracle u¾ívateµa, tak isto aj pre u¾ívateµa, pod ktorým be¾í vá¹ webserver. Budete potrebova» nasledujúce premenné:

  • ORACLE_HOME
  • ORACLE_SID
  • LD_PRELOAD
  • LD_LIBRARY_PATH
  • NLS_LANG
  • ORA_NLS33

Po nastavení premenných prostredia pre u¾ívateµa, pod ktorým be¾í webserver sa uistite, ¾e ste tohto u¾ívateµa (nobody, www) pridali aj do oracle skupiny(dba)).

Note: Ak vá¹ webserver nenabehne alebo padne hneï po ¹tarte Skontrolujte, èi je Apache zlinkovaný s pthread kni¾nicami: 

# ldd /www/apache/bin/httpd 
    libpthread.so.0 => /lib/libpthread.so.0 (0x4001c000)
    libm.so.6 => /lib/libm.so.6 (0x4002f000)
    libcrypt.so.1 => /lib/libcrypt.so.1 (0x4004c000)
    libdl.so.2 => /lib/libdl.so.2 (0x4007a000)
    libc.so.6 => /lib/libc.so.6 (0x4007e000)
    /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

Ak libpthread nie je na výpise, musíte prein¹talova» Apache: 
# cd /usr/src/apache_1.3.xx
# make clean
# LIBS=-lpthread ./config.status
# make
# make install

Na niektorých UnixWare je kni¾nica libthread namiesto libpthread. V takom prípade musia by» PHP a Apache konfigurované pomocou EXTRA_LIBS=-lthread.

Inštalácia

Musíte ma» PHP skompilované s voµbou --with-oci8[=DIR], kde DIR je ¹tandardne nastavená na premennú prostredia ORACLE_HOME.

Runtime Konfigurácia

Toto rozšírenie nemá žiadne konfiguračné direktívy definované v php.ini.

Typy zdrojov

Preddefinované Konštanty

Konštanty uvedené nižšie sú definované týmto rozšírením a budú dostupné iba keď rozšírenie bolo buď kompilované do PHP alebo dynamicky načítané za behu (runtime).

OCI_DEFAULT (integer)
OCI_DESCRIBE_ONLY (integer)
OCI_COMMIT_ON_SUCCESS (integer)
OCI_EXACT_FETCH (integer)
SQLT_BFILEE (integer)
SQLT_CFILEE (integer)
SQLT_CLOB (integer)
SQLT_BLOB (integer)
SQLT_RDD (integer)
OCI_B_SQLT_NTY (integer)
OCI_SYSDATE (integer)
OCI_B_BFILE (integer)
OCI_B_CFILEE (integer)
OCI_B_CLOB (integer)
OCI_B_BLOB (integer)
OCI_B_ROWID (integer)
OCI_B_CURSOR (integer)
OCI_B_BIN (integer)
OCI_FETCHSTATEMENT_BY_COLUMN (integer)
OCI_FETCHSTATEMENT_BY_ROW (integer)
OCI_ASSOC (integer)
OCI_NUM (integer)
OCI_BOTH (integer)
OCI_RETURN_NULLS (integer)
OCI_RETURN_LOBS (integer)
OCI_DTYPE_FILE (integer)
OCI_DTYPE_LOB (integer)
OCI_DTYPE_ROWID (integer)
OCI_D_FILE (integer)
OCI_D_LOB (integer)
OCI_D_ROWID (integer)

Príklady

Example#1 OCI Hints

<?php
// by sergo@bacup.ru

// Use option: OCI_DEFAULT for execute command to delay execution
OCIExecute($stmt, OCI_DEFAULT);

// for retrieve data use (after fetch):

$result = OCIResult($stmt, $n);
if (is_object ($result)) $result = $result->load();

// For INSERT or UPDATE statement use:

$sql = "insert into table (field1, field2) values (field1 = 'value',
 field2 = empty_clob()) returning field2 into :field2";
OCIParse($conn, $sql);
$clob = OCINewDescriptor($conn, OCI_D_LOB);
OCIBindByName ($stmt, ":field2", &$clob, -1, OCI_B_CLOB);
OCIExecute($stmt, OCI_DEFAULT);
$clob->save ("some text");
OCICommit($conn);

?>

Mô¾ete µahko pristupova» k ulo¾eným procedúram rovnako ako keby ste k nim pristupovali z príkazového riadku.

Example#2 Using Stored Procedures

<?php
// by webmaster@remoterealty.com
$sth = OCIParse ( $dbh, "begin sp_newaddress( :address_id, '$firstname',
 '$lastname', '$company', '$address1', '$address2', '$city', '$state',
 '$postalcode', '$country', :error_code );end;" );

// This calls stored procedure sp_newaddress, with :address_id being an
// in/out variable and :error_code being an out variable. 
// Then you do the binding:

   OCIBindByName ( $sth, ":address_id", $addr_id, 10 );
   OCIBindByName ( $sth, ":error_code", $errorcode, 10 );
   OCIExecute ( $sth );

?>

Table of Contents



oci_bind_array_by_name> <overload
Last updated: Sun, 25 Nov 2007
 
add a note add a note User Contributed Notes
OCI8
alvaro at demogracia dot com
10-Jun-2008 04:24
If you've followed the instructions and you can't even connect to the DB server, welcome to the Oracle hell. Most of the information you'll find is deprecated, incomplete, not for your platform, unnecessary or just plain wrong.

Typically, you won't need at all those complicate setups you'll read about and they'll probably make things harder. I suggest you get Systernal's "Filemon" utility (for Windows, in Unix you may do with strace) and find out what exact config files and DLLs are being tried by php.exe (or httpd.exe if PHP runs as Apache module or...). Pretty often, the issue is that (e.g.) TNSNAMES.ORA does not have the correct line ending or Apache is looking for a DLL that does not even exist in your hard disc; learning that prevents you to waste time adding more and more useless environmental variables.

Goog luck.
christopher dot jones at oracle dot com
17-Jun-2007 09:25
There are several good books on PHP and Oracle available - search your favorite bookstore.  There is also a free book from Oracle "The Underground PHP and Oracle Manual" that covers the OCI8 extension: http://otn.oracle.com/tech/php/pdf/underground-php-oracle-manual.pdf
(free registration for OTN required, IIRC). Disclaimer: I'm one of its authors.
James VL
28-Feb-2007 10:49
re: Andrei Kubar

I was using Oracle Instant Client on Windows XP, and was getting the

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_oci8.dll' - The specified module could not be found.

error at startup, even though I had done all (most?) of the PHP and Oracle setup routines.

For me it wasn't the lack of mfc*.dll files, but a simple PATH issue: in addition to defining the environment variable TNS_ADMIN, I had to include my instant client directory in my PATH.
darkstar_ae at hotmail dot com
25-Apr-2005 10:39
When fetching associative arrays, use uppercase string indices. It appears the PHP OCI Library is less lenient with the field names returned by Oracle.

e.g.

echo $row['field1']; // This won't return anything.

as opposed to:

echo $row['FIELD1'];
edahnke at consultant dot com
08-Jan-2002 12:01
Here's a little snipet that shows how to insert multiple clob fields. Worked for me.

$dbh = OCILogon($dst_user_name, $dst_password, $dst_db_name);

for($i = 0; $i < $src_rec_cnt; $i++) {
    $query = "insert into bid (id,time,resume,experience,comments) values ('$id[$i]','$time[$i]',empty_clob(),empty_clob(),empty_clob()) returning  resume,experience,comments into :resume,:experience,:comments";

    $stmt = OCIParse($dbh, $query);

    $clob1 = OCINewDescriptor($dbh, OCI_D_LOB);
    $clob2 = OCINewDescriptor($dbh, OCI_D_LOB);
    $clob3 = OCINewDescriptor($dbh, OCI_D_LOB);
   
    OCIBindByName ($stmt, ":resume", &$clob1, -1, OCI_B_CLOB);
    OCIBindByName ($stmt, ":experience", &$clob2, -1, OCI_B_CLOB);
    OCIBindByName ($stmt, ":comments", &$clob3, -1, OCI_B_CLOB);

    OCIExecute($stmt, OCI_DEFAULT);
   
    @$clob1->save ($resume[$i]);
    @$clob2->save ($experience[$i]);
    @$clob3->save ($comments[$i]);
   
    OCICommit($dbh);
doug at redhive dot com
19-Jul-2001 02:38
if you feel like you have too many oracle statements clouding up your php, i came up with a function to open a connection (if necessary), parse your sql statement, and return the executed query.  after you call the function, you can do whatever needs to be done.  makes like so much simpler: (do whatever you want with the errors)

function execute_query($query, &$connected) {
    global $ORACLE_USER, $ORACLE_PASS, $ORACLE_SID;

    if(!$connected) {
        $connected = @OCIPLogon($ORACLE_USER, $ORACLE_PASS,  $ORACLE_SID);

        if($error = OCIError()) {
            die("<font color=red>ERROR!! Couldn't connect to server!</font>");
        }
    }

    $stmt = @OCIParse($connected, $query);
    if($error = OCIError($cn))    {
        die("<font color=red>ERROR!! Statement syntax error!</font>");
    }

    @OCIExecute($stmt);
    if($error = OCIError($stmt)) {
        die("<font color=red>ERROR!! Could not execute statement!</font>");
    }

    return $stmt;
}
jasendorf at lcounty dot com
23-May-2001 03:48
VERY IMPORTANT!  OCIPLogon only keeps a persistent connection if you are running PHP as a module.  This is particularly important to Windows users who are used to running PHP as a CGI.
junk at netburp dot com
19-Oct-2000 02:39
Here's a clue about rowid.

Don't forget about the oracle functions:

"rowidtochar" and "chartorowid"

"select rowidtochar(rowid) as FOO from table ...."

When you want to pass the rowid in a form or link, that's
the only way to go.
add a note add a note

oci_bind_array_by_name> <overload
Last updated: Sun, 25 Nov 2007
 
 
show source | credits | stats | sitemap | contact | advertising | mirror sites