|
1、启用PHP中的PHP_oci8模块
2、然后利用oci_connect()连接- <?php
- /*
- * CopyRight : [Discuz!] (C)2001-2099 HaoTeam Inc.
- * Document : newDiscuz 前台脚本.php
- * Created on : 2013-8-3,13:31:14
- * Author : 51漂泊(51piaobo) www.51piaobo.com $
- * Description: This is NOT a freeware, use is subject to license terms.
- * 这即使是一个免费软件,使用时也请遵守许可证条款,得到当时人书面许可。
- * 未经书面许可,不得翻版,翻版必究;版权归属51漂泊;
- */
- /*
- if (!defined('IN_DISCUZ')) {
- exit('Aecsse Denied');
- }
- *
- */
- header("Content-type:text/html;charset=utf-8");
- //Oracle连接字符串
- $db = "(DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.133)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = mgdrp)
- )
- )";
- //连接Oracle
- $conn = oci_connect('hscmp','Ybbg2013mgdrp',$db,'utf8');
- //返回SQL执行标示
- $stid = oci_parse($conn,'select * from tskuplu');
- oci_execute($stid);
- $row = oci_fetch_array($stid,OCI_ASSOC);
- print_r("<pre>");
- print_r($row);
- ////执行SQL语句
- //while (($row = oci_fetch_array($stid,OCI_ASSOC))){
- // echo $row[0]." and ".$row['employeeid']."<br>\n";
- //}
- //释放资源
- oci_free_statement($stid);
- //关闭连接
- oci_close($conn);
- ?>
复制代码 |
|