Oracle DB connection with PHP

Question

I want to connect PHP with oracle DB. I have written the following code

<?php
$db_user='system';
$db_pass='19941992';
$db_name="webproj";

        $connection = oci_connect($db_name,$db_pass,'localhost/ORCL');
        if (!$connection) { 
    echo "Couldn't make a connection!"; 
    exit; 
    } 

?>

But its showing an error Fatal error: Call to undefined function oci_connect()

NB. I have installed php_oci8.dll . How can i solve this?

Did you add your dll to php.ini? is it correct php.ini? did you restart server? — E_p
– E_p, Commented Apr 9, 2013 at 21:34

Alex P · Accepted Answer · 2013-04-09 21:39:26Z

1

In order to use oci8 module, beside enabling php_oci8.dll you need to have installed an Oracle Client.
You can try Oracle 10gR2 Instant Client or Oracle 11gR2 Instant Client

Download from here: http://www.oracle.com/technetwork/topics/winsoft-085727.html
I suggest version 10.2.0.5, Instant Client Package - Basic Lite

answered Apr 9, 2013 at 21:39

Alex P

6025 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Muntashir Are Rahi Over a year ago

Oracle Express 10g is installed in my machine. Do i need to install Oracle instant client afterwards?

Alex P Over a year ago

run php from command line and check if there are any errors or run php -m to see loaded modules

Muntashir Are Rahi Over a year ago

enabling mod_fcgid module stops starting apache server. Note that i have 64 bit Windows, But mod_fcgit is 32 bit. Where i can get a 64 bit module?

Collectives™ on Stack Overflow

Oracle DB connection with PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related