[Solved] Listmoviesphp Titles Movies Alphabetical Order Form New Title Added Title Movie Link Show Q37212423
use PHP
I. listmovies.php: all the titles of all the movies, in alphabetical order, with a form where a new title can be added. The title of each movie should be a link to showplayers.php, described below 2. addmovie.php: accept input from the form in listmovies.php, add that movie to the table, and redirect back to the list of movies. If the name of the movie is blank, do not add it. Extra credit: if a movie is added that’s already there, 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 new player can be added. Each name should be a link to showmovies.php, described below 4. addplayer.php: accept input from the form in listplayers.php, add that person to the table, and redirect back to the list of people If both the first and last name of the person is blank, do not add them. Extra credit: if a person is added that’s already there, don’t do it. 5. showmovies.php: show all the movies a given person has appeared in, along with the character they played, sort in alphabetical order by movie title. Each movie title should 6. showplayers.php: show all the people, and the characters they played, in a given movie. Add a form with a dropdown listing all the people, and a text box for a characters first 7. addrolc.php: Add a player to a movic. If the character’s first and last names are both left blank, do not add them. Extra credit: if this duplicates a role alrcady in the roles table be a link to the showplayers.php file, described below. & last names. so people and their roles can be added to a movic. This should go to addroleph , described below. Each movie title should be a link o sm и movies p do not do it. But be careful! Sometimes a given character is played by more than one person, where a movie may have a flashback scene to when the character was younger (The movie Titanic is almost entirely told in flashback, and the character Rose is played by two different actresses.) Sometimes a given player has more than one role in a film (John Cleesc plays all of the Second Swallow-Savvy Guard, The Black Knight, Pcasant 3, Sir Launcelot the Brave, the Taunting French Guard, and Tim the Enchanter, in Monty Python and the Holy Grail.) Show transcribed image text I. listmovies.php: all the titles of all the movies, in alphabetical order, with a form where a new title can be added. The title of each movie should be a link to showplayers.php, described below 2. addmovie.php: accept input from the form in listmovies.php, add that movie to the table, and redirect back to the list of movies. If the name of the movie is blank, do not add it. Extra credit: if a movie is added that’s already there, 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 new player can be added. Each name should be a link to showmovies.php, described below 4. addplayer.php: accept input from the form in listplayers.php, add that person to the table, and redirect back to the list of people If both the first and last name of the person is blank, do not add them. Extra credit: if a person is added that’s already there, don’t do it. 5. showmovies.php: show all the movies a given person has appeared in, along with the character they played, sort in alphabetical order by movie title. Each movie title should 6. showplayers.php: show all the people, and the characters they played, in a given movie. Add a form with a dropdown listing all the people, and a text box for a characters first 7. addrolc.php: Add a player to a movic. If the character’s first and last names are both left blank, do not add them. Extra credit: if this duplicates a role alrcady in the roles table be a link to the showplayers.php file, described below. & last names. so people and their roles can be added to a movic. This should go to addroleph , described below. Each movie title should be a link o sm и movies p do not do it. But be careful! Sometimes a given character is played by more than one person, where a movie may have a flashback scene to when the character was younger (The movie Titanic is almost entirely told in flashback, and the character Rose is played by two different actresses.) Sometimes a given player has more than one role in a film (John Cleesc plays all of the Second Swallow-Savvy Guard, The Black Knight, Pcasant 3, Sir Launcelot the Brave, the Taunting French Guard, and Tim the Enchanter, in Monty Python and the Holy Grail.)
Expert Answer
Answer to I. listmovies.php: all the titles of all the movies, in alphabetical order, with a form where a new title can be added. … . . .
OR
