Problem with thumbnail images

[senthil]

Hi,

I tried this sample program for creating thumbnails and storing in a database. I'm able to retrieve the original image from the database and display it. But I'm not able to display the thumbnail. The temp.jpg, temporary thumbnail, has the correct thumbnail image. Also, some binary data is being stored in the database. Could anyone tell me what is the problem.

Thanks
Senthil

MYSQL_CONNECT("localhost","root","password");
mysql_select_db("binary_data");

$im = imagecreatefromjpeg($form_data);
$im_width=imageSX($im);
$im_height=imageSy($im);
$new_height=100;
$new_width=$im_width / ($im_height / $new_height);

$temp=imagecreate($new_width,$new_height);
imagecopyresized($temp,$im,0,0,0,0,$new_width,$new_height,$im_width,$im_height);
imagejpeg($temp,"temp.jpg");

$thumbnail = addslashes(fread(fopen("temp.jpg", "r"), filesize("temp.jpg")));
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$result=MYSQL_QUERY("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype,thumb_nail) ".
"VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type','$thumbnail')");

MYSQL_CLOSE();

[MeX]

hi senthil!

so ... it takes me some time ... but finally got it to work!!

MySQL TABLE STRUCTUR:
#----------------------------------------
CREATE TABLE pictures (
id int(10) unsigned NOT NULL auto_increment,
name varchar(30) NOT NULL default 'untitled',
type char(3) NOT NULL default 'jpg',
size_orig int(10) unsigned NOT NULL default '0',
data_orig text NOT NULL,
size_tn int(10) unsigned NOT NULL default '0',
data_tn text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) TYPE=MyISAM COMMENT='TEST:😛ICTURES';
#----------------------------------------

this code is executed AFTER SUBMITTING the file-upload-form!!

if (isset($_data_submit)) {
  $pos = strpos($_FILES['fileData'][name], '.');
  $name = substr($_FILES['fileData'][name], 0, $pos);
  $type = substr($_FILES['fileData'][name], $pos + 1);
  $size_orig = $_FILES['fileData'][size];

  move_uploaded_file($_FILES['fileData'][tmp_name], 'tmp.jpg');
  $fp = fopen('tmp.jpg', 'r');
  $data_orig = addslashes(fread($fp, filesize('tmp.jpg')));
  $fc = fclose($fp);

  $image = imagecreatefromjpeg('tmp.jpg');
  $image_width = imageSX($image);
  $image_height = imageSy($image);
  $image_height_new = 100;
  $image_width_new = $image_width / ($image_height /  image_height_new);

  $image_tn = imagecreate($image_width_new, $image_height_new);
  imagecopyresized($image_tn, $image, 0, 0, 0, 0,  $image_width_new, $image_height_new, $image_width, $image_height);
  imagejpeg($image_tn, 'tmp_tn.jpg');

  $fp = fopen('tmp_tn.jpg', 'r');
  $size_tn = filesize('tmp_tn.jpg');
  $data_tn = addslashes(fread($fp, filesize('tmp_tn.jpg')));
  $fc = fclose($fp);

  $query = "INSERT INTO pictures SET id = '', name = '$name', type = '$type', size_orig = '$size_orig', data_orig = '$data_orig', size_tn = '$size_tn', data_tn = '$data_tn'";
  $result = mysql_query($query, $conDB);
}

hope that helps!

ceeyaa.MeX

[MeX]

oh ... and to display a image:

$query = "SELECT * FROM pictures WHERE id = '$picture_id'";
$result = mysql_query($query, $conDB);
$data = mysql_fetch_array($result);
$filename = $data['name'] . '.' . $data['type'];
header("Content-Disposition: inline; filename=$filename");
// to display the ORIGINAL picture
//echo $data['data_orig'];

// to display the THUMBNAIL picture
echo $data['data_tn'];
exit();

but i think, it would be better to store the images in dirs!?

ceeyaa.MeX

[MeX]

but i think, it would be better to store the images in dirs!?

because you can't show more than 1 image per page!!
e.g. you can't make a thumbnail gallery!!!

header("Content-Disposition: inline; filename=$filename");
echo $data['data_orig'];
echo $data['data_tn'];
exit();

does just display the first picture!!