环境: CentOS7 x86_64
PHP 7.1.2(安装路径:/usr/local/php7.1.2)
Oracle 11G R2
1.下载Oracle客户端:(http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html)
instantclient-basic-linux.x64-11.2.0.4.0.zip
instantclient-sdk-linux.x64-11.2.0.4.0.zip
2.下载php oracle模块
1
|
wget http: //pecl .php.net /get/oci8-2 .1.4.tgz
|
3.安装依赖包
1
|
yum -y install autoconf automake gcc libaio-devel unzip
|
4.安装
1
2
3
4
5
6
7
8
9
10
|
cd ~
unzip instantclient-basic-linux.x64-11.2.0.4.0.zip unzip instantclient-sdk-linux.x64-11.2.0.4.0.zip cp instantclient_11_2 /libclntsh .so.11.1 instantclient_11_2 /libclntsh .so
tar zxf oci8-2.1.4.tgz
cd oci8-2.1.4
/usr/local/php7 .1.2 /bin/phpize
. /configure --with-php-config= /usr/local/php7 .1.2 /bin/php-config --with-oci8=instantclient, /instantclient_11_2 make && make install
echo 'extension = "oci8.so"' >> /usr/local/php7 .1.2 /etc/php .ini
|
5.测试
1
2
|
/usr/local/php7 .1.2 /bin/php -m | grep oci
oci8 |
1
2
3
4
5
6
7
8
9
10
11
|
<?php $conn = oci_connect( 'username' , 'password' , '192.168.1.100/ORCL' );
$sql = "select * from table_name " ;
$ora_test = oci_parse( $conn , $sql );
oci_execute( $ora_test ,OCI_DEFAULT);
while ( $r =oci_fetch_row( $ora_test ))
{ echo $r [0];
echo "<BR>" ;
} ?> |