PHP mySQL image blobs

Rob

Ummm...I'm a little stuck on how to approach the following....

I have a mySQL table holding images (fields are: data (blob), name (text),
type (text), size(text), desc (text) )

If I want to show the image on a page (they're all jpg's), how do I do I
implement this?

Uploading, downloading, text listing it is easy...I'm just wondering how I
SHOW it. :-)

I'm completely brain-frozen on this.

Thanks in advance,
Robert

Jul 16 '05 #1

Dana

Rob wrote:

I have a mySQL table holding images (fields are: data (blob), name (text),
type (text), size(text), desc (text) )
If I want to show the image on a page (they're all jpg's), how do I do I
implement this?

just print them:
header ("Content-type: image/jpeg");
$sql="select blobfield from table where ...";
$result=mysql_query($sql,$conn);
$img=mysql_fetch_row($result);
print $img[0];

Dana

Jul 16 '05 #2

BKDotCom

<?php
// perhaps called get_image.php...
// pass $_GET params to specify image or session vars... etc..
// instead of <IMG src="image.jpg"> it's <IMG
src="get_image.php?image=something"> or whatever
//... get the blob code....
header("Content-type: image/jpeg");
echo image blob;
exit;
?>

"Rob" <ro***************@sbcglobal.net> wrote in message news:<dK*****************@newssvr29.news.prodigy.c om>...

Ummm...I'm a little stuck on how to approach the following....

I have a mySQL table holding images (fields are: data (blob), name (text),
type (text), size(text), desc (text) )

If I want to show the image on a page (they're all jpg's), how do I do I
implement this?

Uploading, downloading, text listing it is easy...I'm just wondering how I
SHOW it. :-)

I'm completely brain-frozen on this.

Thanks in advance,
Robert

Jul 16 '05 #3

BKDotCom

?? this has been answered

<!-- surrounding html -->
<IMG src="image_getting_script.php?image=whatever">
<!-- and some more -->

are you concerned about having a "separate" script for the image
getting?
don't need a separate script... your page-generating script could only
output the image when given certain paramaters...
paul brown <pa**@paulbrown.net> wrote in message news:<ZcO9b.478412$Ho3.80600@sccrnsc03>...

Yes, but how would one do it in the context of surrounding it with an
html page, and not just the image itself?

paul
BKDotCom wrote:

<?php
// perhaps called get_image.php...
// pass $_GET params to specify image or session vars... etc..
// instead of <IMG src="image.jpg"> it's <IMG
src="get_image.php?image=something"> or whatever
//... get the blob code....
header("Content-type: image/jpeg");
echo image blob;
exit;
?>

"Rob" <ro***************@sbcglobal.net> wrote in message news:<dK*****************@newssvr29.news.prodigy.c om>...

Ummm...I'm a little stuck on how to approach the following....

I have a mySQL table holding images (fields are: data (blob), name (text),
type (text), size(text), desc (text) )

If I want to show the image on a page (they're all jpg's), how do I do I
implement this?

Uploading, downloading, text listing it is easy...I'm just wondering how I
SHOW it. :-)

I'm completely brain-frozen on this.

Thanks in advance,
Robert

Jul 17 '05 #4

Zac Hester

paul brown wrote:

Yes, but how would one do it in the context of surrounding it with an
html page, and not just the image itself?

paul
BKDotCom wrote:

[snip: answer to question]

BK answered your question (twice), but there's another possible answer
depending on your delivery context. If you're serving pages over WWW,
just use the "img" tag to point to your PHP script that prints the image
(like BK said). However, if you're using PHP to generate a MIME
encoded document (such as an email), you can also put the image data in
the HTML tag (so people aren't requesting a document on your server
every time they open that email message). If you are, in fact, creating
a MIME document, have a look at this article that has really good info
on MIME formats:

http://www.phpbuilder.com/columns/kartic20000807.php3

HTH,
Zac

Jul 17 '05 #5

Rob

Thanks Zac!

Actually, thank you everyone. Just for reference, phpbuilder has another
article for showing images directly from a db, including the PHP scripts...

http://www.phpbuilder.com/columns/fl...14.php3?page=1

But the MIME one you showed was also useful (for another project)
Robert

"Zac Hester" <ne**@planetzac.net> wrote in message
news:3f********@news.enetis.net...

paul brown wrote:

Yes, but how would one do it in the context of surrounding it with an
html page, and not just the image itself?

paul
BKDotCom wrote:

[snip: answer to question]
>>

BK answered your question (twice), but there's another possible answer
depending on your delivery context. If you're serving pages over WWW,
just use the "img" tag to point to your PHP script that prints the image
(like BK said). However, if you're using PHP to generate a MIME
encoded document (such as an email), you can also put the image data in
the HTML tag (so people aren't requesting a document on your server
every time they open that email message). If you are, in fact, creating
a MIME document, have a look at this article that has really good info
on MIME formats:

http://www.phpbuilder.com/columns/kartic20000807.php3

HTH,
Zac

Jul 17 '05 #6