MSSQl,PHP,ADO and Byte Arrays!

bodgadle

Hi all,

And what a first post hey! I've searched high and low for the answer to this, tried all the newsgroups and asking in #php but to no avail, so hopefully some bright spark here can help.

For various reasons i'm using PHP with ADO to connect to MS SQL 2000 (mostly because it's the best way to do it for me since I have a load of stored procedures with out parameters).

Anyway, everything works a treat, I can call SP's, get out params, call SQL statements, everything happy as larry... except... BLOBS!!

I've managed to get my BLOB field back, that's no problem. What my issue is is getting PHP to display it (trying to show it as a gfx).

I've managed to read the blob using .GetChunk from ADO and the size of the chunk is fine

i.e count($arrBytes) is the size of the image

however!! how do I get this to the user? When I try printing it, all I get is decimal numbers which isn't right. When I try implode it gets even weirder and PHP seems to change the size (strlen($imploded) = 1194!!!!

ANyone help here at all? I've tried using ADO.Stream too but it fails when I pass it the blob field for stream->Write

Thanks in advance, there's a big beer in it for whoever solves this one!!

nnichols

A script can only output a single file type. You need to use a separate script to output the images as it needs to produce the image header and then output the image data.

This is covered in the php manual and there have been several posts on this recently on here.

Hope this helps 😉

nnichols

Have a look at this post -

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10223276

bodgadle

Hi there,

That is exactly what the script does, it set shte header to image/jpeg then reads the blob data using getchunk and outputs it. but all i got in ie was the redbox

so I removed the header set and viewed waht was beingoutput and that's how I know all I'm getting is decimal data.

It seems getChunk returns a byte array because if I do a

print/echo $arrData then I get "Array" shown on screen

And if I print_r the contents, I have 4600 elements each with decimal numbers in there not binary.

Hope someone can help

bodgadle

I found a workaround but am concerned since I use this function a lot on the site to stream graphics from the blob.

After calling getChunk and you get your byte array, I had to do this

for($iLoop=0;$iLoop<count($t_chunk);$iLoop++)
$blobData .= chr($t_chunk[$iLoop]);

This then built up what I needed in $blobData so when I echo or print $blobData now I see my image on the screen

of course to save memory you could also just

echo chr($t_chunk[$iLoop]);

Hope someone else finds this usefull, or if someone has a better solution, please let me know.

Thanks