Please note, that contents of LOB is cleared after this operation. If you want to use LOB data after exporting it to file, you should read it from file with file_get_contents().
This will not work:
<?php
if($blob) {
$filename = DOCUMENT_ROOT."/".$bildId.".jpg";
if($blob->export($filename)) {
while(!$blob->eof()){
$dbResult .= $blob->read(2000);
}
} else {
throw new Exception("Can not save the file ".$filename."!");
}
}
?>
Use this instead:
<?php
if($blob) {
$filename = DOCUMENT_ROOT."/".$bildId.".jpg";
if($blob->export($filename)) {
$dbResult = file_get_contents($filename);
} else {
throw new Exception("Can not save the file ".$filename."!");
}
}
?>
OCILob::export
(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
OCILob::export — Exports LOB's contents to a file
说明
OCILob::export(string
$filename, int $start = ?, int $length = ?): boolExports LOB contents to a file.
参数
-
filename -
Path to the file.
-
start -
Indicates from where to start exporting.
-
length -
Indicates the length of data to be exported.
返回值
成功时返回 true， 或者在失败时返回 false。
更新日志
| 版本 | 说明 |
|---|---|
| 8.0.0, PECL OCI8 3.0.0 | The OCI-Lob class was renamed to OCILob to align with PHP naming standards. |
add a note
User Contributed Notes 1 note
AlexiuS ¶
11 years ago
