I have searched EVERYWHERE for the past week and have had no luck.
Currently I have a photo gallery on my aquarium fish website (fishindex.com). It has well over 2,200+ photos and is still going strong. I have created a SHTML page for each of these files by hand. This has been quite time consuming and I know there has to be a better way. I was hoping I could create a MySQL/PHP database with the following features:
1. Create multiple categories/sub-categories for the photos
2. Under each category I want a list of links to all of the photos. On this list I want the names to be sorted by common name of the fish. Also, I DONT want thumb nails.
3. On each page with the photo I want it to have a URL or email address link. Because the authors have asked that I place a link under each photo. Also, I would like the common name and scientific name of the fish under each photo. If possible I would like a little area where I can make comments.
4. Customizable headers and footers for each page.
I know that I am really asking for a lot. I hope that there is a script already out there that could do this for me.
I don't know anything about sql or anything related to it. I do know that my server supports both MySQL and PHP.
If you can help me in ANY way I would be very happy. Even a link or just aim me in some direction to help me organize this photo gallery.
I think you're really going to enjoy my series of articles on PHP/MySQL that will be appearing on SitePoint in coming weeks. The example I'll be working with will actually be exactly what you're after!
I was checking my referrals for ImageFolio.com and noticed a lot of hits from this URL so I decided to visit the site.
I am the developer of ImageFolio which is a perfect solution for a portfolio or a 2,000 image gallery. ImageFolio can support up to 100,000 images, movies, and photos without the need for MySQL, although a MySQL version is coming soon.
If you have any questions about the product I'll be happy to help.
CTO, BizDesign, Inc.
I can tell you how I would do this:
- Enter all information except the images in an Access (or so) database. Make a categories table and a a table with image/fish information including author, link and image filename.
- Download phpMyAdmin (http://phpwizard.net/phpMyAdmin/). With this program you can easily create and maintain MySQL tables.
- Create the MySQL tables, export your access database to ASCII and upload these ASCII tables to your MySQL database.
- Write a PHP script to search the MySQL tables in any way you like (for good examples see: http://www.weberdev.com/). With PHP you can easily customize your headers and footers