Hi,
I have to retrieve images stored as BLOBs inside of a MySQL DB, and then display them on a page.
Since these BLOBs need to be preceded by a header, I am trying to use a PHP script to output them on the screen. In my code section, I use a statement like:
echo '<img src="myscript.php?pic_num=2" />'; or echo "<img src=\"myscript.php?pic_num=2\" />";
No image is displayed in either case, and it is no wonder because when I see the image properties, it seems that an attempt is made to display myscript.php itself. Is there any way I can invoke myscript.php?
Or is there someone who has successfully implemented something like what I am trying to do.
Any help will be most appreciated!
You will have to tell the browser that a picture is being sent.
Before sending the image data, do the following in your PHP script.
Quoteheader("Content-type: image/png");
(or image/jpg image/gif etc)
That should help.
Cheers,
Ruud
Hi Ruud,
I am sending the content-type header, and it works when I try it from PHP/HTML, without the WB code section. Anyway, I resolved the issue by having the system store the images in files and storing the filenames in MySQL.
Thanks a lot for your help!