By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,687 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,687 IT Pros & Developers. It's quick & easy.

PHP mySQL image blobs

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
<?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

P: n/a
?? 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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.