Re: [PHP] Watermark with GD

[Tamara Temple]

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

"tedd" <tedd.sperl...@gmail.com> wrote in message
news:p06240800c8f1d19b9...@[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?



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