I'm writing a tool to take a mysql database and then display it on the web.
I quite like designing and writing languages so it doesn't bother me too much if such a tool already exists.
My problem is when displaying a front page showing a selection of images from items in the database - it's just too slow if it's pulling images from various external sites via a url.
I figured why not have a button that will take the existing image URL and then resize it (make it smaller), try to make the background transparent and then store the image file locally.
I can do most of this (the transparency thing is a bit hit and miss) but I'm not sure where to store the images so I can display them later.
I can store them in /var/tmp/app_name/images/ but then I can't display it.
I'm probably just being stupid but is there a proper way of doing this?
Also, I'm using GD for the images but I seem to have to use 3 different methods depending on whether the image is a png, gif or jpg - is there a single method that might work?
Many thanks for your time
Mike
PS here's an example database on chromebooks.