Re: how to show image from mssql server
| From: | TopDog | Date: | Thu, 16 Aug 2001 00:36:07 +0000 |
| Subject: | Re: how to show image from mssql server | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-8885@lists.php.net to get a copy of this message | ||
OK, I'm pretty new to the windows/PHP combination, but I think I might have
a clue for you.
First for the following to work, I believe this only work with Apache.
In the file which uses the graphic include HTML like this:
<img src="image.php?whatever=someID" ... >
In the file 'image.php', you need to send the appropriate HTTP header prior
to streaming the image data:
<?php header ("Content-Type: image/jpeg"); ?>
I have used the IIS/ASP/VBasic equivelent of this, so in general the concept
works.
Hope this helps,
John Burns
"Sur-Php" <sur_php@yahoo.com> wrote in message news:0440.010815@yahoo.com...
> Hello php-windows,
>
> This is my query:
>
> $query= " select Image from ImageTable where MainCode='040191' ";
>
> it returns data like this..
>
> 0x424d2e040000000000003e00000028000000770000003f000000010001000000
> 0000f00300000000000000000000020000000000000000000000ffffff00ffffff
> fff03fffffffffffffffffff00f03fffffe01ffffffffffcff8fffff00e00fffff
> cfcfff7ffffff8ff07ffff00cfc3ffff9fe7ff3ffffff87f33ffff00
>
> i know that this is BLOB data...
> (which are actually small bmp files)
> so how can i show it in web page....
>
>
>
> --
> Best regards,
> sur-php mailto:sur_php@yahoo.com
>
>