Hi guys,

this is quite advanced stuff, but i thought i might give you guys a taste of what can be achieved with XML and Javascript. Included are some HTM files and one XML file and one excel file (XLS).

the starting point was the excel file, containing all the movie data. The columns are explained below:

Case: I have many cases of movies, this indicates which one the movie is in.
Media ID: Each CD/DVD can have more than one movie, this indicates which CD/DVD the movie is located on.
Movie: The movie name
Media: type of media (CD/DVD)
Size: because a CD/DVD can contain more than one movie, this indicates the relative size of the movie on the disc
Type: type of movie (i.e. C = Copy or P = Proper)
Year: year of release
Running Time: length of movie
Genre: genre(s) the movie can be categorised into
Tagline: movie tagline
Plot Outline: Basic story outline
Plot Synopsis: Full outline
Comments: Any other comments
Image Name: Name of image (used to display movie image on movie details page)

After doing this, i entered my movies into this 'database'.
After completing this, the next step was to complete the other columns (plot outline, running time, year, genre, etc.).
As you can see, this is far from complete. i only collected information on some movies, so i could test the code.

After doing this, i had to convert the excel file into an XML file. this was done by just saving the file as an xml spreadsheet through excel.

After doing so, i had to get a text editor, open up the xml file, remove the extra information from the xml file, slimming it down and into a format i could use. (you can save the excel file as an xml spreadsheet and compare it with my file).

This is just for instructional purposes and is far from complete...

However, i am currently working on a database version of this in access 2003. it uses javascript and ADO, the final ouput is virtually the same - but with more features, better layout, etc. Hopefully, if i finish this (), i should have it uploaded soon!!!

anyway, enough from me, here's the file!!! Have fun!!!

USES:
CSS: Yes
JS: Yes
HTM: Yes
XML: Yes
Browser Requirements: MS IE 6+ ONLY (7+ recommended)

Attached Files

XML Version.zip (274.3 KB, 19 views)

“We don't inherit the earth from our ancestors, we borrow it from our children.”