At 9:19 AM -0400 10/31/10, Gary wrote:
I was sure that the images were being stored and called from the images
folder and not directly from the DB, that is until tedd brought it up.  I
did have an issue of getting the images to show in the beginning, however I
solved it by inserting the path in the call from the DB.  I am wondering now
if they are stored in both locations.



Both locations? I think you are confusing yourself.You either have the images stored in the database OR the file system, but not both.

However, I think you have the images stored as files within the file directory, such as:

Now, in your database you should have only the path name stored (i.e., images/picture1.jpg) and not the image. However, I usually only store the file names and NOT the path. That way I can move the images to where ever I want and only change their reference in the HTML.

To recap, to show any image you use the HTML img tag, such as:

<img src="images/picture1.jpg">

To tie this statement to a database, you need to pull out the image name (or file path) from the database and use that. Something like this:

$query = "SELECT file_name FROM pictures WHERE id = '$id' ";
$result = mysql_query($query) or die();
$row = mysql_fetch_array($result);
$file_name = $row['file_name'];

And then in the HTML you would use:

<img src="images/<?php echo($file_name);?>">

If you can get to this part, then we can deal with placing a watermark on the image before showing it.

Please let me know when you get this part to work.



PS: There is no need to use a LONG BLOB in your database -- that's just a waste of space.


PHP General Mailing List (
To unsubscribe, visit:

Reply via email to