Hello All,
I'd really appreciate some help figuring out what's wrong with this
code. I can't seem to successfully save a MySQL JPG Image to a physical
jpg file (well atleast not a valid one)
The critical pieces of the code look like this:
// 1. Get Image from DB to String
$sql = "SELECT Image FROM Images WHERE ID='$ID'";
$res = dbi_query ( $sql );
if ( $res ) {
if($row = dbi_fetch_row( $res ))
dbi_free_result ( $res );
$Images = stripslashes($row[0]);
}
$File = "ReThumbnail.jpg";
// 2. Write string to File
$fd = fopen($File, "wb");
fputs($fd,$Images,strlen($Images));
fclose($fd);
// 3. Create Thumbnail
system("djpeg -pnm $File | pnmscale -xscale $xscale -yscale $yscale |
cjpeg > $File.tmb");
// 4. Read New Thumbnail into a new string
$fd = fopen( "$File.tmb", "rb");
$tmb = addslashes(fread($fd,filesize("$File.tmb")));
fclose($fd);
// 5. Update Database
$sql = "UPDATE Images SET Thumbnail='$tmb' WHERE ID=$ID";
if(dbi_query($sql)) {
echo "ReThumbnailing Successful";
exit;
}
The problem seems to be in step 2 from what I can figure.
I know that the Image file in the database is valid and outputs the
appropriate info to display the jpg.. However, the image that is saved
to the hard drive doesn't seem to be valid.
Nor can I run the system command from the command line on the server:
[mike@madras caravan2001]$ djpeg -pnm ReThumbnail.jpg | pnmscale -xscale
.1 -yscale .1 | cjpeg > ReThumbnail.jpg.tmb
Corrupt JPEG data: 67 extraneous bytes before marker 0xc2
Quantization table 0x01 was not defined
pnmscale: Command not found.
Empty input file
I'm not sure what those extra 67 bytes are about.. Is the Oxc2 marker
the beginning or the end? I couldn't figure this out either..
However, if step 2 isn't working, It's bungling up everything else...
I thought that this might be an issue of strlen balking over the binary
file. The documentation doesn't seem to think this would be a problem
(with binary files)
http://www.php.net/manual/en/function.strlen.php
I found an alternate resource here
http://www.php.net/manual/en/function.mysql-field-len.php
and attempted to incorporate it with
// Alternate way to determine strlen
$result = mysql_query($sql);
$ImageSize = mysql_field_len ($result, 0);
// $ImageSize = strlen($Images);
echo $ImageSize;
That didn't work either.. However I wqas able to get some more useful
information about the validity of strlen
DB Result
-rwxrwxrwx 1 mike www 17159 Nov 29 23:27 ReThumbnail.jpg
-rwxrwxrwx 1 mike www 0 Nov 29 23:27 ReThumbnail.jpg.tmb
16777215
Temp Thumb File: ReThumbnail.jpg.tmb
Thumbnail:
ReThumbnailing Successful
[mike@madras caravan2001]$ djpeg -pnm ReThumbnail.jpg | pnmscale -xscale
.1 -yscale .1 | cjpeg > ReThumbnail.jpg.tmb
Corrupt JPEG data: 67 extraneous bytes before marker 0xc2
Quantization table 0x01 was not defined
pnmscale: Command not found.
Empty input file
strlen Result
-rwxrwxrwx 1 mike www 17159 Nov 29 23:24 ReThumbnail.jpg
-rwxrwxrwx 1 mike www 0 Nov 29 23:24 ReThumbnail.jpg.tmb
17159
Temp Thumb File: ReThumbnail.jpg.tmb
Thumbnail:
ReThumbnailing Successful
[mike@madras caravan2001]$ djpeg -pnm ReThumbnail.jpg | pnmscale -xscale
.1 -yscale .1 | cjpeg > ReThumbnail.jpg.tmb
Corrupt JPEG data: 67 extraneous bytes before marker 0xc2
Quantization table 0x01 was not defined
pnmscale: Command not found.
Empty input file
Any suggestions would be appreciated..
Really, all I'm trying to do is take a MySQL jpg image and shring it 10%
and then save it again as another MySQL Image (a thumbnail)...
Mike
--
Mike Gifford, OpenConcept Consulting, http://www.openconcept.ca
Offering everything your organization needs for an effective web site.
New PHP/MySQL Photogallery & Great Pictures http://genevilleneuve.com
In all things it is better to hope than to despair.Wolfgang von Goethe
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
