How to connect PHP5.3 to Oracle client and install PDO_OCI module, php5.3pdo_oci_PHP tutorial

How to install PHP5.3 to connect to Oracle client and PDO_OCI module, php5.3pdo_oci

This article describes the installation method of PHP5.3 to connect to Oracle client and PDO_OCI module. Share it with everyone for your reference, the details are as follows:

Although PHP is not the best partner to connect to the Oracle database, there is indeed such a need for in-group development. If you don’t refer to the appropriate documentation, this process is quite torturous. The following is a record. The prototype is a foreign blog Installing PDO_OCI and OCI8 PHP extensions on CentOS 6.4 64bit.

Assume that you have installed the PHP environment, the PHP version is 5.3, the Oracle server to be connected is 11g R2, and the operating system version is CentOS 6.4 x86_64. If php is not installed, you can install it with the following command:

# yum install php php-pdo
# yum install php-devel php-pear php-fpm php-gd php-ldap \
php-mbstring php-xml php-xmlrpc php- zlib zlib-devel bc libaio glibc

If the web server uses apache.

1. Install InstantClient

instantclient is a simple client for Oracle to connect to the database. You can connect to the Oracle database without installing a 500Moracle client. There are windows and Linux versions. Select the required version to download from here, only the Basic and Devel rpm packages are required.

Install

# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

Soft link

# ln -s /usr/include/oracle/11.2/client64 /usr/include/oracle/11.2/client
# ln -s /usr/lib/oracle/11.2/client64 /usr/lib/oracle/11.2/client

64-bit systems need to create 32-bit soft links. This may be a legacy bug, otherwise there will be problems with subsequent compilation.

The next step is to enable the system to find the Oracle client library file and modify LD_LIBRARY_PATH:

# vi /etc/profile.d/oracle.sh
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Execute source /etc/profile.d/oracle.sh to make the environment variables take effect.

2. Install PDO_OCI

When connected to the Internet, it is very simple to install php extensions online through pecl. Please refer to How to install oracle instantclient and pdo_oci on ubuntu machine.

Download the PDO_OCI-1.0.tgz source file from https://pecl.php.net/package/PDO_OCI.

# wget https://pecl.php.net/get/PDO_OCI-1.0.tgz
# tar -xvf PDO_OCI-1.0.tgz
# cd PDO_OCI-1.0

Since PDO_OCI has not been updated for a long time, you need to edit the config.m4 file in the ODI_OCI-1.0 folder to make it support 11g:

# 在第10行左右找到与下面类似的代码，添加这两行：
elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.11.2; then
 PDO_OCI_VERSION=11.2
# 在第101行左右添加这几行：
11.2)
 PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)
 ;;

Compile and install the pdo_oci extension: (This module can be found in /usr/lib64/php/modules/pdo_oci.so after the installation is complete)

$ phpize
$ ./configure --with-pdo-oci=instantclient,/usr,11.2
$ make
$ sudo make install

To enable this extension, create a new pdo_oci.ini file under /etc/php.d/, content:

extension=pdo_oci.so

Verify successful installation:

# php -i|grep oci

If you see content similar to the following, the installation is successful:

/etc/php.d/pdo_oci.ini,

PDO drivers => oci, sqlite

or

# php -m

3. Install OCI8

Download the oci8-2.0.8.tgz source file from https://pecl.php.net/package/oci8.

# wget https://pecl.php.net/get/oci8-2.0.8.tgz
# tar -xvf oci8-2.0.8.tgz
# cd oci8-2.0.8

Compile and install oci8 extension:

# phpize
# ./configure --with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client64/lib
# make
# make install

To enable this extension, create a new oci8.ini file under /etc/php.d/, content:

extension=oci8.so

Verify successful installation:

# php -i|grep oci8
/etc/php.d/oci8.ini,
oci8
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
OLDPWD => /usr/local/src/oci8-2.0.8
_SERVER["OLDPWD"] => /usr/local/src/oci8-2.0.8

Finally, don’t forget to restart the reverse web server such as apache. You can use phpinfo() to ensure whether the extension is successfully installed.

4. Test connection

Create testoci.php in the php directory of your web server such as apache:

<&#63;php
$conn = oci_connect('username', 'password', '172.29.88.178/DBTEST');
$stid = oci_parse($conn, 'select table_name from user_tables');
oci_execute($stid);
echo "<table>\n";
while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
  echo "<tr>\n";
  foreach ($row as $item) {
    echo " <td>".($item !== null &#63; htmlentities($item, ENT_QUOTES) : " ")."</td>\n";
  }
  echo "</tr>\n";
}
echo "</table>\n";
&#63;>

You should get the results by visiting this page.

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP database operation skills based on pdo", "PHP MongoDB database operation skills collection", "php object-oriented programming introductory tutorial", "php Summary of String Usage", "Introduction Tutorial on PHP MySQL Database Operation" and "Summary of PHP Common Database Operation Skills"

I hope this article will be helpful to everyone in PHP programming.

http://www.bkjia.com/PHPjc/1127916.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1127916.htmlTechArticleHow to install PHP5.3 to connect to Oracle client and PDO_OCI module, php5.3pdo_oci This article describes PHP5.3 with examples How to connect Oracle client and PDO_OCI module installation method. Share it with everyone for your reference...