"tedd" <tedd.sperling@xxxxxxxxx> 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 __________ Information from ESET Smart Security, version of virus signature database 5576 (20101029) __________ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
