PHP/mySQL photogallery. HELP?!

toddg

Hello:
I am looking to build a photogallery in php using mySQL as the backend. similar to this: http://phpbegginner.com/column/joel/photo

I would like a form input to submit information into the tables I am using.

I also want there to only be one gallery page and have everything pulled from the DB depending on the link you chose.

Then, in the navigation for my main site I want to have 5 links to diferent photo galleries. I would like this built dynamically based on the information in the DB. Ideally I would like the first two links to be the two most recent entries and then the remaining three links be random. If that is not possible then just the five most recent entries.

My table structures look like this.

Gallery:
UID | galleryName | URL | date | entryDate

Photos:
GUID | photoID | photoName | photoLocation | photoDescription

I only have a basic understanding of how to put this together and I could really use some help/mentoring. Everyone I work with is ASP and msSQL 2000 so they are NO help.

Thanks in advance!

Todd

surfside

I have recently created scripts for a similiar project. If you goto

www.gdaysport.com.au and view the new categories/full pictures, you may find these suitable.

If you do I will send the scripts to you in a private email zip attachement .

The scripts are of commercial value , however to help a fellow author , they are free to you.

Let me know.

regards surfside

rinjani

There are over 100 image gallery scripts available at hotscripts.com:

http://www.hotscripts.com/PHP/Scripts_and_Programs/Image_Galleries/

You could probably find one that does most of what you want without recreating the wheel (or script that is).

jordy

i used a bit differend approach on http://foto.querner.com/
All the photos are pulled from a folder on the webserver and resizes are made using GD-lib or ImageMagick (by altering the configurationfile its possible to switch).
The resized images are stored on the server also to keep the load on the server to a minimum.

Put and Pull graphics from a mysql db causes a lot of load on the server and some versions of MySQL crash if the db's are to huge (also depends on how mysql is compiled)

for script specific questions just mail me

toddg

Thanks for the info, I will check the site out and let you know.

As far as the images, I prefer to keep them separate as well. Only the metadata was to be stored in the mySQL db.

I'll also go look at the gallery pages and see if there is something there. I have a feeling I am different though <grin>

Thanks again.

Todd

cyronuts

jordy,

I've figured out how ( with the help of kind people on this forum) to post images from a db in the type of format you have on your foto.querner site...but how did you do the next/previous links at the bottom?