1.安装oracle_client
解压instantclient-basic-nt-12.1.0.2.0.zip到文件夹
然后配置环境变量
oracle_client安装完毕。
2.配置php
在php.ini中有这样一段代码(笔者版本是php 5.6.30)
;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
由此可知,php5.6默认oracle扩展是php_oci8_12c.dll. 把扩展打开(即去掉前面的分号)后启动php出现:
使用oci_connection提示error:Call to undefined function oci_connect
等等各种错误。网上搜罗了各种办法,什么把php_oci8_12c.dll文件拷贝到system32目录下、oci.dll文件拷贝到system32下之类的都没能解决
换一种思路,下载相应版本的php_oci8_11g.dll放在E:\software\WNMP\php5\ext目录下,然后在php.ini中加入相应的扩展
extension=php_oci8_11g.dll
。至此问题解决.
3.测试是否支持oci8
执行命令php –ri oci8 或者phpinfo()打印信息查看是否有OCI8模块
4.连接实例
<?php
//$conn = oci_connect('用户名','密码','127.0.0.1/orcl');
$dbstr ="(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)))";*/
$conn = oci_connect('用户名','密码',$dbstr,'utf8');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
$sql ="insert into 表名 (id,publish_date)values(:id,:publish_date)";
$statement = oci_parse($conn,$sql); //编译sql语句
oci_bind_by_name($statement,":id",$id);
oci_bind_by_name($statement,":publish_date",date('Y-m-d H:i:s',time()));
$state=oci_execute($statement,OCI_COMMIT_ON_SUCCESS); //执行
oci_free_statement($statement);
oci_close($conn);
?>
php连接oracle设定字符集,避免乱码
oci_connect("scott", "tiger", $db, 'UTF8');