Categories
System/Linux/Unix*

Protected: [note] Install php7 oci8 on Ubuntu steps

There is no excerpt because this is a protected post.

Categories
DATABASE Programming/php Software System/Linux/Unix*

[★★★★] debian / ubuntu LAMP : 裝 oracle instant client / sqlplus / oci8 / apache2 config / steps by steps

2016.0202 -rw-r–r–@ 1 rimmon  staff  62587782  8  2  2014 oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm -rw-r–r–@ 1 rimmon  staff    634803  8  2  2014 oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm -rw-r–r–@ 1 rimmon  staff    852271  8  2  2014 oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm   // 2016.0202 —- 裝 pecl/oci8 command: pecl install oci8-2.0.10     2013.1225 added 3  apt-get install alien 6  apt-get install nfs-common 8  apt-get install […]

Categories
Copy_N_Paste DATABASE Programming/php

USE Oracle / oci8 with PHP / test sample code

前提環境要先裝好 Oracle instant client , 然後 PHP 要把 instantclient 編譯進去 –with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib 這是 sample code $conn = OCILogon(‘scott’, ‘scott’, ‘//172.30.0.176/DB1’); $query = ‘select * from dept’; $stid = OCIParse($conn, $query); OCIExecute($stid, OCI_DEFAULT); while ($succ = OCIFetchInto($stid, $row)) { foreach ($row as $item) { echo $item.” “; } echo “\n”; } OCILogoff($conn); … 1. 建 oracle table […]