Connectivity to Oracle thru PHP

Anon

Hi All
I'm not able to use any of the OCI functions, when I'm trying to connect to oracle. i.e. When I use OCILogon(username,password), i get the error :

Call to undefined function: ocilogon() in /u01/httpd/test/first.phtml on line 2

My first.phtml is :
<?
$conn=OCILogon("srini","srini");
$stmt=OCIParse($conn,"select name,id from test");
OCIDefineByName($stmt,"NAME",&$nm);
OCIDefineByName($stmt,"ID",&$newid);
OCIEXecute($stmt);
OCIFetch($stmt);
prinf("Name is ".$nm."<br>");
prinf("Id is ".$newid."<br>");
OCIFreeStatement($stmt);
?>

I've installed Linux Red hat 7, PHP 4.0 and Oracle 8.0 for Linux. (It works fine with Redhat 6.2). Oracle works fine individually.

I've configured php for oracle and mysql as well.

My PHPinfo() looks like :

'./configure' '--with-apache=../apache_1.3.12' '--with-mysql=/usr/local/mysql' '--with-OCI8=/u01/app/oracle/product/8.0.5' '--with-oracle=/u01/app/oracle/product/8.0.5' '--enable-memory-limit=yes' '--enable-debug=no' '--enable-track-vars'

Any Suggestions?

Your help is highly appreciated.

Thanks.

Nithya.

cvincent

The function is correct, but when PHP returns with "Call to undefined function", it means that your php setup does not have oracle support. I believe the option --with-oracle is only for oracle 7. Try the config script again without --with-oracle and when doing --with-oci8, read the ./configure output to make sure it says something like "checking for Oracle-OCI8 support... yes" and "checking Oracle Install-Dir..."
and "checking Oracle version...", make sure that they all print valid and correct output.

-Chris

Anon

HI
I believe for oracle 8 it should --with-oci8. In any case I will outline the steps to follow for configuring apache, php and oracle to work together.

Assuming you have unzipped and untared into apache and php folders of the same directory.

$cd apache
$./configure --prefix=/usr/local/apache --activate-module=src/modules/php4/libphp4.a
$cd ../php
$ ./configure --with-apache=../apache --with-oci8=$ORACLE_HOME --enable-sigchild #(important for oci8 installation)
$ make
$make install
$cd ../apache

need to run configure again, sometimes apache forgets the rule, run the one above.

$make
$make install

Also make sure after this installation you find a section with oci8 on your phpinof().
Another administration tip, if you have many hits on your scripts you will need to edit your apachectl and add
export LD_PRELOAD=/usr/lib/libpthread.so

as a first line in the file. Should avoid thread errors while connections.

Good luck !

Anon

Edit PHP.ini uncommenting the line 'extension=php_oci8'

Anon

Hi All,
Thanks for your support. I've tried all the above steps said by Kaushik and Marcio but still, there is no effect on the result. Still, I'm not able to connect with Oracle through PHP. Any suggestions?

Thanks a lot.

Nithya

Anon

hi there... You may find php-oracle solution in this link.
thanx n bye.
http://www.php.net/manual/en/ref.oracle.php