Try   HackMD

Working with Oracle Database using PHP

Installation

Ubuntu 22.04

Installing php

sudo apt update
sudo apt install lsb-release ca-certificates apt-transport-https software-properties-common -y

sudo add-apt-repository ppa:ondrej/php # if error -> ignore
sudo apt install php8.1 -y
# verify
php -v

Installing oci8 (Oracle Instance Client for PHP)

Download Oracle Instant Client and SDK from Oracle: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download files:

  • Basic Package (ZIP): instantclient-basic-linux.x64-21.XXX.zip
  • SDK Package (ZIP): instantclient-sdk-linux.x64-21.XXX.zip
sudo mkdir -p /usr/lib/oracle/21.1/client64
sudo cp ~/Downloads/instantclient-*.zip /usr/lib/oracle/21.1/client64/

cd /usr/lib/oracle/21.1/client64

sudo unzip instantclient-basic-linux.x64-21.*.zip
sudo unzip instantclient-sdk-linux.x64-21.1.*.zip

sudo mv instantclient_21_1 lib

# create symbolic link to the new Instant Client files
cd ./lib/
sudo ln -s libclntsh.so.21.1 libclntsh.so # It may already exist, continue
sudo ln -s libocci.so.21.1 libocci.so # It may already exist, continue

# or white manually
sudo echo /usr/lib/oracle/21.1/client64/lib > /etc/ld.so.conf.d/oracle.conf

sudo ldconfig

# install php-dev php-pear build-essential and libaio1
sudo apt-get install php-dev php-pear build-essential libaio1

sudo pecl channel-update pecl.php.net
sudo pecl install oci8
# during install it will require the path to Instant Client, write this:
# instantclient,/usr/lib/oracle/21.1/client64/lib

# load OCI8 into PHP
# or white manually
sudo echo "extension=oci8.so" >> /etc/php/8.1/cli/php.ini

# check if OCI is loaded in PHP
php -i | grep oci

Oracle Linux 8

Installing php

sudo dnf install epel-release
sudo dnf install dnf-utils http://rpms.remirepo.net/enterprise/remi-release-8.rpm

sudo dnf update

sudo dnf module list reset php
sudo dnf module enable php:remi-8.1
sudo dnf install php
# verify
php -v

Installing oci8 (Oracle Instance Client for PHP)

sudo dnf install oraclelinux-developer-release-el8 oracle-instantclient-release-el8
sudo dnf module enable php:remi-8.1 php-oci8
sudo yum install php-oci8<instant client release>
# check if OCI is loaded in PHP
php -i | grep oci

CentOS 7

Installing php

sudo yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
sudo yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
sudo yum install yum-utils

sudo yum-config-manager --enable remi-php56   # install PHP 5.6
sudo yum-config-manager --enable remi-php55   # install PHP 5.5
sudo yum-config-manager --enable remi-php72   # install PHP 7.2

sudo yum install php php-mcrypt php-cli php-gd php-curl php-mysql php-ldap php-zip php-fileinfo
# verify
php -v

Installing oci8 (Oracle Instance Client for PHP)

sudo yum install php php-pecl-mcrypt php-cli php-gd php-curl php-mysqlnd php-ldap php-zip php-fileinfo php-xml php-intl php-mbstring php-opcache php-process systemtap-sdt-devel php-pear php-json php-devel php-common php-bcmath php-pdo

sudo yum install php-oci8
# check if OCI is loaded in PHP
php -i | grep oci

Testing

# create test directory
mkdir oracle-db-test
cd oracle-db-test
touch ./index.php

# load OCI8 into PHP
# or white manually
sudo echo "extension=oci8.so" >> /etc/php.ini

sudo yum install oracle-instantclient-basic-21.3.0.0.0-1.x86_64.rpm
sudo yum install oracle-instantclient-devel-21.3.0.0.0-1.x86_64.rpm

sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

Write the following code in the index.php file



























<?php
// fill in the contents of the following variables correctly
$usr = 'username';
$pswd = 'password';
$connStr = '//hostname:port/service_name';
$conn = oci_connect($usr, $pswd, $connStr, 'AL32UTF8');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

// fill in the correct SQL query
$queryStr = 'SELECT * FROM employees';
$stid = oci_parse($conn, $queryStr);
oci_execute($stid);

echo "<table border='1'>\n";
while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) {
    echo "<tr>\n";
    foreach ($row as $item) {
        echo "    <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;") . "</td>\n";
    }
    echo "</tr>\n";
}
echo "</table>\n";
?>

The execution is done in the following way:

cd oracle-db-test
php -S 127.0.0.1:8000 # or using any other available IP/port of the machine
# visit http://127.0.0.1:8000

Resources

Last changed by 
 
Mike Raptakis
0
216

Read more

Improving SatNOGS TX capabilities

The final report for the GSoC 2021 program Project Summary The purpose of this project was to improve the capabilities of the SatNOGS transmitter (TX). More specifically, SatNOGS is an Open Source global network of satellite ground-stations and is a project of the Libre Space Foundation. SatNOGS consists of subgroups and projects (see librespacefoundation/satnogs on GitLab) so that its management is more efficient and the needs of users are more easily met. My contribution, under the GSoC 2021 program, was made to the out-of-tree module of GNU Radio gr-satnogs which is the implementation of SatNOGS within GNU Radio. During the 10 weeks of the GSoC 2021 program, I was able to complete the initial plan for the project. The following is what was implemented: Implementation of the NanoCom AX.100 Mode 5 encoder Implementation of the NanoCom AX.100 Mode 6 encoder Implementation of the Reed-Muller RM (1, 6) encoder and decoder

Aug 23, 2021
A journey into the world of Open Source Projects

My experience so far in GSoC 2021... Introduction To begin with, it is worth mentioning that this article is my personal experience of participating in Google Summer of Code (GSoC) and as a member of an Open Source project. As a computer science student, I have little experience with real-world projects. My work so far was part of an exercise and the result was judged only by the final grade. So, wanting to go beyond the student stage and become a real developer, I made the instant decision to participate in the GSoC event. This decision is one of the most beautiful decisions I have made so far... And the journey is not over yet! Let me mention, then, the basics for both the GSoC event and the organization in which I participate, the Libre Space Fundation. About Google Summer of Code (GSoC) The Google Summer of Code (GSoC) event aims to introduce participating students to the world of Open Source software development. It is a program lasting 10 weeks, which for 2021, is active for students from March 29 to August 31. During this period, the student is a member of an open source organization and his purpose is to participate in one of his projects. The student, in addition to writing code, becomes an active member of the organization and gains the best possible experience through this event. About Libre Space Foundation

Aug 9, 2021
Read more from Mike Raptakis
Published on HackMD