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

[Dana]

Re: PHP mySQL image blobs

Rob wrote:[color=blue]
> 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?[/color]

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

Dana

[BKDotCom]

Re: PHP mySQL image blobs

<?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=somet hing"> or whatever
//... get the blob code....
header("Content-type: image/jpeg");
echo image blob;
exit;
?>

"Rob" <robertkaranfil ian@sbcglobal.n et> wrote in message news:<dKn9b.300 3$351.2082@news svr29.news.prod igy.com>...[color=blue]
> 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[/color]

[BKDotCom]

Re: PHP mySQL image blobs

?? this has been answered

<!-- surrounding html -->
<IMG src="image_gett ing_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 <paul@paulbrown .net> wrote in message news:<ZcO9b.478 412$Ho3.80600@s ccrnsc03>...[color=blue]
> 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:[color=green]
> > <?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=somet hing"> or whatever
> > //... get the blob code....
> > header("Content-type: image/jpeg");
> > echo image blob;
> > exit;
> > ?>
> >
> > "Rob" <robertkaranfil ian@sbcglobal.n et> wrote in message news:<dKn9b.300 3$351.2082@news svr29.news.prod igy.com>...
> >[color=darkred]
> >>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[/color][/color][/color]

[Zac Hester]

Re: PHP mySQL image blobs

paul brown wrote:
[color=blue]
> 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:
>[color=green]
>> [snip: answer to question]
>>[/color][/color]

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

[Rob]

Re: PHP mySQL image blobs

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/florian19991014.php3?page=1

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


Robert



"Zac Hester" <news@planetzac .net> wrote in message
news:3f68dad4$1 @news.enetis.ne t...[color=blue]
> paul brown wrote:
>[color=green]
> > 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:
> >[color=darkred]
> >> [snip: answer to question]
> >>[/color][/color]
>
> 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
>[/color]