Re: Watermark with GD

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

"tedd" <tedd.sperling@gmail.com> wrote in message news:p06240800c8f1d19b992f@[192.168.1.2]...

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 file). 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 ['images/$row_WADAimages["image_id"]]. Can anyone shed some light on this for me. Thank you Gary

Gary: 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 database. 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 database. 3. After getting the path, then you can create the watermark like so: http://webbytedd.com/b/watermark/ Hope this helps, tedd --------- http://sperling.com/

tedd 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 -- CREATE TABLE IF NOT EXISTS 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, submitted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (image_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1447 ; 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. Gary

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?