When I run the below query
select first 1 IMG from img_lib;
I get the output as IMG 4cc:0 BLOB display set to subtype 1. This BLOB: subtype = 0
Can any one help me with a PHP code to display the blob content as an Image? I don't think MySQL will work here, Can anyone help me with firebird query?
PHP offers two libraries to work with Firebird/Interbase databases: Ibase & PDO.
Ibase offer two ways to retrieve blobs. One is using lazy loading with ibase_blob_get function:
if (is_null($field)) return null;
$info = ibase_blob_info($field);
$handle = ibase_blob_open($field);
return ibase_blob_get($handle, $info[0]);
This way is good, when you need to fetch just some blobs, not all, as it is a costly operation.
Another way is to use IBASE_TEXT fetch flag parameter in ibase_fetch_assoc function or fetch object / row. It will return right in fetch result the blob content.
The second library, PDO with Firebird driver, fetches blobs automatically.
Next after you have loaded BLOB content into memory, you need to output it as an image. Here is a sample code, assuming you have a jpeg image format:
<?php
// fetch here blob content described in previous methods
header('Content-Type: image/jpeg');
echo $blob_content;
Later point image source to your script like <img src="blob_image.php" />
...cast (blob-column-name as varchar(...) collate octet)...ibase_blob_get function, it allow to load big blobs in chunks ibase_blob_get(handle, size). Strange, at time we used ibase_ we loaded it in one call. PDO internally load the whole blob in chunks: github.com/php/php-src/blob/master/ext/pdo_firebird/…
ibase_blob_echo.