Backend DevelopmentPHP TutorialHow to connect to oracle database in php7.2? Installation of OCI8 extensionHow 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.
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 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!
PHP's Purpose: Building Dynamic WebsitesApr 15, 2025 am 12:18 AMPHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.
PHP: Handling Databases and Server-Side LogicApr 15, 2025 am 12:15 AMPHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
How do you prevent SQL Injection in PHP? (Prepared statements, PDO)Apr 15, 2025 am 12:15 AMUsing preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.
PHP and Python: Code Examples and ComparisonApr 15, 2025 am 12:07 AMPHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.
PHP in Action: Real-World Examples and ApplicationsApr 14, 2025 am 12:19 AMPHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.
PHP: Creating Interactive Web Content with EaseApr 14, 2025 am 12:15 AMPHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.
PHP and Python: Comparing Two Popular Programming LanguagesApr 14, 2025 am 12:13 AMPHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
The Enduring Relevance of PHP: Is It Still Alive?Apr 14, 2025 am 12:12 AMPHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
SublimeText3 Chinese version
Chinese version, very easy to use
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Dreamweaver Mac version
Visual web development tools
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
