how to generate image thumbnail in html from mysql database

[spotonukraj]

Hi

I uploaded the image & form data to mysql database, i can retrive text data from database to html as well.  but now i m stuck with image part. please help me if any 1 knows or having php code for that to generate image thumnail from mysql database to html page.

i created two database 1 for text data , another 1 for photos, give me some idea how can i combine both data together in one html page. like example ID CARD : PHOTO, NAME, GENDER, PROFESSION, NATIONALITY, ECT.

THANKS IN ADVANCE   

[GrandSchtroumpf]

You can use GD to create your thumbnail.  The thumbnail is usually created when the image is uploaded, not to have to create the image for each request.  This means you should have both full-size and thumbnail versions in your database.

[VGR]

agree. What I would recommend :
- do not use BLOBs to store the big image
- only store the full file path to the image
- optionally you may store binary (BLOB, LBLOB etc) the thumbnail
- today, file system access is not slower than DB access, it's perhap even faster.
- this will ease DB recovery and backup (smaller footprint)
- this will enable you to edit images manually, compared to updating a BLOB...

[rdivilbiss]

agree. What I would recommend :
- do not use BLOBs to store the big image
- only store the full file path to the image
- optionally you may store binary (BLOB, LBLOB etc) the thumbnail
- today, file system access is not slower than DB access, it's perhap even faster.
- this will ease DB recovery and backup (smaller footprint)
- this will enable you to edit images manually, compared to updating a BLOB...

I agree with all VGR says.  Using the file system will be much simpler, quicker, and easier to maintain. "KISS" principal.