PHP5 連線 Oracle -- 初體驗
liang | 2010-04-09 15:05:28 | PHP
到Oracle 官網下載Oracle jdk,編譯oci8 時需要,
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
unzip /root/oracle-instantclient-basic-10.2.0.4-1.i386.zip
unzip /root/oracle-instantclient-devel-10.2.0.4-1.i386.zip
mv instantclient_10_2/ /opt/oracle/instantclient
記得安裝oci8
cd oci8
/opt/php/bin/phpize
ln -sf /opt/oracle/instantclient/libclntsh.so.10.1 /opt/oracle/instantclient/libclntsh.so
./configure --with-oci8=shared,instantclient,/opt/oracle/instantclient --with-php-config=/opt/php/bin/php-config
add extension=oci8.so to php.ini
oci.php
<?php
$dbstr ="(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.150)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)))";
$con=oci_connect('username','passwd',$dbstr) or die ('Fail to connect Oracle DB');
$req=oci_parse($con,'select * from table') or die ('Fail to get data');
oci_execute($req);
//while ($row=oci_fetch_assoc($req)){
while ($row=oci_fetch_array($req)){
/*
foreach ($row as $item){
echo $item."\n";
}
*/
print_r($row);
}
?>
========================================================================
相關文章
2.0|XML