How can I Retrieve thumbnail from a database..?

amit

Hi
I want to make a gallery for that I am storing .jpg files in a folder and name in database
And retrieving but I want to show in a thumbnail form so that people can see only thumbnail in first time when it after clicking bigger photo. Can you help me?
This is my code - below. Which are retrieving images form database and showing.

<?php
include("config.php");
$photo_show="select image_id_1,image_name_1 from multimedia_table1 ORDER BY image_id_1";
$photo_show1=mysql_query($photo_show);

print("<table width=400 cellpadding=2 cellspacing=0 border=0>");

$numcols=3;

$cols=0;

while ($row = mysql_fetch_array($photo_show1)) {
if ($cols==0)
print("<tr>");

print ("<td><a href=\"image_from_db_full_photo.php?image=$row[image_id_1]\"><img src=\"upload/$row[image_name_1]\" border=\"0\"></a><br>&nbsp;</td>");

$cols++ ; //increment

if ($cols==$numcols) {     
    $cols=0; // reset it because we've finished the row 
    print ("</tr>"); 
}

}
print("</table>");

Weedpacket

It's generally better to generate the thumbnail once when the image is first uploaded, not every single time it's requested.

Either way, the general approach would be to use [man]imagecopyresized[/man] or [man]imagecopyresampled[/man] to generate the thumbnail. Getting the image resource to resize it in the first place generally involves reading it in from a file; I'm not as sure about doing it from a blob as I generally don't use a database to store binaries anyway, just file paths, as all it does is add another layer of complication to the task of "storing a file".