windows下安装php+oracle

本文标题:windows下安装php+oracle【本站如从外站转载,会注明出处】
本文链接:http://www.validba.net/2009/02/windows%e4%b8%8b%e5%ae%89%e8%a3%85phporacle/

linux下安装php+oracle(-)

linu下安装php+oracle(二)

windows 下安装比较简单,

1、下载php二进制版本(不是.msi安装版)

将下载后的zip包解压一个目录,修改php.ini文件,去掉extension=php_oci8.dll前面的注释;编辑PATH环境变量,添加php的路径.

2、安装oracle或oracle instantclient

如果是安装的是服务器版本或者client版本,添加环境变量TNS_ADMIN,指向包含tnsnames.ora文件的目录(%ORACLE_HOME%networkadmin);

如果安装的是instantclient,将配置后的tnsnames.ora文件拷如instantclient目录,然后将TNS_ADMIN指向instantclient目录.

3、测试脚本

<?php
$c = oci_connect("iqueweb","iv1234","scmdb_test");
$sql_parse =
oci_parse($c,"select tablespace_name from
user_tablespaces");
oci_execute($sql_parse,OCI_DEFAULT);
oci_fetch_all($sql_parse,$result);
print_r($result);
oci_close($c);
?>

4、执行

D:phppro>php win.php

Array
(
[TABLESPACE_NAME] => Array
(
[0] => SYSTEM
[1] => UNDOTBS1
[2] => TEMP
[3] => SCMD
[4] => SCMX
[5] => USERS
[6] => CRMD
[7] => CRMX
[8] => SCMHQD
[9] => SCMHQX
[10] => SYSAUX
[11] => HRD
[12] => HRX
[13] => APP_TEMP
)

)

相关参考:

www.php.net

CopyRight Validba'S Home 版权所有.本站为个人学习之用,评论时请遵守本国法律

Relative Posts

Tags:

Reader's Comments »

  1. By Artie on 2011/12/15 at 10:27 上午

    BS low – ratoinality high! Really good answer!

Leave a Reply