: This article describes how to enable oci8 for php connection to oracle (from the oracle official website). If you are interested in PHP tutorials, refer to it. Enabling the php OCI8 EXTENSION ON WINDOWS
The Instant Client binaries complement PHP's pre-built binaries for Windows.
Install Apache by downloadinghttpd-2.2.22-win32-x86-no_ssl.msi
From httpd.apache.org/download.cgi
Double click the MSI file to start the installation wizard.
Install "for All Users, on Port 80". Do a typical install into the default destination folder:C:\Program Files\Apache Software Foundation\Apache2.2
.
Download the FastCGI componentmod_fcgid-2.3.6-win32-x86.zip
From httpd.apache.org/download.cgi?mod_fcgid
Unzip it to the installed Apache 2.2 directory.C:\Program Files\Apache Software Foundation\Apache2.2\modules
Directory shocould now havemod_fcgid.so
Andmod_fcgid.pdb
Files.
EditC:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf
And add the line:
LoadModule fcgid_module modules/mod_fcgid.so
Inhttpd.conf
, Locate
Sectionhtdocs
And addExecCGI
ToOptions
:
...Options Indexes FollowSymLinks ExecCGI...
Install PHP by downloading the PHP 5.4.0 "VC9 x86 Non Thread Safe" ZIP packagePhp-5.4.0-nts-Win32-VC9-x86.zipFromwindows.php.net/download.
In Windows Explorer unzip the PHP package to a directory calledC:\php-5.4.0
InC:\php-5.4.0
Copyphp.ini-development
Tophp.ini
Editphp.ini
To make the following changes:
Add a timezone line like:
date.timezone = America/Los_Angeles
Use your local timezone name.
Add the line:
extension_dir = C:\php-5.4.0\ext
This is the directory containing the PHP extensions.
Remove the semicolon from the beginning of the line:
extension=php_oci8_11g.dll
EditC:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf
And add the following lines. Make sure you use forward slashes'/
And not back slashes'\
':
FcgidInitialEnv PHPRC "c:/php-5.4.0"AddHandler fcgid-script .phpFcgidWrapper "c:/php-5.4.0/php-cgi.exe" .php
Download the "Instant Client Package-Basic" for Windows from the OTN Instant Client page. Because PHP is 32 bit, use the 32 bit version of Instant Client.
Unzip the Instant Client filesC:\instantclient_11_2
Edit the WindowsPATH
Environment setting and addC:\instantclient_11_2
. For example, on Windows XP, follow Start-> Control Panel-> System-> Advanced-> Environment Variables and editPATH
In the System variables list.
Commonly you need to reboot Windows so the new environment is correctly set.
Set desired Oracle globalization language environment variables suchNLS_LANG
. If nothing is set, a default local environment will be assumed. See the Globalization chapter in The Underground PHP and Oracle Manual for more details.
Unset Oracle variables suchORACLE_HOME
AndORACLE_SID
, Which are unnecessary with Instant Client.
If you have other Oracle software on the computer then instead of modifying the Windows environment, write a script that sets these values and starts Apache. Otherwise library symbol clashes are likely because of version differences.
Restart Apache using the system tray Apache Monitor or the Start menu option.
The above describes how to enable oci8 for php connection to oracle (from the oracle official website), including content, and hope to help friends who are interested in PHP tutorials.