Hi,
hope you can help me. I am working with a database (mysql) already created, pictures were stored in a longblob field, but this is the only field related to pictures (so I have no info about their size).
I manage to extract and display the pictures - using a php file like this: poza.php
<?php
ob_start();
ob_clean();
include'conn.php';//connects to server and select db
if (IsSet($_GET['imgid'])){ //imgid is the id of the row
$img_id =$_GET['imgid'];
$query = "SELECT * FROM angajati_eurotire WHERE id_ae=$img_id";
$result = mysql_query($query);
header("content-type: image/jpeg");
while ($row = mysql_fetch_array($result))
{ print $row[poza]; } //poza is the column where images are stored
mysql_free_result($result);
}
ob_end_flush();
?>
Then I display the picture using <img src="poza.php?imgid=[ID]">.
This works ok, but I need to display this pictures as thumbnails (about 30% of their actual size). The pictures have random sizes.
Is there any way I can determine the image size?
Or maybe I'm going on a wrong track with all this?
Thanks for your time.
Ina