469,328 Members | 1,324 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,328 developers. It's quick & easy.

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
5 36774
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
<?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
?? 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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by mir nazim | last post: by
1 post views Thread by Raaijmakers, Vincent (GE Infrastructure) | last post: by
10 posts views Thread by John Smith | last post: by
35 posts views Thread by Stan Sainte-Rose | last post: by
4 posts views Thread by cuyler.jones | last post: by
10 posts views Thread by eholz1 | last post: by
3 posts views Thread by Taras_96 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Purva khokhar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.