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> <OCI8
Last updated: Fri, 14 Nov 2008

view this page in

Fonctions OCI8

Sommaire



oci_bind_array_by_name> <OCI8
Last updated: Fri, 14 Nov 2008
 
add a note add a note User Contributed Notes
Fonctions 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> <OCI8
Last updated: Fri, 14 Nov 2008
 
 
show source | credits | stats | sitemap | contact | advertising | mirror sites