1. 安装Oracle(简)
配置/etc/profile ,添加oracle变量;
2. 安装apache;
#gzip -d httpd-2.2.21.tar.gz
#tar -xf httpd-2.2.21.tar
#cd httpd-2.2.21
#./configure --enable-so --prefix=/usr/local/httpd 【可使用./configure --help查看configure帮助】
#make
#make install
#/usr/local/httpd/bin/apachectl start 打开网页显示it's work!
安装成功。
#vi /etc/sysconfig/httpd
设置apache的环境变量,使httpd能找到oracle
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH://usr/lib/oracle/11.2/client64/lib
export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
#/usr/local/httpd/bin/httpd -l 查看apache支持模块
更改AllowOverride 权限None --> All:AllowOverride All
3. 安装php
#gzip -d php-5.3.8.tar.gz
#tar -fx php-5.3.8.tar
#cd php-5.3.8
#./configure --with-apxs2=/usr/local/httpd/bin/apxs --with-oci8=$ORACLE_HOME -with-config-file-path=/usr/local/php --prefix=/usr/local/php --with-mysql=/usr/local/mysql
#make
#make install
#cp php.ini-development /usr/local/php/php.ini
#cd /usr/local/httpd/conf
#cp httpd.conf httpd.conf.bak
#vim httpd.conf 添加:
LoadModule php5_module modules/libphp5.so
LoadModule php5_module modules/libphp5.so
index.php
#cd ../htdocs/
#vim test.php 添加:
<?php
phpinfo();
?>
打开页面:http://127.0.0.1/test.php 显示正常,则PHP安装成功。
4. 安装PDO_OCI
#gzip -d PDO_OCI-1.0.tgz
#tar -xf PDO_OCI-1.0.tar
#cd PDO_OCI-1.0
#locate phpize
#chmod 755 /u01/phpinstall/php-5.3.8/scripts/phpize
#/u01/phpinstall/php-5.3.8/scripts/phpize
#./configure --with-pdo-oci=$ORACLE_HOME --prefix=/usr/local/PDO_OCI
#make
#make install
[root@dev30 PDO_OCI-1.0]# make install
Installing shared extensions: /usr/local/php/lib/php/extensions/no-debug-non-zts-20090626/
[root@dev30 PDO_OCI-1.0]# cd /usr/local/php/
#vim php.ini添加:
Extension=/usr/local/php/lib/php/extensions/no-debug-non-zts-20090626/pdo_oci.so
重启apache
php -m 检查PDO_OCI模块正常加载
#cd /usr/local/httpd/htdocs
#vim oracle.php 测试oracle连接:
<?php
$param = $_POST;
$db_username = "fast";
$db_password = "2010hk04fast26";
$db = "oci:dbname=hkfastuatdb";
$conn = new PDO($db,$db_username,$db_password);
$stmt = $conn->query("select agentcode,agentname from agentbroker");
foreach ($stmt as $row) {
print $row['AGENTCODE'] . "\t";
print $row['AGENTNAME'] . "\t";
}
print_r($stmt);
?>
#php -f oracle.php 测试;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21986988/viewspace-723603/,如需转载,请注明出处,否则将追究法律责任。
上一篇: 没有了~
下一篇:
在linux下添加永久静态路由
![user_pic_default.png](http://blog.itpub.net/images/user_pic_default.png)
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
转载于:http://blog.itpub.net/21986988/viewspace-723603/