Home  >  Article  >  Backend Development  >  How to connect to oracle database in php7.2? Installation of OCI8 extension

How to connect to oracle database in php7.2? Installation of OCI8 extension

青灯夜游
青灯夜游forward
2022-07-22 14:59:583422browse

How to connect to oracle database in php7.2? The following article will introduce to you how to install OCI8 extension to support Oracle database in php7.2. I hope it will be helpful to you!

How to connect to oracle database in php7.2? Installation of OCI8 extension

When working on a project, the remote Oracle database provides us with an intermediate table. Some data in my business needs to go to this intermediate table in the Oracle database. table to query.

PHP connects to oracle database. Requires the OCI8 extension. I am ashamed to say that after so many years of working, I have never used an Oracle database seriously.

The syntax of mysql database is different from that of oracle database. Don’t just use mysql syntax to operate oracle database like me...it’s a bit embarrassing...

Today we Roughly record the installation process of OCI8 extension.

1: Download file

1: Oracle official website download address:

http://www.oracle.com /technetwork/topics/linuxx86-64soft-092277.html

Download file (check the file name):

oracle-instantclient19.8-basic-19.8.0.0.0-1.x86_64.rpm

oracle-instantclient19.8-devel-19.8.0.0.0-1.x86_64.rpm复制代码

2 : PHP official website download address :

https://www.php.net/manual/zh/oci8.installation.php

PHP-OCI8 plug-in

Download command:

wget http://pecl.php.net/get/oci8-2.2.0.tgz

It is recommended to put the above three files into the /opt directory. Of course, you are free to put them where exactly. Just find it.

Two: Installation

1 : Install oracle plug-in

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

may be Error:

ImportError: libaio.so.1: cannot open shared object file: No such file or directory”

The reason for the error has been given above. The libiao plug-in is missing, solution:

yum install libaio

2 : Install the OCI8 plug-in

(1): Unzip the tar package:

tar -zxf oci8-2.2.0.tgz

(2): Enter the decompression directory

cd oci8-2.2.0

(3): Run the command:

phpize

When running, the following error may occur: Can't find PHP headers in /usr/include/php The php-devel package is required for use

Solution

 yum install php72w-devel #注意一下,这条命令取决你安装的PHP版本,我这个命令并不适用所有人

(4): Use $ORACLE_HOME or Instant Client to configure the package

./configure --with-oci8=shared,instantclient,/usr/lib/oracle/<version>/client/lib</version>

or

./configure -with-oci8=shared,$ORACLE_HOME

(5): Execute compilation and installation:

make install

An error may be reported here:

make: ** * No rule to make target build', needed by default'. Stop.

Solution:

1: Install the following configuration:

yum -y install make zlib-devel gcc-c++ libtool openssl openssl-devel

2: Re configure

./configure

3: Compile

make && make install

(6): Configure php.ini

We add

extension=oci8.so

to restart PHP

systemctl restart php-fpm
# in the PHP configuration file php.ini ##Restart the web server (nginx, apache, etc.).

systemctl restart nginx
View

PHPinfo();As shown below:

How to connect to oracle database in php7.2? Installation of OCI8 extension

Then, you can configure multiple database links in your PHP framework.

Recommended learning: "

PHP Video Tutorial"

The above is the detailed content of How to connect to oracle database in php7.2? Installation of OCI8 extension. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:juejin.cn. If there is any infringement, please contact admin@php.cn delete