Connect PHP 7 to Oracle Database using packages from Oracle Linux Yum Server

We recently added PHP 7.4 to our repos on Oracle Linux yum server. These repos include also include the PHP OCI8 extenstion to connect your PHP applications to Oracle database.
In this post I describe the steps to install PHP 7.4, PHP OCI8 and Oracle Instant Client on Oracle Linux to connect PHP to Oracle Database. For this blog post, I used a free Autonomous Database included in Oracle Cloud Free Tier.

Install Oracle Instant Client

Oracle Instant Client RPMs are available on Oracle Linux yum server also. To access them, install the oracle-release-el7 package first to setup the appropriate repositories:

$ sudo yum -y install oracle-release-el7
$ sudo yum -y install oracle-instantclient19.5-basic
If you want to be able to use SQL*Plus (this can come in handy for some sanity checks), install the SQL*Plus RPM also:
$ sudo yum -y install oracle-instantclient19.5-sqlplus

Create a Schema and Install the HR Sample Objects (Optional)

You can use any schema you already have in your database. I’m going to use the HR schema from the Oracle Database Sample Schemas on github.com If you already have a schema with database objects to work with, you can skip this step.
$ yum -y install git
$ git clone https://github.com/oracle/db-sample-schemas.git
$ cd db-sample-schemas/human_resources
As SYSTEM (or ADMIN, if you are using Autonomous Database), create a user PHPTEST
SQL> grant connect, resource, create view to phptest identified by <YOUR DATABASE PASSWORD>;
SQL> alter user PHPTEST quota 5m on USERS;
If you are using Autonomous Database like I am, change the tablespace above to DATA:
SQL> alter user phptest quota 5m on DATA;
As the PHPTEST user, run the scripts hr_cre.sql and hr_popul.sql to create and populate the HR database objects
SQL> connect phptest/<YOUR DATABASE PASSWORD>@<YOUR CONNECT STRING>
SQL> @hr_cre.sql
SQL> @hr_popul.sql

Install PHP and PHP OCI8

To install PHP 7.4, make sure you have the latest oracle-php-release-el7 package installed first.
$ sudo yum install -y oracle-php-release-el7
Next, install PHP and the PHP OCI8 extenstion corresponding to the Oracle Instant Client installed earlier:
$ sudo yum -y install php php-oci8-19c
Running the following php code snippet should verify that we can connect PHP to the database and bring back data. Make sure you replace the schema and connect string as appropriate.
<!--?php
    error_reporting(E_ALL);
    ini_set('display_errors', '1');
    $conn = oci_connect('phptest', '<YOUR DATABASE PASSWORD>', '<YOUR CONNECT STRING>');
    $stid = oci_parse($conn, 'SELECT last_name FROM employees');
    oci_execute($stid);
    echo "\n";
    while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
      foreach ($row as $item) {
        echo $item ."\n";
       }
    }
?-->
Create a file emp.php based on the code above.

Run it!

$ php emp.php
This should produce the following:
King
Kochhar
De Haan
Hunold
Ernst
Austin
Pataballa
Lorentz
Greenberg
Faviet
Chen
Sciarra
...
sudo setsebool -P httpd_can_network_connect on
sudo systemctl stop httpd
sudo systemctl start httpd

Comments

Post a Comment

Popular posts from this blog

Easy Text-to-Speech with Python

Image
Text-to-speech (TTS) technology reads aloud digital text. It can take words on computers, smartphones, tablets and convert them into audio. Also, all kinds of text files can be read aloud, including Word, pages document, online web pages can be read aloud. TTS can help kids who struggle with reading. Many tools and apps are available to convert text into speech. Python comes with a lot of handy and easily accessible libraries and we’re going to look at how we can deliver text-to-speech with Python in this article. Source:  https://www.youtube.com/watch?v=eiP-12qHM-c Different API’s are available in Python in order to convert text to speech. One of Such API’s is the Google Text to Speech commonly known as the gTTS API. It is very easy to use the library which converts the text entered, into an audio file which can be saved as a mp3 file. It supports several languages and the speech can be delivered in any one of the two available audio speeds, fast or slow. More detai
Read more

Flutter for Single-Page Scrollable Websites with Navigator 2.0

Image
  Single page scrollable websites are everywhere. In this website design pattern, all the content is presented in one long-scrolling layout that contains multiple sections. Visitors can scroll or jump to a section by clicking buttons of a sticky menu. This pattern is a good fit for small content such as brochure websites, software library documentation, portfolios, and landing pages that are used to convert users [ 1 ]. Designers also love this pattern because it is simple, clean, and enables cool scroll animations. Jetbrains Mono single-page scrollable website Hive docs multi-page scrollable website In this series of articles, we will explore how to build a  single-page scrollable website  using Flutter. We will benefit from the Navigator 2.0 API to provide a good navigation experience to the users. You can find the source code of this series’ sample apps on my  Github page . The implementation details of the sample apps will be explained in the following articles: Part 2: Scroll to P
Read more

Better File Storage in Oracle Cloud

Image
Use Oracle Application Express with Oracle Cloud Infrastructure REST APIs to upload, download, and manage big files in Oracle Cloud. By Adrian Png November 27, 2019 Oracle Cloud Infrastructure  provides a comprehensive suite of REST APIs for accessing and managing cloud resources. For example, administrators can use REST APIs to create and manage autonomous databases and initiate backups. Oracle Application Express (Oracle APEX)  makes working with REST easy. The  APEX_WEB_SERVICE  package, available since Oracle APEX 4.0, provides developers with a function for consuming REST APIs. Oracle APEX 5.0 introduced the  APEX_JSON  package, allowing easy parsing of JSON responses. Oracle APEX 18.1 introduced the Web Source Module (WSM), which enables developers to access REST services and use the data in APEX components such as reports, interactive reports, and interactive grids. These features, when used together with Oracle Cloud Infrastructure REST APIs, enable APEX developers
Read more