使用PHP连接到Oracle

pecl install oci8

extension=oci8.so

<?php
// 设置Oracle数据库连接参数
$dbuser = "username";
$dbpass = "password";
$dbname = "//hostname:port/service_name";

// 创建一个Oracle数据库连接
$conn = oci_connect($dbuser, $dbpass, $dbname);

// 检查连接是否成功
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

// 准备SQL查询
$sql = "SELECT * FROM users";

// 执行SQL查询
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);

// 遍历查询结果
while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
    echo "<pre>";
    print_r($row);
    echo "</pre>";
}

// 关闭Oracle数据库连接
oci_close($conn);
?>