个人工具

UbuntuHelp:PHPOracle

来自Ubuntu中文

Oneleaf讨论 | 贡献2007年5月24日 (四) 15:23的版本 (新页面: {{From|https://help.ubuntu.com/community/PHPOracle}} {{Languages|UbuntuHelp:PHPOracle}} To be able to access Oracle databases from PHP, you will need to have the Oracle OCI library instal...)

(差异) ←上一版本 | 最后版本 (差异) | 下一版本→ (差异)
跳转至: 导航, 搜索


To be able to access Oracle databases from PHP, you will need to have the Oracle OCI library installed in your machine.

There are two ways to get this library:

  • Install the Oracle Database [Oracle10g] [Oracle9i]
  • Install Oracle Instant Client

If your Oracle database is in another machine, the Oracle Instant Client is a smaller install.

PHP using Oracle Database Server

TODO

PHP using Oracle Instant Client

Tested Environment:

Ubuntu Server 6.06 LTS Oracle Instant Client 10.2.0.2

Prerequisites:

sudo apt-get install build-essential
sudo apt-get install php5-dev php-pear

Also download the Oracle Instant Client http://www.oracle.com/technology/tech/oci/instantclient/index.html

You will need the Basic (34MB) and SDK (600K). The Basic Lite version does not work.

cd /usr/local/lib
sudo unzip <location-of-instant-client-basic>
sudo unzip <location-of-instant-client-sdk>
cd instantclient_10_2
sudo ln -s libclntsh.so.10.1 libclntsh.so

The symbolic link is needed by during the compilation step later.

sudo pecl install oci8

You will be prompted for the location of the library:

instantclient,/usr/local/lib/oracle_10_2

If successful, you may now add the following line at the bottom of php.ini

extension = oci8.so

The php.ini is found in 2 places: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini

sudo /etc/init.d/apache2 reload

Check <?php echo phpinfo() ?> to verify if the OCI8 module is available.

Further Reading