Virtual Museum

[malum]

Hi

Have just discovered your EE and it looks great.

It seems to be the closest I can get to what I want which is a dynamic virtual museum. Each Exhibtion will be a group of exhibits with information about each one and a link to a static page with more information and further views of the piece.
Obviously I will need to modify the database a bit (as camera information, shutter speed etc will need to be replaced with artist information, time period, type of material the piece is made of etc.

I have no experience of MYSQL or PHP but I'll let you know how I get on (I might be a while lol)

Any tips gratefully received.

[Pekka]

Hi malum,

Easiest way to convert it to that is to use the

- photographer as artist name
- photo header for item name
- text field (photo description) as html code which describes the item.
camera description and details as text fields for describing the artist and the era.
- any varchar field for time period representation.
etc. etc.

So my rules for adaptation would be:

a) use the existing database fields with correct data types and their semantics (i.e. photo page contains data which is now presented in EE, and not e.g. feedback text data), just have them represent the new data externally (people don't see the table and field names)

b) alter photo page and do a new list ouput, new search field names to suit your needs.

This would change EE to a museum browser with least effort. You really don't want to do it complicately (i.e. add new fields to database and so on) because this way you would not need to write new queries and array handling and display code. And it would be easier to adapt this layout into later versions of EE if needed. Write down all the changes step by step.

But please retain EE copyright somewhere visible also after modifications. :)

I have no experience of MYSQL or PHP but I'll let you know how I get on (I might be a while lol)


:) I learned it all in one year. Last few months I've been coding a few hours a day or more.

[malum]

Thanks, these are pretty much the conclusions I came to having had a closer look at it.

I will of course keep an EE copyright on the page.

Have you considered having EE auto size one large image into all the various sizes needed on the fly?

Just a thought.

Trouble with having someone who makes something as good as EE is that it takes away the incentive for me to learn php, at least that's my excuse and I'm sticking to it.

[malum]

Small question which file do I change to alter the language encoding of the photo display page?

I tried photo.php but it still displays in Western Europen (Windows)

I added this to the top under