php , mysql,coding

Question

i uploaded my images in mysql using blob with php coding. now how can i retrieve them and display inside a browser. ofcourse i also want swf files

Answer 1

header('Content-Type: image/jpeg'); # or another type
echo $result['image'];

The header function is the key. You need to tell the browser that this output is a certain type. For your swf, you need to use application/x-shockwave-flash (at least that's what the first google hit produced).

Answer 2

I beleive you need to make a script which you use in place of the image for example instead of:

<img src="/image/path/to/my/image.jpg />

you would have something like:

<img src="/image.php?image=image.jpg" />

So then in image.php you would need to do the following:

1. Query the database for the record with the image, based on the parameters passed to image.php
2. Do any necessary operations on the blob so you can ouput it
3. set the proper http headers for the image
4. print the blob data

For the most part its better to just store and maintain the path to an image on the filesystem/http instead of putting the actual image data in the db. There ae ofcourse all kinds of exceptions to that, but for the most part this is how its done.