PHP GD library

vyruz

Below is part of my codes...
if ($_POST['submit']) {

// connect to the database
include("db.php");

$fileNameTemp = $FILES['form_data']['tmp_name'];
$fileName = $FILES['form_data']['name'];
$fileSize = $FILES['form_data']['size'];
$fileType = $FILES['form_data']['type'];

$new_data = @fopen($fileNameTemp, "r");
$data = fread($new_data, filesize($fileNameTemp));
$src_img = ImageCreateFromString($data);

// error, image is not a valid jpg
if (!$src_img) {
die ("Sorry.It was not possible to read photo $fileName. Choose another photo in JPG format.");
}

$new_h=150;
$new_w=150;

$old_x=imageSX($src_img);
$old_y=imageSY($src_img);

if ($old_x > $old_y) {
$thumb_w=$new_w;
$thumb_h=$old_y($new_h/$old_x);
}
if ($old_x < $old_y) {
$thumb_w=$old_x($new_w/$old_y);
$thumb_h=$new_h;
}
if ($old_x == $old_y) {
$thumb_w=$new_w;
$thumb_h=$new_h;
}
if (function_exists('ImageCreate')) {
$dst_img=ImageCreate($thumb_w,$thumb_h);
imagecopyresized($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);
}

$binaryThumbnail = addslashes($dst_img);

$result=mysql_query("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) VALUES ('{$_POST['form_description']}','$binaryThumbnail','$fileName','$fileSize','$fileType')");

$id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";

mysql_close();

}

I save the data as BLOB datatype
no matter what i save, it goes to 14Bytes of data (error occur; CreateImageFromString i guess). How come? im using the latest snapsnot of PHP 4.3.2...still to no avail...

tsinka

Windows or Unix/Linux ?

On Windows you must use "rb" instead of "r" with fread.

Additionally you might try mysql_escape_string or mysql_real_escape_string instead of addslashes.

Thomas

vyruz

Windows, and i tried with rb, still the same, tried with mysql_escape_string....still the same....all data store in the BLOB field is 14Bytes. =( (not actual result that i want)

tsinka

Hi,

maybe a missing fclose, try to put

fclose($new_data);

after

$data = fread($new_data, filesize($fileNameTemp));

Which error do you get ?

vyruz

tried that too....the script run with no error..the whole script actually took the image that i upload, resize it to smaller size (with ratio control of height and width) and save it into mysql database. But when i open and try to view the image, it always cannot display. Checked mysql, the BLOB data field always is 14bytes no matter wat pix i upload. =(

vyruz

harlo? help please...really dried out...=(

agoe

shouldn't you move the file from the tmp-dir with move_uploaded_file or copy - and store it with the actual filename, not the tmp_name - before you start resizing it?

vyruz

because i wan to store the uploaded picture to database as BLOB datatype...so i use imagecreatefromstring to read the binary from the temp_name....

Weedpacket

If it's always 14 bytes, what 14 bytes are they? Is it an error message that's getting saved instead of image data?

tsinka

Ok,

the problem is not MySQL, the problem must be somewhere in the code, I'm searching ...

tsinka

Here is the solution:

You're storing the resource (14 bytes long) in the database.

In order to get the image data you can replace the addslashes code by:

ob_start();
Imagejpeg($dst_img);
$binaryThumbnail = ob_get_contents();
ob_end_clean();

$binaryThumbnail = mysql_escape_string($binaryThumbnail);

That should work. I couldn't test the MySQL stuff but it should work since I was able to display the image correctly with a

header("Content-Type: image/jpeg");

without using the buffer functions. By using the buffer functions you can fetch the image data into $binaryThumbnail.

Thomas

vyruz

yahoooo...finally got it work with that portion of code from tsinka. Thanks alot...appreciated alot man....thanz to others for giving suggestion too..=)😃

tsinka

To be honest and to give credits to the right people I must say that I took the code from one of the user comments in the php manual 🙂

Thomas

vyruz

its ok...actually i tried with that code too....but than i dunno y the other time it does not work...maybe im using IIS the other time. now im at home running apache...=)