| |
|
| |
This website is designed to be a movie info repository where users can search movies by title, name of the actors or name of the director. You can cross reference the movie and the filmography of the actor or the director. You can add rating or comments on the films. The website also provides a list of all-time top 10 movies based on average of users' ratings. (Only small amount of data are actually stored in database for demonstration.) |
| | |
| | |
| |
|
| |
 |
| |
The client from browser sends to web server a form consisting of search string. By using Perl CGI and DBI modules, web server handles the requests from clients, and then access the database to retrieve/update the data being searched/updated. Then the query results are sent back to the client and presented in html file. |
| | |
| | |
| |
|
| |
 |
| |
Entity-Relationship Diagram for database design |
| | |
| | |
| | |
| |
 |
| |
Database Table Schema |
| | |
| | |
| |
|
| |
 |
| |
Search movie by title, by director's name or by actor's name. |
| | |
| | |
| |
 |
| |
Search results are listed, either exact match or partial match with the search string. |
| | |
| | |
| |
 |
| |
Movie info are presented with cross reference links underscored. |
| | |
| | |
| |
 |
| |
Actor's or director's filmography will be listed chronologically if his/her name is being referenced or searched. |
| | |
| | |
| |
 |
| |
User can add rating for the specific movie on the scale of 0 to 10. |
| | |
| | |
| |
 |
| |
User can make a comment on the specific movie. |
| | |
| | |
| |
 |
| |
All-time top 10 movies based on average users' ratings will be listed by click the link on the menu. |
Link to the website Movie Database