HELP: Can't display image.

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

March 2nd, 2005, 03:04 AM

perlnewbie23

Contributing User

Join Date: Oct 2004

Posts: 105

Time spent in forums: 4 h 41 sec
Reputation Power: 4

HELP: Can't display image.

Hi, I'm trying to display an image from my database but the image can't be seen. Here is my code:

PHP Code:


		
			
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Air Jordan 1</title>

</head>



<body>

<cfquery name = "aj1shoelist" datasource = "shoes">

SELECT imageURL, name, brand, details, price, size, color 

from Shoe WHERE name = 'Air Jordan 1'

</cfquery>

<cfoutput query="aj1shoelist">

<p><img src = "#imageURL#" alt="Image"/> </p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<table border="1" width="801" height="170"> 

    <tr>

    <td width="90" height="21"><strong>NAME: </strong></td>

    <td width="699">#name#</td>

    </tr>

    <tr>

    <td height="21"><strong>BRAND: </strong></td>

    <td>#brand#</td>

    </tr>

    <tr>

    <td height="21"><strong>DETAILS: </strong></td>

    <td>#details#</br></td>

    </tr>

    <tr>

    <td height="21"><strong>COLOR: </strong></td>

    <td>#color#</br></td>

    </tr>

    <tr>

    <td height="21"><strong>PRICE:</strong></td>

    <td>#price#</td>

    </tr>

    <tr>

      <td height="26"><strong>SIZE:</strong></td>

      <td><SELECT NAME="Size">

        <OPTION>Select a size</OPTION>

        <OPTION VALUE="#size#">#size#</OPTION>

      </SELECT></td>

    </tr>

    <tr>

    <td height="21">&nbsp;</td>

    <td>&nbsp;</td>

    </tr>

</table>

</cfoutput>



<a href="Welcome.htm">Home</a>

</body>

</html>

Thanks!

March 2nd, 2005, 07:06 AM

Black Adder

Registered User

Join Date: Nov 2004

Posts: 16

Time spent in forums: 9 h 47 m 27 sec
Reputation Power: 0

Have a look at the URL, which is tried to be displayed. (right klick the image spaceholder and select properties)
Is that URL the one it should be?

March 2nd, 2005, 08:01 AM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,626

Time spent in forums: 1 Week 4 Days 10 h 6 m 34 sec
Reputation Power: 53

As I noted in the other thread, I strongly recommend against storing the image in the database. Store the path and then just use the path to populate an <img> tag when you want to display the image.

__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian.
How to Post a Question in the Forums

March 2nd, 2005, 09:34 AM

Black Adder

Registered User

Join Date: Nov 2004

Posts: 16

Time spent in forums: 9 h 47 m 27 sec
Reputation Power: 0

Is he storing the whole image in the database?
I assumed he is storings a path, because of the fieldname 'imageURL'.

March 2nd, 2005, 10:29 AM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,626

Time spent in forums: 1 Week 4 Days 10 h 6 m 34 sec
Reputation Power: 53

Yes it looks like you're right. If there is a problem then it is with the path he's using for the image. It must be a relative path or absolute path, not a full system path (unless you plan on deriving the web path from the system path which is more complicated).

Absolute paths are easiest, so the path should be something like:

"/images/myimage.jpg"

This depends of course on your actual directory structure.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: