Description
You are given three tables of information: movies, actors, genres
You are also given two tables of linking information: movieActors, movieGenres
See the table at right for details on the table structure
The movie table contains all the descriptive information regarding the movies
The actors and genres tables simply contain names and associated IDs
The movieActors linking table contains information that links movies with actors
The movieGenres linking table contains information that links movies with genres
All of your work will be stored in the examDay folder
/var/www/html/students/studentFolder/XXXXXX/examDay/
Remember, you can access your page via the url:
dev.emmell.org/students/USERNAME/XXXXXX/examday
Your work will consist of creating two files: movies.php and actors.php
An appropriate database.php will already be found there
You cannot edit the database; nothing you do will impact anyone else's work
NOTE: The CSS has been obfuscated (made hard to read) - do not simply copy it.
You will need to determine the correct CSS styling as necessary
Take a good look at the linked page to make sure you are reproducing its functionality correctly.
Specifications broken down by level:
As always, the raw level of your mark is determined via functionality as defined below.
Code commenting, formatting, variable/function naming and efficiency determines +/-
Level 1
- actors.php displays all actors in some fashion
- movies.php displays all actors in some fashion
- The pages are connected via a common header: "MOVIES - ACTORS" as shown
Level 2
- All requirements from Level 1
- Actors and Movies are now displayed in columns as demonstrated in example
- Both actors and movies are now links like actors.php?id=42
Level 3
- All requirements from Level 2
- Specific actors/movies (when ID was passed) now display information for that actor/movie in some fashion
- When on a specific actor or movie page, a link to BACK TO LIST appears and functions as demonstrated in example
Level 4
- All requirements from Level 3
- Specific movie pages now also list which genres apply to the movie.
- Specific movie pages now also list which actors appear in that movie.
- These listed actors should be links to specific actor pages
- Specific actor pages now also list which movies that actor appears in
- These listed movies should be links to specific movie pages
- Information should be displayed and formatted as demonstrated in example
|
Database Information
+----------------+
| Tables |
+----------------+
| actors |
| genres |
| movieActors |
| movieGenres |
| movies |
+----------------+
describe movies;
+--------------+---------------+
| Field | Type |
+--------------+---------------+
| mov_id | int |
| mov_title | varchar(256) |
| mov_desc | varchar(1024) |
| mov_director | varchar(128) |
| mov_year | int |
| mov_runtime | int |
| mov_rating | float |
| mov_votes | int |
| mov_revenue | float |
+--------------+---------------+
describe actors;
+----------+--------------+
| Field | Type |
+----------+--------------+
| act_id | int |
| act_name | varchar(256) |
+----------+--------------+
describe genres;
+------------+--------------+
| Field | Type |
+------------+--------------+
| genre_id | int |
| genre_name | varchar(128) |
+------------+--------------+
describe movieActors;
+---------------+------+
| Field | Type |
+---------------+------+
| movAct_id | int |
| movAct_mov_id | int |
| movAct_act_id | int |
+---------------+------+
describe movieGenres;
+-----------------+------+
| Field | Type |
+-----------------+------+
| movGen_id | int |
| movGen_mov_id | int |
| movGen_genre_id | int |
+-----------------+------+
|