Your own private movie database
![[Screenshot]](moviedb.png)
This was written for private use, so it is tailored to the needs of the original client. The way it works, and the features it has will almost certainly not receive any major changes. Do not expect modifications to be made on request. However, it does what it does very well, and would be suitable for many people to use for managing private (and very private) video/DVD/movie collections. It is not designed for publically listing them.
System requirements
- Apache 1+.
- PHP 4+.
- MySQL 5+ (wrapper script may in theory be translated to extend support to other compatible [non-MS] SQL databases).
- Any operating system that can run those.
- A browser that supports HTTP authentication or cookies, and does not suck. By that, I mean that if you fill in a form on a Web page, and submit it, you should then be able to go back and see the form, with all of your changes still in it. With a default setup, this means:
- Opera, Mozilla/Firefox, IE 7+, Safari/Chrome/OmniWeb 4.5+, iCab 3+, NetFront 3+, Lynx, and Links/ELinks all work.
- Konqueror occasionally has trouble maintaining its cache correctly, but otherwise works well.
- iCab 2, and ICEbrowser have some minor styling problems.
- Netscape 4, OmniWeb 4.2, and MSNTV/WebTV have enough styling problems to make them unusable, although they would work without a stylesheet.
- IE 5 has some styling problems. IE 4 cannot work with the default stylesheet. IE 4-6 cannot add actors to movies.
- Escape and Tkhtml Hv3 do not work well enough because they do not maintain their history correctly (Tkhtml Hv3 also does not work with HTTP authentication).
- Clue browser has problems with its own existence.
User requirements
This system does not use an automated installer, so you must not be afraid to get your hands dirty, and set things up for yourself.
- Familiarity with configuring Apache and .htaccess files needed.
- Although you do not need to be fluent in PHP, you will need to be comfortable with editing settings within a PHP file.
- Some familiarity with MySQL preferred.
- Minimal HTML knowledge (typically just "
<p>foo</p>") for adding details of movies/actors. - Any changes that you want to have made to this system will need to be done by you (without my assistance). I will not do them for you. You will need to be fluent in PHP and MySQL.
System features
- Allows private movie/video collections to be managed.
- Movies can be categorised, listed by actor, director or production studio.
- Movies and actors can be rated according to personal tastes, and listed by rating.
- Inbuilt search engine.
- Style/theme, templates, and settings can be customised.
- Style/theme can be different when viewed by an authenticated user.
- Accessible even to text based browsers.
- No JavaScript is used. At all. Anywhere.
Administration features
- Single administration user.
- Optional password protected system using either HTTP authentication or cookies.
- Tested for immunity against XSS attacks.
- Advanced protection against XSRF attacks.
Instructions
Download the zip package. See the readme.txt file in the zip package for further instructions.
To download the script(s), and see the script license, use the links on the navigation panel at the top of this page.