Resize Image Coming From MYSQL DB

WanamakerMedia

My current coding pulls a stored image from a MYSQL DB and displays it:

$link = mysql_connect("localhost", "model_admin", "model"); mysql_select_db ("model_applications");
$id = $GET[id];
$img = $GET[img];

$result = mysql_query("SELECT file FROM photos WHERE id=$id", $link);
$i = "0";
while($i<$img){
$row = mysql_fetch_array($result);
{ 
$data = $row['file']; 
$type = $row['type']; 
} 
$i++;
}
if ($type=="pjpeg") $type = "jpeg"; 
Header( "Content-type: $type"); 

echo $data;

I need to know how to take that $data and resize it to a certain width and height before it is output to the browser. Any ideas?

Komodo

echo "imagesx($data)"; <--will output the the height of the image
echo "imagesy($data)"; <--will output the the width of the image

something like this might help:

echo "<img src=\"$data\" width=\"150\" height=\"150\" />";

WanamakerMedia

That wont physically resize the output image though ... will it?

MikeSnead

Nope. That'll just smash the full res image to fit a smaller box. Lemme fail my exam and I'll come back and try to figure it out 🙂

bodzan

...other than that way
Komodo explained...

The thing is that it really isn't that big a deal since once you retreive that picture (it's a BLOB field, isn't it?) from a database it is in a memory and no matter what you do - it will still be the same one (same size and same amount of kb's in the memory)...

If you want to have smaller picture you'll have to resample it BEFORE it gets saved into the database...

WanamakerMedia

So you cant resample the output in any way?

bodzan

...I'm just saying that regarding your application speed and execution time it won't mater anyhow...

Why do you want to do it, anyways?

WanamakerMedia

We are currently storing the full size image in the DB, but I want to be able to output a thumbnail on the fly for an index page

bodzan

...making thumbnail before inserting anything in a database and storing both the full size image and the thumbnail...
That way you'll save yourself a lot of traffic between your database and your application...

WanamakerMedia

True ... that is one possibility. Is there an easy way to create thumbs for all of the images already in there?

bodzan

...how one might go to do something like that...

I figure one might consider getting a real sized pic from database then resampling it and then making a thumb and saving it to a new created field in the database table...

I'm not sure whether it is possible at all, but one might want to do it that way...