how to connect oracle 9i to PHP on windows2007

I am using Oracle 9i database and PHP(5.6.33) for an application.
Application is showing PHP extension issue "None of the supported PHP extensions (OCI8, PDO_OCI) are available".
But i have tried to download couple of php extension named as OCI8.dll and PDO_OCI.dll to my PHP configuration file, but
still error is not going.Please help me on so I can connect oracle database with PHP.
SudhanshumAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris Harte2015 Top Expert (Most Article Points)Commented:
have you edited your php.ini file?
Search for oci8 and uncomment the line and pdo_oci as well.
0
Dave BaldwinFixer of ProblemsCommented:
You may also need to download the Oracle driver from their site.  See here:  http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-098155.html
0
SudhanshumAuthor Commented:
Hi Chris Harte, Yes I uncommented those lines and still I am getting error. What can be best solution so my  oracle 9i database can be connected with php server.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

SudhanshumAuthor Commented:
Hi Dave Baldwin, I downloaded software then what should be next step?
0
Dave BaldwinFixer of ProblemsCommented:
Follow the directions and install it.
0
NerdsOfTechTechnology ScientistCommented:
Is upgrading PHP an option?
0
SudhanshumAuthor Commented:
we downloaded that but how to setup oracle connection?
0
NerdsOfTechTechnology ScientistCommented:
Presuming you know how to install PHP and have done so...

Extract the zip file you downloaded from Oracle to a directory; then copy just the php_oci8_11g.dll into the c:/php/ext directory.

In the php.ini file uncomment the following line:
extension=php_oci8_11g.dll;

Open in new window

Also set the extension directory to ./ext in the php.ini file.
extension_dir = "./ext"

Open in new window

Then in PHP:

<?php 
$connection = oci_connect($username, $password, $db);
if (!$connection) {
   $e = oci_error();
   echo htmlentities($e['message']);
}else{
   echo 'CONNECTED!';
}
?>

Open in new window

0
SudhanshumAuthor Commented:
Hi NerdsOfTech,

I was trying your solution, I was getting "Fatal error: Call to undefined function oci_connect() " issue.
I think the dll you suggested is compatible for Oracle 11g, but actually I am working on Oracle 9i. And I want connect with Oracle 9i.
I was already trying php_oci_11g and php_oci8 dlls, but both are not worked to connect Oracle 9i.
0
NerdsOfTechTechnology ScientistCommented:
You are correct, my apologies; I had you copy over and uncomment the wrong version (11). You will need to re-comment the 11 version in php.ini. Download the newest oci8.

http://pecl.php.net/package/oci8 

Move over php_oci8.dll from the zip file to /ext (keep the /ext php.ini line uncommented) and enable the .dll (by uncommenting this line in php.ini):
extension=php_oci8.dll

Open in new window

IMPORTANT NOTE: Only one of these DLLs may be enabled (un-commented) at a time which means you can't access a 11i or 12i while running a 9.2 database.

PHP has fairly good documentation on installation, etc. here:
http://php.net/manual/en/oci8.installation.php

Oracle has an article too that's worth looking at:
http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html

EDIT: this isn't a simple task according to the LOADS of PHP.net notes... My solution is likely incomplete and it sounds as if you tried this already.

Some notes mentioned Oracle Instant Client being part of the whole solution:
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

One note mentioned, "Welcome to Oracle hell", which may sum up the installation/implementation of oci8...

Your mileage may vary. Best of luck to you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NerdsOfTechTechnology ScientistCommented:
A correctly edited php.ini and the newest drivers should do the trick.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.