Internet Computing HW

Internet Computing Spring 2024Homework 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