Internet Computing HW

Internet Computing Spring 2024 Homework 3 In this assignment, your task is to create a web application which can process the following movie database. This database contains only one table. Use the sql file on Canvas, also listed here, to create the database like the following The sql file — CREATE DATABASE MSU_Movies — DROP DATABASE IF EXISTS MSU_Movies; CREATE DATABASE MSU_Movies; USE MSU_Movies; — CREATE TABLE Movie; CREATE TABLE Movie ( MovieID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, MovieTitle varchar (30) NOT NULL, ReleaseDate DATE NOT NULL, Genre varchar(30) NOT NULL ); — Populate movie data INSERT INTO Movie VALUES (1, ‘Superman vs Batman’, ‘2016-03-25’, ‘Action’), (2, ‘Deadpool’, ‘2016-02-12’, ‘Comedy’), (3, ‘Furious 7’, ‘2015-04-03’, ‘Thriller’), (4, ‘PK’, ‘2014-12-19’, ‘Drama’), (5, ‘The Hangover’, ‘2009-06-05’, ‘Comedy’), (6, ‘3 Idiots’, ‘2009-12-25’, ‘Drama’), (7, ‘Spectre’, ‘2015-11-06’, ‘Thriller’), (8, ‘Batman Begins’, ‘2005-06-15’, ‘Action’), (9, ‘The Dark Knight’, ‘2008-07-18’, ‘Crime’); — Create the users and grant priveleges to those users — assume you have already run the book_apps create_db.sql file when you download from murach.com GRANT SELECT, INSERT, DELETE, UPDATE ON MSU_Movies.* TO mgs_user@localhost Your database.php file would be similar as in chapter4 except the database is now change from my_guita_shop1 to MSU_Movies. When user visit your site, the landing page like the following will be displayed. Note: PUT ALL members’ names on the second line after MSU Movie Center. Insert User can insert a new movie by click on Add A New Movie link on top of the page A web form like the following will show up Assuming we entered the following Click Insert Movie button. Your app will automatically display the newly changed move table. EDIT (update) Assuming we want to change the genre as Drama. So let’s click Edit button (the update operation) When the Edit button was pressed, the following form appeared with the information of this movie retrieved from our database. Now change Action to become Drama and click Update Movie button. Your app will automatically list all the movies again with the genre of the record updated to Action as the following The table on your database is now modified Delete Let’s delete Gladiator, the newly updated movie, by clicking on its corresponding Delete button. The result as the following. Requirements and submission: – – Use PHP as server side scripting language. Name your controller index.php Use mgs_user credential to access the MSU_Movies database. Use xampp as platform to develop your application. Put all your members’ full names below MSU Movie Center on each web page when run The bottom of each page contains copyright year of MSU as shown above Create a PPT file contains o All members’ names and contribution in percentage o List features implemented o List features did not implemented. Create a short video to demo your web site (i.e., demo insert, delete and update) Create a folder o Put all source code files, PPT file, and MP4 (YT link is even better) into the folder Zip this folder. Submit the zipped folder file to Canvas