Displaying Thumbnails in browser.

[Charlie Markwick]

I'm trying to display the embedded thumbnail in a browser. The thumbnails are being stored as JPEG (Lossy). I'm using the PHP code:-

print ' ';

... however this doesn't worked and I'm stumped as to how to proceed. Does anyone have any ideas?

[Daan van Rooijen]

I can't comment on the source code as such (I don't speak PHP), but to my knowledge the thumbnail is stored as a straight binary stream without any base64 encoding (in other words, if you would export the data from the blob to a file, it would be a regular .jpg file like any other).

I found some PHP source code from a similar project that someone built around a PostgreSQL ThumbsPlus v6 database. If you'd like to see it, send me an e-mail and I'll forward it to you.

[Charlie Markwick]

Please Daan. I'll try without decoding too.

[Charlie Markwick]

It seems that whatever I try I can't get the thumbnails to display. The BLOB does not appear to be a raw JPEG. If I change the database format and select to store the thumbnails in files then they do get saved as JPEGS. However I can't see any way of identifying the path to the external file, there must be a way. This is a show stopper, if I can't find a solution to it then I'll have to abandon using T+ for my local school. I seem to remember there used to be a Web Client product that allowed access to the images. Can't find it now though.

[Daan van Rooijen]

The web client never reached full maturity and is no longer sold or supported.

Are you sure that the BLOB data isn't a full .JPG? I found some ADO code (which I don't speak either) that retrieves thumbnails and saves them as .jpg and it doesn't seem to do anything to the data. I'll post it in a reply.

[Daan van Rooijen]

Paul,

This worked in a Microsoft Access Project file which uses ADO. You should be
able to reshape it to your needs. Substitute 'CurrentProject.Connection'
with your own connection object. The only restriction is that the the
thumbnail in TP needs to be in JPEG format.

Hope this helps

Allan
============================================
Function WriteJPG(idThumb As Long, Destination As String)
    Dim objRecordset As New ADODB.recordset
    Dim stream As New ADODB.stream

    With objRecordset
        .Open "thumbnail", CurrentProject.Connection, adOpenStatic,
adLockReadOnly, adCmdTableDirect
        .MoveFirst
        .Find "idThumb = " & CStr(idThumb)

        If .EOF Then GoTo Finish

    End With

    With stream
        .Type = 1 'adTypeBinary
        .Mode = 3 'adModeReadWrite
        .Open
        .Write objRecordset("Thumbnail")
        .SaveToFile Destination, 2 ' adSaveCreateOverwrite
        .Close
    End With

Finish:

    Set stream = Nothing
    objRecordset.Close
    Set objRecordset = Nothing

End Function
============================================

[Charlie Markwick]

I can save a thumbnail into the DB as a JPEG and retrieve it OK. The problem is retrieving the ones that T+ has made.