个人工具

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

来自Ubuntu中文

跳转至: 导航, 搜索
第1行: 第1行:
 
{{From|https://help.ubuntu.com/community/PHPOracle}}
 
{{From|https://help.ubuntu.com/community/PHPOracle}}
 
{{Languages|UbuntuHelp:PHPOracle}}
 
{{Languages|UbuntuHelp:PHPOracle}}
To be able to access Oracle databases from PHP, you will need to have the Oracle OCI library installed in your machine.
+
To be able to access Oracle databases from PHP, you will need to have PHP compiled / linked with the Oracle OCI (oci8) library .
There are two ways to get this library:
+
You could use the pre-built PHP 5 from Zend http://www.oracle.com/technology/tech/php/zendcore/index.html
 +
or there are two other ways to get PHP working with OCI8:
 
<ol><li>Install the Oracle Database [Oracle10g] [Oracle9i]
 
<ol><li>Install the Oracle Database [Oracle10g] [Oracle9i]
 
</li><li>Install Oracle Instant Client</li></ol>
 
</li><li>Install Oracle Instant Client</li></ol>

2008年4月23日 (三) 11:53的版本


To be able to access Oracle databases from PHP, you will need to have PHP compiled / linked with the Oracle OCI (oci8) library . You could use the pre-built PHP 5 from Zend http://www.oracle.com/technology/tech/php/zendcore/index.html or there are two other ways to get PHP working with OCI8:

  1. Install the Oracle Database [Oracle10g] [Oracle9i]
  2. 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