using blob,php and informix ...

[Anon]

Hi!

I work in a french firm making health softwares. And we have a problem...

We use an informix database installed on a linux server. We manage to storage images and Word documents as blob. We also manage to get them back with dbaccess.
BUT...we don't manage to display these images from an html page, that is to say we don't manage to select a blob from the database with PHP.

If someone had this problem...let me know about it, please.

Thank you for your answers!

Nathalie for SIGEMS.

[plutoplanet]

I have the same problem. It appears to me that displaying blobs in a web-browser simply doesn't work the way it is described at php.net.

I have found a workaround where I write blobs into the filesystem and get them from there:

$getImg=ifx_query("SELECT LOTOFILE (thumbnail, '/daten/ifx/apache/htdocs/archiv/tmp/gfxPrint/tmpthumb/$getGfxPrintRow[assetid].jpg!', 'server') FROM koch_graphicsprint WHERE assetid = '$getGfxPrintRow[assetid]'",$connection);

echo "<IMG SRC=/tmp/gfxPrint/tmpthumb/".$getGfxPrintRow[assetid].".jpg></TD>";

I know this is not nice.

If you found another solution in between, please let me know!

yours,

Herwig