Pull Image From MySqL and Display

stoneygossard

Hi,

I have a MySQL db with a table that contains a field which houses the name of an image e.g. image.jpg. The image is in the same directory as all the other files so I dont need to type the path.when I echo the contents of the record is should show the image referred to in the db shouldn't it? well it's not.It just shows an ugly image place holder.

Any ideas?

Stoney

mjax

Did you try this?

echo '<img src="'.$record['image_filename'].'">';

Obviously, I don't know your specific PHP code and/or SQL structure, so above code is pseudo.

bradgrafelman

mjax wrote:
Obviously, I don't know your specific PHP code and/or SQL structure

IOW: If you want us to help you with your script, you'll have to show us the relevant code.

stoneygossard

bradgrafelman wrote:
IOW: If you want us to help you with your script, you'll have to show us the relevant code.

OK here's the code:

 echo "<td><a href='../images/{$row['pix']}'
                           border='0'>
            <img src='../images/{$row['pix']}' border='0'
              width='100' height='80'></a></td>\n";

"pix" is the field name in the db table and $row is the record. The name of the picture e.g. dog.jpg is held in the pix field and the actual picture is held in the "images" folder of the main directory.Hope this makes sense as the picture is not being displayed still. any ideas?

Stoney

mjax

My guess would be that the path to the images you are using is not correct. Try using an absolute path instead of a relative one to get it to work. Just to make sure, an absolute path is "measured" from the webroot and starts with a slash. A relative path is relative to the current path, that can vary, depending where the script runs.

Is the "problem page" perhaps running on a public webserver for us to see? This could help analyse the problem.

stoneygossard

mjax wrote:
My guess would be that the path to the images you are using is not correct. Try using an absolute path instead of a relative one to get it to work. Just to make sure, an absolute path is "measured" from the webroot and starts with a slash. A relative path is relative to the current path, that can vary, depending where the script runs.

Is the "problem page" perhaps running on a public webserver for us to see? This could help analyse the problem.

Yes, my guess is also that it is the relative path so I have tried an absolute path but to no avail. Unfortunately i'm only using a local testing server so I cannot show you my problem, however, I think it's only a minor problem but it is paramount to my application as I need to store image names in the db for display.

Would the absolute path be from "c:/" or from "www/myApp/" - www being the webroot folder.I'm getting frustrated now.

Stoney

mjax

An absolute path starts with a /. It's mapped to your webroot. The client does not know anything about your local harddisk, so paths like C:/ will never work.