On Oct 30, 2010, at 9:31 AM, Gary wrote:

"tedd" <tedd.sperl...@gmail.com> wrote in message
At 3:05 PM -0400 10/29/10, Gary wrote:
I am trying to get the watermark to work, however I am having a problem in
that the image is being called from a database (image sits in images

The script in question is this

$image = imagecreatefromjpeg($_GET['src']);

However it produces an error message of

Warning: imagecreatefromjpeg() [function.imagecreatefromjpeg]: Filename cannot be empty in /home/content/a/l/i/alinde52/html/ imagesDetail.php on
line 233

I have tried various methods, for example: ($_GET ['images/'] or ($_GET

Can anyone shed some light on this for me.

Thank you



Several things.

1. Getting an image from a database? You mean that you are getting the
path of the image in the file system, right?

Side note: You could place the image inside the database using a BLOB and
do away with the path all together. That has the benefit of being
portable -- you simply move the database to where ever you want it. The downside is that the database becomes very large, but no more so that the
file system. There are pro's and con's in storing actual images in a

2. Using a GET is not the way to get the path. Instead, you have to
retrieve the path from the database table where the path is stored --
and that requires a MySQL query similar to "SELECT * FROM <database> WHERE id=<whatever>". There are lot's of examples of how to pull data from a

3. After getting the path, then you can create the watermark like so:


Hope this helps,




Thank you for your reply.

I was under the impression that the image is stored in a folder called
images, in fact the images file do go in, however I have the DB set up for longblob, averaging about 20kb each, so now I am unsure. I exported the sql
so perhaps you can tell me.

Table structure for table `images`

 `image_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `caption` varchar(50) NOT NULL,
 `wheretaken` varchar(100) NOT NULL,
 `description` text NOT NULL,
 `file_name` varchar(25) NOT NULL,
 `image_file` longblob NOT NULL,
 PRIMARY KEY (`image_id`)

When I call the images, which works fine, I do need to specify the path that
leads to the images folder. Am I being redundant in this structure.

This is the script that I use to call the images. I have pulled out some of
the html that styles the data.

<?php if ($totalRows_WADAimages > 0) { // Show if recordset not empty ?>
         <?php echo $row_WADAimages["caption"]; ?>
 src="images/<?php echo $row_WADAimages["image_file"]; ?>" <?php echo
$row_WADAimages["description"]; ?>"

<?php echo $row_WADAimages["where_taken"]; ?>
       <?php echo $row_WADAimages["description"]; ?>

Thank you for your help.


is this the imageDetail.php script?

From what it appears in the code, `image_file` is holding the file name rather than the actual image. Yet you have `image_file` defined as a longblob, which would make sense if you were storing the actual image data in the data base rather than on the file system. As Ashley noted, you can do it either way. I notice you also have a field `file_name` -- what is this used for? It sounds like your design is a bit off -- neither one way or the other. The php shown doesn't look complete enough, though -- where is the img tag and such? Also, going in and out of php on each line is kind of a waste and looks sloppy. If i read that code right, it would emit something like this:

        caption text
src="images/pathtoimagefile" description text

where taken text
        description text

Look at the html that's emitted from the script and see if that's what you get.

Can you post or pastebin more of the .php script so I can see more of what is going on?

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to