Web based image database

[PilotPete]

I have a website with some 50,000 images on it that I currently use frontpage galleries to display with a thumbnail, a typical page is http://www.amatas.com/collections/BF...avariBFW06.htm . With the galleries it is very cumbersome and I want to install a database not knowing anything to start with.

In particular I want to retain the thumbnails but using a frames page to display the large images next to it. I have mySQL on my server and also have it installed on my home computer but not sure how to access it nor create the database.

I work generally with frontpage to create html sites and generally understand how it works.

Can anyone advise what is the best way to go about

1. creating the database to use on MySQL
2. Creating the linklages from a web page to the database that shows both the collection as thumbnails and separate larger pictures
3. Storing the images either in common image folder with specific name details or do I do that into a database somehow?
3. Putting it all together so it will function on my website.

[ledelboy]

Take a look at Gallery http://gallery.menalto.com/ It is Open Source and works wonderfully. Easier and more flexible than hand coding. Good luck

[jawn_tech]

I've looked at gallery before and agree it's a great resource. Worth a look.

As for the do it yourself approach, you could keep your images and thumbs in their respective folders, and sure you could create a table in MySql (using something like phpMyAdmin, if your host has it?). The table could just have a few fields in each record that contain links to the images, thumbs, maybe a unique record ID#, description, etc.

The catch is, the pages that use the database would need to be in a server-side format such as php or asp, because you'll need to use some server-side language in your code to access them.

So either way, some url's are going to have to change. Which brings up the next step, using a 301 redirect to the new urls -- and there are threads here that give instructions on that as well.

:)

[martyn-it]

The catch is, the pages that use the database would need to be in a server-side format such as php or asp, because you'll need to use some server-side language in your code to access them

This is the important bit - you will need serverside for it to work

But I think you need to step back a bit and work out what you want - I've writtern code to do this

Explorer Scout Activities

I have multiple tables in a database
One table is details on a particular event
(Unquie ID, event title, dates and descriptive text)

Another table is for Photos
(Photo filename, photo title, the scout sections the photo contains)

I can then throw the information back in numerous ways
eg photos of Scouts or photos of cubs ...

My photos are all in 2 directories one called photos the other called thumbs.

The nice thing about holding the information in a database is you is you can start throwing the information back on other pages Not just the gallery

eg
Explorer Scout Activity Page the picture and the events come from the db I add new stuff the page gets updated


Martyn

[AjiNIMC]

You can also try http://www.4homepages.de/ , I like it and it is very nice.

Here is a demo stuff http://www.idealwebtools.com/nimc/gallery/

[usmanz]

There are various other open source scripts for image galleries written in PHP. You could save the effort of writing your own code with database and put that effort into customizing an open source script.

[jordanmcclements]

NB - if using PHP in your pages you do not need to redirect or rename the original .html files.

see

www.webproworld.com/viewtopic.php?t=66668&start=25

Although this is a little bit involved if you are used to using frontpage...

[cyberkid]

If it is the Microsoft Front Page program you are referring to then try its replacement, Expressions.

http://www.microsoft.com/products/ex...n/default.mspx

You should be able to reverse publish the FP site into Expressions. But, there is a new way of creating a page layout that is applied to all the pages as you have now, only this will allow for a transition to a database driven web site.

[PilotPete]

For the moment I am trying out a program called phpMySite that provides a database recall for photos. I am playing with the layout at the moment www.amatas.com/album but once I get started I need to batch add photos to the database say 100 at a time. The phpMySite allows one pic at a time so I am looking for a way around that to load the database separately if necessary. I have asked the MySite guys if they can provide me with a program fix as it is still developmental.

Any ideas on how to send the images to the database otherwise or some code I can add to the program I have to take groups of pics?

I like the idea of a php site as I only need to change the template once and the whole website can change. With FP, even using side servers, I find that they do not update and the page format is more difficult to alter all of them. I now have something like 1000 pages.

p.s.

Just had another look at the Gallery website and program and as I get to understand more of what I want it looks to have some of what I am after so will give it a try.