Click here to Skip to main content
Click here to Skip to main content

PHP with Oracle 11g on Windows 7 64-bit

, 8 Jan 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
It’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications.

Introduction

Now a day, many PHP applications have been developed keeping Oracle as database instead of MySQL and it’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications that the connection of Oracle database has been refused to connect. Here I have used Instant Client to connect Oracle database with my PHP application.

Instead of using separate installation of PHP and Apache, I have used here WAMP server. Just follow the step-by-step to connect Oracle database with PHP applications on the platform of Windows 7 (64-bit).

Step-by-Step

STEP 1. Install WAMP server and Oracle 11g at first.

STEP 2. For Windows 7 (64-bit), extract instantclient-basic-windows.x64-11.2.0.3.0.zip, downloaded from http://www.oracle.com/technetwork/topics/winx64soft-089540.html to C:\Windows\SysWOW64\instantclient_11_2 and set it on PATH variable for Environment variable.

STEP 3. Reboot the system now.

STEP 4. Allow PHP extension from php.ini as

extension=php_oci8_11g.dll (just remove the ";" from the start of the line)

STEP 5. Restart WAMP server.

STEP 6. Open the file to see the database name as D:\app\Farhan\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

 LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.168.1.2)
    )
  )

Here, the service name is found as "orcl.168.1.2" .

STEP 7. Make the connection in PHP script as oci_connect(your_username, your_password, "localhost/orcl.168.1.2");

Conclusion

Now try it on your environment, wish you will be succeeded easily to connect with Oracle database from PHP applications on the platform of Windows 7 (64-bit).

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Zamshed Farhan
Web Developer
Bangladesh Bangladesh
No Biography provided

Comments and Discussions

 
Questionthanks PinmemberMember 963455215-Jan-13 1:51 
AnswerRe: thanks PinmemberS.M. Zamshed Farhan15-Jan-13 2:55 
Questioncore java PinmemberMember 963455212-Jan-13 23:40 
AnswerRe: core java PinmemberS.M. Zamshed Farhan14-Jan-13 23:39 
Questionre patient form PinmemberMember 963455211-Jan-13 4:33 
AnswerRe: re patient form PinmemberS.M. Zamshed Farhan11-Jan-13 4:40 
Questionpatient form PinmemberMember 963455210-Jan-13 19:36 
AnswerRe: patient form PinmemberS.M. Zamshed Farhan11-Jan-13 3:52 
AnswerRe: patient form PinmemberS.M. Zamshed Farhan11-Jan-13 3:54 
Questionphp PinmemberMember 96345529-Jan-13 20:09 
AnswerRe: php PinmemberS.M. Zamshed Farhan10-Jan-13 2:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.141015.1 | Last Updated 8 Jan 2013
Article Copyright 2013 by Zamshed Farhan
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid