SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Member
    Join Date
    May 2000
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

    Regards,

    Kevin
    FishIndex.com


  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 1999
    Posts
    60
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check out the following cgi script, I think it's just what you are fishing for.....
    http://www.imagefolio.com

  3. #3
    Freelance Web Designer KeithMcL's Avatar
    Join Date
    Oct 1999
    Location
    Dublin, Ireland
    Posts
    1,125
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm setting up a webmasterswork site and was wondering if that script would look good for a portfolio section for webmasters?

    What ye all think?

    Regards,


    ------------------
    Soon to come,
    webmasterswork.com

  4. #4
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Fishman,

    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!


    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!

  5. #5
    SitePoint Member
    Join Date
    May 2000
    Location
    Dallas, TX, USA
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Keith/Kevin(s),

    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.

    - Greg


    ------------------
    Greg Raaum
    CTO, BizDesign, Inc.
    http://www.bizdesign.com
    gregraaum@bizdesign.com

  6. #6
    SitePoint Enthusiast
    Join Date
    Jul 1999
    Posts
    62
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

    Hope this helps

    Misja




    ------------------
    Filmbug Movie Search Engine
    http://www.filmbug.com/

  7. #7
    SitePoint Guru prequel's Avatar
    Join Date
    Nov 1999
    Location
    Brisbane, Australia
    Posts
    682
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hehe hi ya Greg

    I purchased Greg's Imagefolio Basic 2.1 a few weeks back and am loving it..

    using in on my new site http://thedesktopthemes.com/wallpaper/ and so far uploaded around 900 wallpapers and images and everything is fine, although it's my server that is slower

    I'd purchase the pro version later if i can only decide which dedicated hosting company to go with ...

    oh Greg i go under the username 'eva2000.com' or eva2000 on the imagefolio forums

    ------------------
    Evangelion in the 21st century
    Eva2000.com
    Australian Star Wars Prequels
    ThePrequels.net
    Anime2001 Network
    Anime2001.com
    Coming soon... the next step
    TheDesktopThemes.com Wallpapers

    [This message has been edited by prequel (edited May 09, 2000).]

  8. #8
    SitePoint Member
    Join Date
    May 2000
    Location
    Dallas, TX, USA
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey George,

    I'm happy to see that you are enjoying ImageFolio. What are you looking for in a dedicated hosting provider? Perhaps I can help.

    - Greg



    ------------------
    Greg Raaum
    CTO, BizDesign, Inc.
    http://www.bizdesign.com
    gregraaum@bizdesign.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •