Detailed explanation of how php uses PDO to access the oracle database

POD extension was added in PHP5. This extension provides PHP built-in class PDO to access the database. Different databases use the same method name to solve the problem of inconsistent database connections. The following article mainly introduces the steps for PHP to use PDO to access the Oracle database. Friends in need can refer to it.

Preface

PDO has learned from the beginning about successes and failures in scaling existing databases. Because PDO's code is brand new, we have the opportunity to redesign performance from the ground up to take advantage of PHP 5's latest features.

PDO is designed to provide common database functionality as a foundation while providing easy access to the unique features of an RDBMS.

Although PHP and Mysql are a standard pairing in LAMP, the company's project uses Mysql and Oracle as the runtime library and order library respectively, so PHP must be connected to the Oracle database. This article will introduce how to connect to the Oracle database through PDO. I won’t go into more details below. Let’s take a look at the detailed introduction.

Development environment

Also first explain the environment I use:

• RedHat(CentOS)6.7

• PHP5.6

• ##Oracle11g

The construction of php5.6 can be referred here;

The installation of Oracle in the linux environment can be referred here

Of course, you can also not install the entire oracle, but Only install the instant client to achieve this; if it is the Oracle connection step of the instant client, please refer to the acknowledgment section at the end of this blog post.

Before starting the following steps, please make sure that the above three environments are correctly configured and available.

Install PDO_OCI

If you installed the php5.6.31 version, it seems that the pdo_oci module already comes with it; But to be on the safe side, let’s reinstall it.

Download and unzip

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

Modify the configuration file

Update the config.m4 file in the directory to adapt it to Oracle11g

# 在第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

Execute in the current directory

$ phpize

phpize is similar to the gcc command, mainly used to generate php plug-in module. phpize depends on the php-deval module. If the command cannot be executed, please use yum to install php-deval yourself;

You can check whether it has been installed by running the following command:

$ rpm -qa | grep php

Check whether there is php56w-deval-5.6.xxx. If not, please yum install php56w-deval to install it.

Installation

After the phpize command is executed, many files will be generated in the directory, including configure and other common files we have Under Linux, install the standard file of the application through the source code, and execute the following commands in sequence:

$ ./configure
$ make && make install

Generally, you will encounter a problem here. When making, you will be prompted in pdo_oci. In the c file:

pdo_oci.c:34: error: expected ‘=', ‘,', ‘;', ‘asm' or ‘attribute' before ‘pdo_oci_functions'

The solution is to modify line 34 of the pdo_oci.c file, change function_entry to zend_function_entry, save and then make again.

Create ini file

After success, you will be prompted that it is already in the /usr/lib64/php/modules directory The pdo_oci.so module is generated. All we have to do is tell PHP that we want to reference this module.

Create a new ini file in the /etc/php.d directory: pdo_oci.ini, content:

##

extension=pdo_oci.so

Here, pdo_oci module The installation is complete, we can view it through php -m | grep oci.

Install OCI8
##The next step is to install the oci8 module.

Download and decompress

Execute the following commands in the command line in sequence:

$ 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

The steps are similar to pdo_oci above:

$ phpize
$ ./configure --with-oci8=shared
$ make && make install

Create ini file

Similarly, we create oci8.ini in the /etc/php.d directory, Content:

extension=oci8.so

Restart Apache

Don’t forget to restart the apache server to reload PHP module:

$ service httpd restart

We can create a test.php file in the website directory. The content of the file is:

<?php
phpinfo();

Then we go to the page to view the printed phpinfo information and view the relevant information of the pdo, pdo_oci and oci8 modules.

Summary

Reference & Acknowledgments

php5.3 client connecting to oracle Install terminal and pdo_oci module

Installing PDO_OCI and OCI8 PHP extensions on CentOS 6.4 64bit

The above is the detailed content of Detailed explanation of how php uses PDO to access the oracle database. For more information, please follow other related articles on the PHP Chinese website!