Detailed explanation of how php uses PDO to access the oracle database-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

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

黄舟

Sep 30, 2017 am 09:12 AM

oracle php 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

Copy after login

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)
 ;;

Copy after login

Compile

Execute in the current directory

$ phpize

Copy after login

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

Copy after login

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

Copy after login

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 ‘=&#39;, ‘,&#39;, ‘;&#39;, ‘asm&#39; or ‘attribute&#39; before ‘pdo_oci_functions&#39;

Copy after login

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

Copy after login

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

Copy after login

Compile and install

The steps are similar to pdo_oci above:

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

Copy after login

Create ini file

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

extension=oci8.so

Copy after login

Restart Apache

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

$ service httpd restart

Copy after login

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

<?php
phpinfo();

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.

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!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

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

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Nordhold: Fusion System, Explained

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1665

CakePHP Tutorial

1423

Laravel Tutorial

1321

PHP Tutorial

1269

C# Tutorial

1249

Related knowledge

PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP and Python: A Deep Dive into Their History Apr 18, 2025 am 12:25 AM

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

The Continued Use of PHP: Reasons for Its Endurance Apr 19, 2025 am 12:23 AM

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

MySQL: Structured Data and Relational Databases Apr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities Explained Apr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

MongoDB vs. Oracle: Choosing the Right Database for Your Needs Apr 22, 2025 am 12:10 AM

MongoDB is suitable for unstructured data and high scalability requirements, while Oracle is suitable for scenarios that require strict data consistency. 1.MongoDB flexibly stores data in different structures, suitable for social media and the Internet of Things. 2. Oracle structured data model ensures data integrity and is suitable for financial transactions. 3.MongoDB scales horizontally through shards, and Oracle scales vertically through RAC. 4.MongoDB has low maintenance costs, while Oracle has high maintenance costs but is fully supported.

See all articles