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? 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!
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.
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复制代码
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.
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
(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:
yum -y install make zlib-devel gcc-c++ libtool openssl openssl-devel
./configure
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 nginxView
PHPinfo();As shown below:
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!