Image handling script needed using mysql and PHP for 300 points!
Posted on 2002-03-25
I need some help please.
I have just bought a digital camera and want to get all my photos into a mysql database and then get them out again using php based on keywords.
I don't have Imagemagick as it won't install but I do have GD and what I want to do is have a search function based on keywords such as "vacation", "car" or "2002" etc... where the images can be inserted into mysql with these keywords associated..
When searched it generates a page of results in a table (3 cells by 3 cells) a random nine images (resized using GD which have the keyword associated) and which link to a new web page containing the full size image. If the page is refreshed I want it to show another different set of nine so I can just load lots in and let my friends and family go play...
I am trying to learn this stuff but this one is beyond me - I have already built the database and have tried all kinds of stuff that didn't work and now I am stuck!
If anyone can do this script for me with some comments so I can understand how it does it then I am happy to give some big points!