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
Install PDO_OCI
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
# 在第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
$ phpize
$ rpm -qa | grep php
Installation
$ ./configure $ make && make install
pdo_oci.c:34: error: expected ‘=', ‘,', ‘;', ‘asm' or ‘attribute' before ‘pdo_oci_functions'
Create ini file
##
extension=pdo_oci.so
Install OCI8
##The next step is to install the oci8 module.
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
The steps are similar to pdo_oci above:
$ phpize $ ./configure --with-oci8=shared $ make && make install
Similarly, we create oci8.ini in the /etc/php.d directory, Content:
extension=oci8.so
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:
Copy after login
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.
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!