[Man2u2uk]

Hi,


how would i go about storing pictures in a database & then echoing them

[Ben Abrams]

Man2u2uk, on Apr 19 2007, 09:16 AM, said:

Hi,
how would i go about storing pictures in a database & then echoing them

you would be taking advantage of the the BLOB fields in databases.

However, this is NOT a good idea to do with images any bigger then thumbnails. As your putting a lot of stress on the mysql server if you do, which some hosts do not allow. I really reccomend uploading the file and then saving the path to the file in the database instead.

however, i will answer your question breifly..

$image = addslashes(@fread(@fopen($dir.'/'.$file, "r"), @filesize($dir.'/'.$file))))

Then $image is ready for an INSERT statement..
to retrieve, something like this, after a SELECT query.

$image = $r['myimage']; 
header("Content-type: image/gif"); 
print $image;

Agin i need to WARN you from doing this. its really not the best option.
EDIT

Read this: http://www.webmaster...orum88/9091.htm

[Man2u2uk]

Thanks,

all i need to do is echo pictures from my databse on a catalog page. (its only for university work)

the pictures only really need to be thumbnail size anyway

[benbacardi]

Hey,

Is this for the Web Project or Intro to Internet Apps one - because for the Web Project, I've got a similar thing for products.

In the database each product has an ID, and I just use that ID as the name (or part of) of the product image.

For example, one product could be ID number 48, and the image is in the folder images/products/48.jpg

Then I use PHP to build up the image string using to ID where needed.

Make sense?

[Man2u2uk]

Thanks ben,

i managed to do it by storeing the images URL in the database: i.e http://www.google.com/images/bike.jpg

then searching for it: $prod_pic=mysql_result($result,$i,"prod_pic");

then echoing it: <? echo "<img src=\"$prod_pic\" />"; ?>

[benbacardi]

Effectively the same idea then

[Ben Abrams]

Glad you didnt use Binary file in mysql

[EncoderDecoder]

Man2u2uk, on 19 April 2007 - 08:54 AM, said:

Thanks ben,

i managed to do it by storeing the images URL in the database: i.e http://www.google.com/images/bike.jpg

then searching for it: $prod_pic=mysql_result($result,$i,"prod_pic");

then echoing it: <? echo "<img src=\"$prod_pic\" />"; ?>

we had the same idea..