个人工具

“UbuntuHelp:PHPOracle”的版本间的差异

来自Ubuntu中文

跳转至: 导航, 搜索
(新页面: {{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...)
 
第68行: 第68行:
  
 
=== Further Reading ===
 
=== Further Reading ===
 +
 +
* [http://www.orafaq.com/wiki/PHP Oracle PHP Wiki]
  
 
[[category:UbuntuHelp]]
 
[[category:UbuntuHelp]]

2007年11月21日 (三) 18:20的版本


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