[RESOLVED] Blob Image resizing and displaying

mrbill501

Hi
I'm really new to php and am trying to make an online gallery at the moment and I'm struggling a hell of a lot.
I'm storing the images in a Blob at the moment as it was the only way I could make it work at the time and dont have time to fix this now and I cant seem to get them back out again. Does anyone have any ideas on this?
The idea is that two copies of the image will be stored at different sizes in different tables(one as a thumbnail and one normal size).
I know its a FAQ and I know that using Blobs is frowned upon but I dont have the time to change it now and I just cant find the help I seem to need.
My code for the two insert statements is:

$sql = "INSERT INTO tbl_images
( image_type ,image, image_size, image_name, log_name, gallery_id)
VALUES
('{$size['mime']}', '{$imgData}', '{$size[3]}', '{$FILES['pix']['name']}', '{$SESSION['logname']}', '{$_POST['gallery']}')";
$result = mysql_query($sql) or die(mysql_error());

$last_id = mysql_insert_id();
$query = "SELECT * FROM tbl_images WHERE image_id = $last_id";
$result = mysql_query($query) or die('Error with query.');
while ($row = mysql_fetch_array($result)){
extract ($row);
echo "$image_id";
}

$sql2 = "INSERT INTO tbl_thumb
(thumb_id, thumb_type ,thumb, thumb_size, log_name, gallery_id)
VALUES
( '{$image_id}' ,'{$size['mime']}', '{$imgData}', '{$size[3]}', '{$SESSION['logname']}', '{$POST['gallery']}')";
$result = mysql_query($sql2) or die(mysql_error());

At the moment the two images are the same size as I cant work out the resizing.
Any help would be fantastic.
Andy

n_wattam

physical resizing is done by using binary packs installed with php on your server, like imagemagick etc, these then offer more commands and functions for you to use in php..

GD and Net PBM are others..

mrbill501

Ah, my server doesnt have Imagemagick which is annoying as it seems like the easier one to use. How do I go about using GD with a BLOB image?

n_wattam

GD should be enough to be fair... ImageMagick is just a lot more powerfull when it comes to resizing images etc, last i used it.

This should get you started Click Here

all the functions run down the left..

mrbill501

Thanks man, this has been bugging me for days.

n_wattam

no problem, theres always good example code, people submit on that size... best way i find is find code which does more or less you like then break it down to see how they have done it. Then rebuild your own.

mrbill501

Back again. I've had a crack at it but the image is still going into the database at the same size? any ideas where I'm going wrong?
Thanks

$thumbsize=120;
$imgfile = ($_FILES['pix']['tmp_name']);
header('Content-type: image/jpeg');
list($width, $height) = getimagesize($imgfile);
$imgratio=$width/$height;
if ($imgratio>1){
$newwidth = $thumbsize;
$newheight = $thumbsize/$imgratio;}
else{
$newheight = $thumbsize;
$newwidth = $thumbsize*$imgratio;}
$thumb = ImageCreateTrueColor($newwidth,$newheight);
$source = imagecreatefromjpeg($imgfile);
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
imagejpeg($thumb,100);
$tnimgData =addslashes($thumb);
$tnsize = getimagesize($thumb);