[woody382]

Hi,

I have created a mysql database which stores the information sent from a form i designed. Contained in the database are images, which are stored as a blob, which i think is the correct way to store the information.

the problem i am having is that I don't know how to view or retrieve the images. I can't click on the blob or anything.

Please advise what i need to do to retrieve the image and view it.

cheers

[Big-K]

Assuming you have php available to you, you need to do something along the lines of this:

fetch.php
//get the sql data, lets call the data for the image $image
imagejpeg($image); //this is assuming the data is a jpeg image

then when you want to output the image, you would have an image tag with a src of 'fetch.php', which can have as many get values as you want. The problem with storing data as blob is that you can't output it directly to the browser, you have to output it in a script then output the script in the img tag.

Another way that only works in firefox, safari, and opera, is to put <img src="data:image/jpeg;base64,****" />, replacing jpeg with the image format and **** with the string you put in the blob field, ala this
http://www.hedgerwow.com/360/dhtml/b...image/demp.php

[woody382]

is there another way of storing the information in mysql instead of a blob, which will make it easier to access the images.

cheers

[tomdkat]

Here is a thread that might be of help.

Peace...

[Mudley]

i'm not a fan of images stored in mysql

store it elsewhere and keep the path or image name in the database

[woody382]

this is the code which stores the downloaded images in mysql database. How would i change the code so that the pics shows the path to my upload folder on my server.


@$pfw_strQuery = "INSERT INTO `picfile`(`,`pic 1`,`pic 2`,`pic 3`,`pic 4`,`pic 5`,`pic 6`,`pic 7`)VALUES (\"$pic_1_Name\",\"$pic_2_Name\",\"$pic_3_Name\",\"$pic_4_Name\",\"$pic_5_N ame\",\"$pic_6_Name\",\"$pic_7_Name\")" ;
@$pfw_host = "server name";
@$pfw_user = "user";
@$pfw_pw = "password";
@$pfw_db = "database";
$pfw_link = mysql_connect($pfw_host, $pfw_user, $pfw_pw);
if (!$pfw_link) {
die('Could not connect: ' . mysql_error());
}
$pfw_db_selected = mysql_select_db($pfw_db, $pfw_link);
if (!$pfw_db_selected) {
die ('Can not use $pfw_db : ' . mysql_error());
}