Re: Re: Displaying images

On Wed, 2009-05-27 at 15:14 -0400, Bastien Koert wrote: > On Wed, May 27, 2009 at 3:05 PM, Ashley Sheridan > <ash@ashleysheridan.co.uk>wrote: > > > On Wed, 2009-05-27 at 14:03 -0400, Bastien Koert wrote: > > > On Wed, May 27, 2009 at 1:51 PM, Miller, Terion < > > > tmiller@springfi.gannett.com> wrote: > > > > > > > > > > > > > > > > > > > On 5/27/09 12:49 PM, "Bastien Koert" <phpster@gmail.com> wrote: > > > > > > > > On Wed, May 27, 2009 at 1:46 PM, Shawn McKenzie <nospam@mckenzies.net > > > > >wrote: > > > > > > > > > Miller, Terion wrote: > > > > > > I am trying to get an image to display but I get nothing if done > > like > > > > > this: > > > > > > > > > > > > <tr> > > > > > > <td>Scout Photo:</td> > > > > > > > > > > > > <td><img src="<?php echo > > > > > > $row['ePhoto'];?>"></td> > > > > > > > > > > > > </tr> > > > > > > > > > > > > > > > > > > If I just echo the field I do get the file name.... > > > > > > > > > > > > > > > > Does the filename include the path? Does the image with said > > filename > > > > > actually exist in that path? > > > > > > > > > > -- > > > > > Thanks! > > > > > -Shawn > > > > > http://www.spidean.com > > > > > > > > > > -- > > > > > PHP General Mailing List (http://www.php.net/) > > > > > To unsubscribe, visit: > > > > > http://www.php.net/unsub.php > > > > > > > > > > > > > > Is it an image from the db or a path to an image on the filesystem? > > > > > > > > -- > > > > > > > > Bastien > > > > > > > > Cat, the other other white meat > > > > > > > > > > > > Hi Bastien it is an image in the db. > > > > Thanks > > > > Terion > > > > > > > > > > You can't display the image that way due to differeing headers in > > required > > > for html and images. Change your image code to call a page that > > specializes > > > in handling the images and the headers needed by changing to something > > like > > > this: > > > > > > echo "<img > > > src=\"show_image.php?id=".$rows['id']."\">\n"; > > > > > > where the show_image page calls the image out from the db and display it > > as > > > below > > > > > > <?php > > > require("conn.php"); > > > //check to see if the id is passed > > > if(isset($_GET['id'])) { > > > $id=$_GET['id']; > > > > > > //query the database to get the image and the filetype > > > $query = "select bin_data, filetype from binary_data where id=$id"; > > > > > > $result = mysql_query($query); > > > $row = mysql_fetch_array($result); > > > { > > > $data = $row['bin_data']; > > > $type = $row['filetype']; > > > } > > > if ($type=="pjpeg") $type = "jpeg"; //handle the ms jpeg > > alternate > > > format > > > Header( "Content-type: $type"); > > > echo $data; > > > } > > > ?> > > That's only true if the image is stored in the database as a BLOB or > > somesuch. If the database is just storing the filename of the image, > > then it may just need the correct directory path prefix. Go into your > > browser, right-click and check to see what path and filename the browser > > expects to find the image file. My guess is it's not the same as where > > the image actually is, and you need to add the path before opening the > > <?php tag. You can use either an absolute path (e.g. using a full > > http://domain) or a relative one, and relative paths can > > include the ../ > > directory if you need to move up the directory tree. > > > > > > Ash > > www.ashleysheridan.co.uk > > > > > Terion stated it was in the db > The thread didn't follow on properly, my email client wasn't able to join t by thread so I didn't see his message until after I'd replied, sorry! Ash www.ashleysheridan.co.uk