使用PDO和stream_get_contents将Oracle BLOB图像作为空资源返回

$dsn = 'oci:dbname=//localhost:1521/orcl;charset=UTF8';
$username = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
    exit;
}

$sql = 'SELECT image_blob FROM images WHERE image_id = :id';

$imageId = 1; // 替换为实际的图像ID
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':id', $imageId, PDO::PARAM_INT);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);
$imageBlob = $result['image_blob'];

$stream = fopen('php://temp', 'r+');
fwrite($stream, $imageBlob);
rewind($stream);