linux系统下php oracle扩展OCI8的安装与配置
时间:2022-03-13 23:20
./configure --with-php-config=/usr/local/php/bin/php-config --with-oci8=instantclient,/usr/lib/oracle/11.2.0.4.0/client64/lib/
make
make instal
lphp路径和oracle client的路径需根据实际情况进行修改。
如果系统中存在pecl程序,可通过以下命令来安装oci8扩展:
pecl install oci8
系统环境与php配置修改修改系统配置:
echo "/usr/lib/oracle/11.2.0.4.0/client64//lib/"
>/etc/ld.so.conf.d/oracle_client.conf/sbin/ldconfig
修改php.ini配置文件:
extension_dir = "/usr/local/php5/lib/ext"
extension = "oci8.so"
oci8.privileged_connect = on
重启apache使修改生效
/usr/local/apache2/bin/apachectl restart
测试链接代码,确认配置成功
<?php
$conn = oci_connect(‘qunyingliu‘, ‘testqunyingliu‘, ‘oracle.test.localhost/orcl‘);
//需要根据实际配置信息进行修改
$stid = oci_parse($conn, ‘select table_name from user_tables‘);
//数据库操作语句可根据实际需求进行修改
oci_execute($stid);
echo "<table>\n";
while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
echo "
\n";
foreach ($row as $item) {
echo "<td>".($item !== null ? htmlentities($item, ENT_QUOTES) : " ")."\n";
}
echo "\n";
}
echo "</table>\n";
?>
相关参考:
本文出自 “” 博客,请务必保留此出处