(Solved) : Movies Database Pages Elvis Home Kilroy Publichtml Webdev Projects Albus Folder Create Sub Q37183437 . . .
Movies Database Pages
On Elvis, in your/home/kilroy/public_html/webdev/Projects/albusfolder, create a subfolder named Movies.
Working from the files we made in class to add a movie, and tolist the people in a movie, and to add a person to a movie in arole, build the following pages.
NOTE: to save space, some files as worked on inclass did not include the HTML boilerplate elements needed to passvalidation. Your final files for this homework should be 100% validHTML.
- listmovies.php: all the titles of all the movies, inalphabetical order, with a form where a new title can be added. Thetitle of each movie should be a link toshowplayers.php,described below.
- addmovie.php: accept input from the form in listmovies.php, addthat movie to the table, and redirect back to the list ofmovies.
If the name of the movie is blank, do not add it.
Extra credit: if a movie is added that’s alreadythere, don’t do it. - listplayers.php: list all the people who appear in movies,sorted by last name and then first name, with a form where a newplayer can be added. Each name should be a link toshowmovies.php, described below.
- addplayer.php: accept input from the form in listplayers.php,add that person to the table, and redirect back to the list ofpeople.
If both the first and last name of the person is blank, do not addthem.
Extra credit: if a person is added that’s alreadythere, don’t do it. - showmovies.php: show all the movies a given person has appearedin, along with the character they played, sort in alphabeticalorder by movie title. Each movie title should be a link to theshowplayers.php file, described below.
- showplayers.php: show all the people, and the characters theyplayed, in a given movie. Add a form with a dropdown listing allthe people, and a text box for a characters first & last names,so people and their roles can be added to a movie. This should goto addrole.php, described below. Each movie title shouldbe a link to showmovies.php.
- addrole.php: Add a player to a movie. If the character’s firstand last names are both left blank, do not add them. Extracredit: if this duplicates a role already in the rolestable, do not do it. But be careful! Sometimes a given character isplayed by more than one person, where a movie may have a flashbackscene to when the character was younger. (The movieTitanic is almost entirely told in flashback, and thecharacter Rose is played by two different actresses.) Sometimes agiven player has more than one role in a film; (John Cleese playsall of the Second Swallow-Savvy Guard, The Black Knight, Peasant 3,Sir Launcelot the Brave, the Taunting French Guard, and Tim theEnchanter, in Monty Python and the Holy Grail.)
****http://elvis.rowan.edu/~kilroy/webdev/WkA.1-SQL/table_join.txt****- How the database was made
****http://elvis.rowan.edu/~kilroy/webdev/WkB.1-SQL+PHP/TR/****- Sample in class code to help
Expert Answer
Answer to Movies Database Pages On Elvis, in your /home/kilroy/public_html/webdev/Projects/albus folder, create a subfolder named …
OR