Installing Oracle Client and PHP extensions under Windows

First to complain, according to this play to spend my big half a day, all the way to the pit!

My computer is Win7 64-bit.

The first step

Open the php.ini and remove the semicolon from the front of the Extension=php_oci8_12c.dll Extension=php_pdo_oci.dll.

; Extension=php_ldap. dllextension=php_mbstring. dllextension=php_exif.dll as        It depends on Itextension=php_mysqli.  Dllextension=php_oci8_12c.dll use with    Oracle Database 12c Instant client;extension=php_ Openssl. dll;extension=php_pdo_firebird. dllextension=php_pdo_mysql. dllextension=php_pdo_oci.dll

Step Two

Go to http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html to download the client (note here to put 32w and 64w down)

Then extract to any of your directory, two are extracted, the file name to change the names of the same

Step Three

Configure the environment variables, this is 32w, Windows only recognize 32 bits (that let us under 64w what to do below will say, I put my post, you according to your own actual directory configuration)

A. Nls_lang = simplified Chinese_china. Zhs16gbk

B. oracle_home = D:\instantclient_12_2

C. tns_admin = D:\instantclient_12_2

D. PATH = D:\instantclient_12_2

Configure environment Variables Remember to restart your computer

Phpinfo

Fourth Step

I'm a navicat connected Oracle.

Connection information is filled in normally, sid what do not make mistakes on the line, and then connect error!

Resolve the error:

Navicat, tools, Options->oci

This must be noted to point to your 64w folder inside the Oci.dll (I was in this pit for a long time)

Installing Oracle Client and PHP extensions under Windows